Table of Contents

Subtables: #

FIELD NAMEDATA TYPEQUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
Idstringtrue
SyncTokenstringtrue
CreateTimeDateTimetrue
LastUpdatedTimeDateTimetrue
sparsebooltrue
Namestringtrue
Creditbooltrue
CreditSpecifiedbooltrue
TxnIdstringtrue
TxnNumstringtrue
Memostringtrue
TxnDateDateTimetrue
TxnDateSpecifiedbooltrue
DocNumberstringtrue
TransactionLocationTypestringtrue
ExchangeRatedecimaltrue
ExchangeRateSpecifiedbooltrue
PrintStatusstringtrue
PrintStatusSpecifiedbooltrue
GlobalTaxCalculationstringtrue
GlobalTaxCalculationSpecifiedbooltrue
LessCISdecimaltrue
LessCISSpecifiedbooltrue
TotalAmtdecimaltrue
TotalAmtSpecifiedbooltrue
PaymentTypestringtrue
PaymentTypeSpecifiedbooltrue
TxnSourcestringtrue
TaxFormTypestringtrue
TxnStatusstringtrue
TaxFormNumstringtrue
PrivateNotestringtrue
PaymentRefNumstringtrue
CurrencyRef_Idstringtrue
CurrencyRef_Namestringtrue
DepartmentRef_Idstringtrue
DepartmentRef_Namestringtrue
EntityRef_Idstringtrue
EntityRef_Namestringtrue
PaymentMethodRef_Idstringtrue
PaymentMethodRef_Namestringtrue
AccountRef_Idstringtrue
AccountRef_Namestringtrue
Check_CheckNumstringtrue
Check_Statusstringtrue
Check_NameOnAcctstringtrue
Check_AcctNumstringtrue
Check_BankNamestringtrue
RemitToAddr_Idstringtrue
RemitToAddr_Line1stringtrue
RemitToAddr_Line2stringtrue
RemitToAddr_Line3stringtrue
RemitToAddr_Line4stringtrue
RemitToAddr_Line5stringtrue
RemitToAddr_Citystringtrue
RemitToAddr_Countrystringtrue
RemitToAddr_PostalCodestringtrue
RemitToAddr_CountryCodestringtrue
RemitToAddr_CountrySubDivisionCodestringtrue
RemitToAddr_PostalCodeSuffixstringtrue
RemitToAddr_Longstringtrue
RemitToAddr_Latstringtrue
RemitToAddr_Notestringtrue
RemitToAddr_Tagstringtrue
TotalTaxdecimaltrue
TotalTaxSpecifiedbooltrue
TxnTaxCodeRef_Idstringtrue
TxnTaxCodeRef_Namestringtrue
DefaultTaxCodeRef_Idstringtrue
DefaultTaxCodeRef_Namestringtrue
CCAccountRef_Idstringtrue
CCAccountRef_Namestringtrue
NameOnAcctstringtrue
Numberstringtrue
Amountdecimaltrue
AmountSpecifiedbooltrue
ProcessPaymentbooltrue
ProcessPaymentSpecifiedbooltrue
Typestringtrue
PostalCodestringtrue
CcExpiryMonthinttrue
CcExpiryMonthSpecifiedbooltrue
CcExpiryYearinttrue
CcExpiryYearSpecifiedbooltrue
BillAddrStreetstringtrue
CommercialCardCodestringtrue
CCTxnModestringtrue
CCTxnModeSpecifiedbooltrue
CCTxnTypestringtrue
CCTxnTypeSpecifiedbooltrue
PrevCCTransIdstringtrue
TxnAuthorizationTimeDateTimetrue
TxnAuthorizationTimeSpecifiedbooltrue
TxnAuthorizationStampinttrue
TxnAuthorizationStampSpecifiedbooltrue
PaymentGroupingCodeinttrue
PaymentGroupingCodeSpecifiedbooltrue
ReconBatchIdstringtrue
SecurityCodestringtrue
AvsZipstringtrue
AvsZipSpecifiedbooltrue
AvsStreetstringtrue
AvsStreetSpecifiedbooltrue
AuthCodestringtrue
CardSecurityCodeMatchstringtrue
CardSecurityCodeMatchSpecifiedbooltrue
MerchantAcctNumstringtrue
ResultMsgstringtrue
ResultCodeinttrue
ResultCodeSpecifiedbooltrue
Statusstringtrue
StatusSpecifiedbooltrue
CCTransIdstringtrue
CCProcessorstringtrue
ClientTransIDstringtrue
CustomField1stringtrue
CustomField2stringtrue
CustomField3stringtrue
CustomField4stringtrue
CustomField5stringtrue
CustomField6stringtrue
CustomField7stringtrue
CustomField8stringtrue
CustomField9stringtrue
CustomField10stringtrue
UserDatastringtrue
Operationstringtrue
LSDatastringtrue

Powered by BetterDocs