FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnIDtrue
TimeCreatedtrue
TimeModifiedtrue
EditSequencetrue
TxnNumbertrue
CustomerRef_ListIDtrue
CustomerRef_FullNametrue
ClassRef_ListIDtrue
ClassRef_FullNametrue
TemplateRef_ListIDtrue
TemplateRef_FullNametrue
TxnDatetrue
RefNumbertrue
BillAddress_Addr1true
BillAddress_Addr2true
BillAddress_Addr3true
BillAddress_Addr4true
BillAddress_Addr5true
BillAddress_Citytrue
BillAddress_Statetrue
BillAddress_PostalCodetrue
BillAddress_Countrytrue
BillAddress_Notetrue
ShipAddress_Addr1true
ShipAddress_Addr2true
ShipAddress_Addr3true
ShipAddress_Addr4true
ShipAddress_Addr5true
ShipAddress_Citytrue
ShipAddress_Statetrue
ShipAddress_PostalCodetrue
ShipAddress_Countrytrue
ShipAddress_Notetrue
IsPendingtrue
CheckNumbertrue
PaymentMethodRef_ListIDtrue
PaymentMethodRef_FullNametrue
DueDatetrue
SalesRepRef_ListIDtrue
SalesRepRef_FullNametrue
ShipDatetrue
ShipMethodRef_ListIDtrue
ShipMethodRef_FullNametrue
FOBtrue
Subtotaltrue
ItemSalesTaxRef_ListIDtrue
ItemSalesTaxRef_FullNametrue
SalesTaxPercentagetrue
SalesTaxTotaltrue
TotalAmounttrue
CurrencyRef_ListIDtrue
CurrencyRef_FullNametrue
ExchangeRatetrue
TotalAmountInHomeCurrencytrue
Memotrue
CustomerMsgRef_ListIDtrue
CustomerMsgRef_FullNametrue
IsToBePrintedtrue
IsToBeEmailedtrue
IsTaxIncludedtrue
CustSalesTaxCodeRef_ListIDtrue
CustSalesTaxCodeRef_FullNametrue
DepositToAccountRef_ListIDtrue
DepositToAccountRef_FullNametrue
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
Othertrue
CustomField1true
CustomField2true
CustomField3true
CustomField4true
CustomField5true
CustomField6true
CustomField7true
CustomField8true
CustomField9true
CustomField10true
CustomField11true
CustomField12true
CustomField13true
CustomField14true
CustomField15true
ExternalGUIDtrue
UserDatauser field
Operationadd,update,delete
  • SalesReceiptLineRet
  • SalesReceiptLineGroupRet

Powered by BetterDocs