InvoiceLineRet (old ->InvoiceLineDetail)
FIELD NAME | FIELD NAME (old) | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
TxnLineID | true | false | ||||
ItemRef_ListID | true | true | ||||
ItemRef_FullName | true | true | ||||
Desc | true | true | ||||
Quantity | true | true | ||||
UnitOfMeasure | true | true | ||||
OverrideUOMSetRef_ListID | true | true | ||||
OverrideUOMSetRef_FullName | true | true | ||||
Rate | true | true | ||||
RatePercent | true | true | ||||
ClassRef_ListID | true | true | ||||
ClassRef_FullName | true | true | ||||
Amount | true | true | ||||
TaxAmount | true | false | ||||
InvSiteRef_ListID | InventorySiteRef_ListID | true | true | |||
InvSiteRef_FullName | InventorySiteRef_FullName | true | true | |||
InvSiteLocRef_ListID | InventorySiteLocRef_ListID | true | true | |||
InvSiteLocRef_FullName | InventorySiteLocRef_FullName | true | true | |||
SerialNumber | true | true | ||||
LotNumber | true | true | ||||
ServiceDate | true | true | ||||
SalesTaxCodeRef_ListID | true | true | ||||
SalesTaxCodeRef_FullName | true | true | ||||
IsTaxable | true | false | ||||
Other1 | true | true | ||||
Other2 | true | true | ||||
LinkToTxn_TxnID | LinkToTxnID | true | false | |||
LinkToTxn_TxnLineID | LinkToTxnLineID | true | false | |||
CustomField1 | true | true | ||||
CustomField2 | true | true | ||||
CustomField3 | true | true | ||||
CustomField4 | true | true | ||||
CustomField5 | true | true | ||||
CustomField6 | true | true | ||||
CustomField7 | true | true | ||||
CustomField8 | true | true | ||||
CustomField9 | true | true | ||||
CustomField10 | true | true | ||||
CustomField11 | true | true | ||||
CustomField12 | true | true | ||||
CustomField13 | true | true | ||||
CustomField14 | true | true | ||||
CustomField15 | true | true | ||||
PARENT_IDKEY | IDKEY | |||||
GroupPARENT_IDKEY | GroupIDKEY | |||||
SeqNum | keeps the seq |
Parent tables:
- Invoice
- InvoiceLineGroupRet