InvoiceLineRet (old ->InvoiceLineDetail)

FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnLineIDtrue
ItemRef_ListIDtrue
ItemRef_FullNametrue
Desctrue
Quantitytrue
UnitOfMeasuretrue
OverrideUOMSetRef_ListIDtrue
OverrideUOMSetRef_FullNametrue
Ratetrue
RatePercenttrue
ClassRef_ListIDtrue
ClassRef_FullNametrue
Amounttrue
TaxAmounttrue
InvSiteRef_ListIDInventorySiteRef_ListIDtrue
InvSiteRef_FullNameInventorySiteRef_FullNametrue
InvSiteLocRef_ListIDInventorySiteLocRef_ListIDtrue
InvSiteLocRef_FullNameInventorySiteLocRef_FullNametrue
SerialNumbertrue
LotNumbertrue
ServiceDatetrue
SalesTaxCodeRef_ListIDtrue
SalesTaxCodeRef_FullNametrue
IsTaxabletrue
Other1true
Other2true
LinkToTxn_TxnIDLinkToTxnIDtrue
LinkToTxn_TxnLineIDLinkToTxnLineIDtrue
CustomField1true
CustomField2true
CustomField3true
CustomField4true
CustomField5true
CustomField6true
CustomField7true
CustomField8true
CustomField9true
CustomField10true
CustomField11true
CustomField12true
CustomField13true
CustomField14true
CustomField15true
PARENT_IDKEYIDKEY
GroupPARENT_IDKEYGroupIDKEY
SeqNumkeeps the seq

Parent tables:

  • Invoice
  • InvoiceLineGroupRet

Powered by BetterDocs