SalesOrderLineRet

SalesOrderLineRet (old ->SalesOrderLineDetail)

FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnLineIDtruefalseoptionalfalseoptional
ItemRef_ListIDtruetrueoptionaltrueoptional
ItemRef_FullNametruetrueoptionaltrueoptional
Desctruetrueoptionaltrueoptional
Quantitytruetrueoptionaltrueoptional
UnitOfMeasuretruetrueoptionaltrueoptional
OverrideUOMSetRef_ListIDtruetrueoptionalfalsefalse
OverrideUOMSetRef_FullNametruetrueoptionalfalsefalse
Ratetruetrueoptionaltrueoptional
RatePercenttruetrueoptionaltrueoptional
ClassRef_ListIDtruetrueoptionaltrueoptional
ClassRef_FullNametruetrueoptionaltrueoptional
Amounttruetrueoptionaltrueoptional
InvSiteRef_ListIDtruetrueoptionaltrueoptional
InvSiteRef_FullNametruetrueoptionaltrueoptional
InvSiteLocRef_ListIDtruetrueoptionaltrueoptional
InvSiteLocRef_FullNametruetrueoptionaltrueoptional
SerialNumbertruetrueoptionaltrueoptional
LotNumbertruetrueoptionaltrueoptional
SalesTaxCodeRef_ListIDtruetrueoptionaltrueoptional
SalesTaxCodeRef_FullNametruetrueoptionaltrueoptional
Invoicedtruefalseoptionalfalsefalse
IsManuallyClosedtruetrueoptionaltrueoptional
Other1truetrueoptionaltrueoptional
Other2truetrueoptionaltrueoptional
CustomField1truetrueoptionaltrueoptional
CustomField2truetrueoptionaltrueoptional
CustomField3truetrueoptionaltrueoptional
CustomField4truetrueoptionaltrueoptional
CustomField5truetrueoptionaltrueoptional
CustomField6truetrueoptionaltrueoptional
CustomField7truetrueoptionaltrueoptional
CustomField8truetrueoptionaltrueoptional
CustomField9truetrueoptionaltrueoptional
CustomField10truetrueoptionaltrueoptional
CustomField11truetrueoptionaltrueoptional
CustomField12truetrueoptionaltrueoptional
CustomField13truetrueoptionaltrueoptional
CustomField14truetrueoptionaltrueoptional
CustomField15truetrueoptionaltrueoptional
PARENT_IDKEYIDKEY
GroupPARENT_IDKEYGroupIDKEY
SeqNumkeeps the seq

Parent tables:

  • SalesOrder
  • SalesOrderLineGroupRet

Powered by BetterDocs