View Categories

ItemLineRet

< 1 min read

ItemLineRet(old ->TxnItemLineDetail)

FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnLineIDtrue
ItemRef_ListIDtrue
ItemRef_FullNametrue
SalesRepRef_ListIDtrue
SalesRepRef_FullNametrue
InvSiteRef_ListIDInventorySiteRef_ListIDtrue
InvSiteRef_FullNameInventorySiteRef_FullNametrue
InvSiteLocRef_ListIDInventorySiteLocationRef_ListIDtrue
InvSiteLocRef_FullNameInventorySiteLocationRef_FullNametrue
SerialNumbertrue
LotNumbertrue
Desctrue
Quantitytrue
UnitOfMeasuretrue
OverrideUOMSetRef_ListIDtrue
OverrideUOMSetRef_FullNametrue
Costtrue
Amounttrue
CustomerRef_ListIDtrue
CustomerRef_FullNametrue
ClassRef_ListIDtrue
ClassRef_FullNametrue
SalesTaxCodeRef_ListIDtrue
SalesTaxCodeRef_FullNametrue
BillableStatustrue
LinkedTxnIDtrue
LinkedTxnLineIDtrue
CustomField1true
CustomField2true
CustomField3true
CustomField4true
CustomField5true
CustomField6true
CustomField7true
CustomField8true
CustomField9true
CustomField10true
CustomField11true
CustomField12true
CustomField13true
CustomField14true
CustomField15true
PARENT_IDKEYIDKEY
GroupPARENT_IDKEYGroupIDKEY
SeqNumkeeps the seq

Parent tables:

  • Bill
  • Check
  • CreditCardCharge
  • CreditCardCredit
  • ItemGroupLineRet
  • ItemReceipt
  • VendorCredit

Powered by BetterDocs