PurchaseOrderLineRet

PurchaseOrderLineRet (old ->PurchaseOrderLineDetail)

FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnLineIDtrue
ItemRef_ListIDtrue
ItemRef_FullNametrue
ManufacturerPartNumbertrue
Desctrue
Quantitytrue
UnitOfMeasuretrue
OverrideUOMSetRef_ListIDtrue
OverrideUOMSetRef_FullNametrue
Ratetrue
ClassRef_ListIDtrue
ClassRef_FullNametrue
Amounttrue
CustomerRef_ListIDtrue
CustomerRef_FullNametrue
ServiceDatetrue
SalesTaxCodeRef_ListIDtrue
SalesTaxCodeRef_FullNametrue
ReceivedQuantitytrue
IsBilledtrue
Other1true
Other2true
IsManuallyClosedtrue
UnbilledQuantitytrue
InvSiteLocRef_ListIDInventorySiteLocationRef_ListIDtrue
InvSiteLocRef_FullNameInventorySiteLocationRef_FullNametrue
CustomField1true
CustomField2true
CustomField3true
CustomField4true
CustomField5true
CustomField6true
CustomField7true
CustomField8true
CustomField9true
CustomField10true
CustomField11true
CustomField12true
CustomField13true
CustomField14true
CustomField15true
PARENT_IDKEYIDKEY
GroupPARENT_IDKEYGroupIDKEY
SeqNumkeeps the seq

Parent tables:

  • PurchaseOrder
  • PurchaseOrderLineGroupRet

Powered by BetterDocs