Table of Contents

Subtables: #

FIELD NAMEDATA TYPEQUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
IdGuid
SyncTokenstring
CreateTimeDateTime
LastUpdatedTimeDateTime
sparsebool
TxnDateDateTime
TxnDateSpecifiedbool
TaxFormTypestring
TxnStatusstring
TaxFormNumstringtrue
DocNumberstringtrue
PrivateNotestringtrue
TxnSourcestringtrue
ExchangeRatedecimaltrue
ExchangeRateSpecifiedbooltrue
TransactionLocationTypestringtrue
ProcessPaymentbooltrue
ProcessPaymentSpecifiedbooltrue
UnappliedAmtdecimaltrue
UnappliedAmtSpecifiedbooltrue
TotalAmtdecimaltrue
TotalAmtSpecifiedbooltrue
PaymentRefNumstringtrue
CurrencyRef_Idstringtrue
CurrencyRef_Namestringtrue
DepartmentRef_Idstringtrue
DepartmentRef_Namestringtrue
PaymentMethodRef_Idstringtrue
PaymentMethodRef_Namestringtrue
DepositToAccountRef_Idstringtrue
DepositToAccountRef_Namestringtrue
ARAccountRef_Idstringtrue
ARAccountRef_Namestringtrue
RemitToRef_Idstringtrue
RemitToRef_Namestringtrue
CustomerRef_Idstringtrue
CustomerRef_Namestringtrue
PaymentTypestringtrue
PaymentTypeSpecifiedbooltrue
Check_CheckNumstringtrue
Check_Statusstringtrue
Check_NameOnAcctstringtrue
Check_AcctNumstringtrue
Check_BankNamestringtrue
TotalTaxdecimaltrue
TotalTaxSpecifiedbooltrue
TxnTaxCodeRef_Idstringtrue
TxnTaxCodeRef_Namestringtrue
DefaultTaxCodeRef_Idstringtrue
DefaultTaxCodeRef_Namestringtrue
CCAccountRef_Idstringtrue
CCAccountRef_Namestringtrue
NameOnAcctstringtrue
Numberstringtrue
Amountdecimaltrue
AmountSpecifiedbooltrue
Typestringtrue
PostalCodestringtrue
CcExpiryMonthinttrue
CcExpiryMonthSpecifiedbooltrue
CcExpiryYearinttrue
CcExpiryYearSpecifiedbooltrue
BillAddrStreetstringtrue
CommercialCardCodestringtrue
CCProcessPaymentbooltrue
CCProcessPaymentSpecifiedbooltrue
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
UserDatastringtrue
Operationstringtrue
LSDatastringtrue

Powered by BetterDocs