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, refresh, void |