Sub tables:
- SalesReceiptLineRet
- SalesReceiptLineGroupRet
FIELD NAME | FIELD NAME (old) | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
TxnID | true | |||||
TimeCreated | true | |||||
TimeModified | true | |||||
EditSequence | true | |||||
TxnNumber | true | |||||
CustomerRef_ListID | true | |||||
CustomerRef_FullName | true | |||||
ClassRef_ListID | true | |||||
ClassRef_FullName | true | |||||
TemplateRef_ListID | true | |||||
TemplateRef_FullName | true | |||||
TxnDate | true | |||||
RefNumber | true | |||||
BillAddress_Addr1 | true | |||||
BillAddress_Addr2 | true | |||||
BillAddress_Addr3 | true | |||||
BillAddress_Addr4 | true | |||||
BillAddress_Addr5 | true | |||||
BillAddress_City | true | |||||
BillAddress_State | true | |||||
BillAddress_PostalCode | true | |||||
BillAddress_Country | true | |||||
BillAddress_Note | true | |||||
ShipAddress_Addr1 | true | |||||
ShipAddress_Addr2 | true | |||||
ShipAddress_Addr3 | true | |||||
ShipAddress_Addr4 | true | |||||
ShipAddress_Addr5 | true | |||||
ShipAddress_City | true | |||||
ShipAddress_State | true | |||||
ShipAddress_PostalCode | true | |||||
ShipAddress_Country | true | |||||
ShipAddress_Note | true | |||||
IsPending | true | |||||
CheckNumber | true | |||||
PaymentMethodRef_ListID | true | |||||
PaymentMethodRef_FullName | true | |||||
DueDate | true | |||||
SalesRepRef_ListID | true | |||||
SalesRepRef_FullName | true | |||||
ShipDate | true | |||||
ShipMethodRef_ListID | true | |||||
ShipMethodRef_FullName | true | |||||
FOB | true | |||||
Subtotal | true | |||||
ItemSalesTaxRef_ListID | true | |||||
ItemSalesTaxRef_FullName | true | |||||
SalesTaxPercentage | true | |||||
SalesTaxTotal | true | |||||
TotalAmount | true | |||||
CurrencyRef_ListID | true | |||||
CurrencyRef_FullName | true | |||||
ExchangeRate | true | |||||
TotalAmountInHomeCurrency | true | |||||
Memo | true | |||||
CustomerMsgRef_ListID | true | |||||
CustomerMsgRef_FullName | true | |||||
IsToBePrinted | true | |||||
IsToBeEmailed | true | |||||
IsTaxIncluded | true | |||||
CustSalesTaxCodeRef_ListID | true | |||||
CustSalesTaxCodeRef_FullName | true | |||||
DepositToAccountRef_ListID | true | |||||
DepositToAccountRef_FullName | true | |||||
CCTII_CreditCardNumber | true | |||||
CCTII_ExpirationMonth | true | |||||
CCTII_ExpirationYear | true | |||||
CCTII_NameOnCard | true | |||||
CCTII_CreditCardAddress | true | |||||
CCTII_CreditCardPostalCode | true | |||||
CCTII_CommercialCardCode | true | |||||
CCTII_TransactionMode | true | |||||
CCTII_CreditCardTxnType | true | |||||
CCTRI_ResultCode | true | |||||
CCTRI_ResultMessage | true | |||||
CCTRI_CreditCardTransID | true | |||||
CCTRI_MerchantAccountNumber | true | |||||
CCTRI_AuthorizationCode | true | |||||
CCTRI_AVSStreet | true | |||||
CCTRI_AVSZip | true | |||||
CCTRI_CardSecurityCodeMatch | true | |||||
CCTRI_ReconBatchID | true | |||||
CCTRI_PaymentGroupingCode | true | |||||
CCTRI_PaymentStatus | true | |||||
CCTRI_TxnAuthorizationTime | true | |||||
CCTRI_TxnAuthorizationStamp | true | |||||
CCTRI_ClientTransID | true | |||||
Other | true | |||||
CustomField1 | true | |||||
CustomField2 | true | |||||
CustomField3 | true | |||||
CustomField4 | true | |||||
CustomField5 | true | |||||
CustomField6 | true | |||||
CustomField7 | true | |||||
CustomField8 | true | |||||
CustomField9 | true | |||||
CustomField10 | true | |||||
CustomField11 | true | |||||
CustomField12 | true | |||||
CustomField13 | true | |||||
CustomField14 | true | |||||
CustomField15 | true | |||||
ExternalGUID | true | |||||
UserData | user field | |||||
Operation | add,update,delete |