InvoiceLineRet (old ->InvoiceLineDetail)

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

Parent tables:

  • Invoice
  • InvoiceLineGroupRet

Powered by BetterDocs