SalesReceipt

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