Table of Contents
Subtables: #
FIELD NAME | DATA TYPE | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
Id | Guid | |||||
SyncToken | string | |||||
CreateTime | DateTime | |||||
LastUpdatedTime | DateTime | |||||
sparse | bool | |||||
TxnDate | DateTime | |||||
TxnDateSpecified | bool | |||||
TaxFormType | string | |||||
TxnStatus | string | |||||
TaxFormNum | string | true | ||||
DocNumber | string | true | ||||
PrivateNote | string | true | ||||
TxnSource | string | true | ||||
ExchangeRate | decimal | true | ||||
ExchangeRateSpecified | bool | true | ||||
TransactionLocationType | string | true | ||||
ProcessPayment | bool | true | ||||
ProcessPaymentSpecified | bool | true | ||||
UnappliedAmt | decimal | true | ||||
UnappliedAmtSpecified | bool | true | ||||
TotalAmt | decimal | true | ||||
TotalAmtSpecified | bool | true | ||||
PaymentRefNum | string | true | ||||
CurrencyRef_Id | string | true | ||||
CurrencyRef_Name | string | true | ||||
DepartmentRef_Id | string | true | ||||
DepartmentRef_Name | string | true | ||||
PaymentMethodRef_Id | string | true | ||||
PaymentMethodRef_Name | string | true | ||||
DepositToAccountRef_Id | string | true | ||||
DepositToAccountRef_Name | string | true | ||||
ARAccountRef_Id | string | true | ||||
ARAccountRef_Name | string | true | ||||
RemitToRef_Id | string | true | ||||
RemitToRef_Name | string | true | ||||
CustomerRef_Id | string | true | ||||
CustomerRef_Name | string | true | ||||
PaymentType | string | true | ||||
PaymentTypeSpecified | bool | true | ||||
Check_CheckNum | string | true | ||||
Check_Status | string | true | ||||
Check_NameOnAcct | string | true | ||||
Check_AcctNum | string | true | ||||
Check_BankName | string | true | ||||
TotalTax | decimal | true | ||||
TotalTaxSpecified | bool | true | ||||
TxnTaxCodeRef_Id | string | true | ||||
TxnTaxCodeRef_Name | string | true | ||||
DefaultTaxCodeRef_Id | string | true | ||||
DefaultTaxCodeRef_Name | string | true | ||||
CCAccountRef_Id | string | true | ||||
CCAccountRef_Name | string | true | ||||
NameOnAcct | string | true | ||||
Number | string | true | ||||
Amount | decimal | true | ||||
AmountSpecified | bool | true | ||||
Type | string | true | ||||
PostalCode | string | true | ||||
CcExpiryMonth | int | true | ||||
CcExpiryMonthSpecified | bool | true | ||||
CcExpiryYear | int | true | ||||
CcExpiryYearSpecified | bool | true | ||||
BillAddrStreet | string | true | ||||
CommercialCardCode | string | true | ||||
CCProcessPayment | bool | true | ||||
CCProcessPaymentSpecified | bool | true | ||||
CCTxnMode | string | true | ||||
CCTxnModeSpecified | bool | true | ||||
CCTxnType | string | true | ||||
CCTxnTypeSpecified | bool | true | ||||
PrevCCTransId | string | true | ||||
TxnAuthorizationTime | DateTime | true | ||||
TxnAuthorizationTimeSpecified | bool | true | ||||
TxnAuthorizationStamp | int | true | ||||
TxnAuthorizationStampSpecified | bool | true | ||||
PaymentGroupingCode | int | true | ||||
PaymentGroupingCodeSpecified | bool | true | ||||
ReconBatchId | string | true | ||||
SecurityCode | string | true | ||||
AvsZip | string | true | ||||
AvsZipSpecified | bool | true | ||||
AvsStreet | string | true | ||||
AvsStreetSpecified | bool | true | ||||
AuthCode | string | true | ||||
CardSecurityCodeMatch | string | true | ||||
CardSecurityCodeMatchSpecified | bool | true | ||||
MerchantAcctNum | string | true | ||||
ResultMsg | string | true | ||||
ResultCode | int | true | ||||
ResultCodeSpecified | bool | true | ||||
Status | string | true | ||||
StatusSpecified | bool | true | ||||
CCTransId | string | true | ||||
CCProcessor | string | true | ||||
ClientTransID | string | true | ||||
UserData | string | true | ||||
Operation | string | true | ||||
LSData | string | true |