SalesReceiptLineRet

SalesReceiptLineRet (old ->SalesReceiptLineDetail)

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
TaxAmounttrue
InvSiteRef_ListIDtrue
InvSiteRef_FullNametrue
InvSiteLocRef_ListIDtrue
InvSiteLocRef_FullNametrue
SerialNumbertrue
LotNumbertrue
ServiceDatetrue
SalesTaxCodeRef_ListIDtrue
SalesTaxCodeRef_FullNametrue
Other1true
Other2true
CCTII_CreditCardNumbertrue
CCTII_ExpirationMonthtrue
CCTII_ExpirationYeartrue
CCTII_NameOnCardtrue
CCTII_CreditCardAddresstrue
CCTII_CreditCardPostalCodetrue
CCTII_CommercialCardCodetrue
CCTII_TransactionModetrue
CCTII_CreditCardTxnTypetrue
CCTRI_ResultCodetrue
CCTRI_ResultMessagetrue
CCTRI_CreditCardTransIDtrue
CCTRI_MerchantAccountNumbertrue
CCTRI_AuthorizationCodetrue
CCTRI_AVSStreettrue
CCTRI_AVSZiptrue
CCTRI_CardSecurityCodeMatchtrue
CCTRI_ReconBatchIDtrue
CCTRI_PaymentGroupingCodetrue
CCTRI_PaymentStatustrue
CCTRI_TxnAuthorizationTimetrue
CCTRI_TxnAuthorizationStamptrue
CCTRI_ClientTransIDtrue
CustomField1true
CustomField2true
CustomField3true
CustomField4true
CustomField5true
CustomField6true
CustomField7true
CustomField8true
CustomField9true
CustomField10true
CustomField11true
CustomField12true
CustomField13true
CustomField14true
CustomField15true
PARENT_IDKEYIDKEY
GroupPARENT_IDKEYGroupIDKEY
SeqNumkeeps the seq

Parent tables:

  • SalesReceipt

Powered by BetterDocs