SalesOrderLineRet (old ->SalesOrderLineDetail)

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
InvSiteRef_ListIDtrue
InvSiteRef_FullNametrue
InvSiteLocRef_ListIDtrue
InvSiteLocRef_FullNametrue
SerialNumbertrue
LotNumbertrue
SalesTaxCodeRef_ListIDtrue
SalesTaxCodeRef_FullNametrue
Invoicedtrue
IsManuallyClosedtrue
Other1true
Other2true
CustomField1true
CustomField2true
CustomField3true
CustomField4true
CustomField5true
CustomField6true
CustomField7true
CustomField8true
CustomField9true
CustomField10true
CustomField11true
CustomField12true
CustomField13true
CustomField14true
CustomField15true
PARENT_IDKEYIDKEY
GroupPARENT_IDKEYGroupIDKEY
SeqNumkeeps the seq

Parent tables:

  • SalesOrder
  • SalesOrderLineGroupRet

Powered by BetterDocs