FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnIDtruefalsetruefalsefalse
TimeCreatedtruefalsetruefalsefalse
TimeModifiedtruefalsetruefalsefalse
EditSequencetruefalsetruefalsefalse
TxnNumbertruefalsefalsefalsefalse
CustomerRef_ListIDtruetrueoptionaltruetrue
CustomerRef_FullNametruetrueoptionaltruetrue
ARAccountRef_ListIDtruetrueoptionaltrueoptional
ARAccountRef_FullNametruetrueoptionaltrueoptional
TxnDatetruetrueoptionaltrueoptional
RefNumbertruetrueoptionaltrueoptional
TotalAmounttruetrueoptionaltrueoptional
CurrencyRef_ListIDtruefalsefalsefalsefalse
CurrencyRef_FullNametruefalsefalsefalsefalse
ExchangeRatetruetrueoptionaltrueoptional
TotalAmountInHomeCurrencytruefalsefalsefalsefalse
PaymentMethodRef_ListIDtruetrueoptionaltrueoptional
PaymentMethodRef_FullNametruetrueoptionaltrueoptional
Memotruetrueoptionaltrueoptional
DepositToAccountRef_ListIDtruetrueoptionaltrueoptional
DepositToAccountRef_FullNametruetrueoptionaltrueoptional
UnusedPaymenttruefalsefalsefalsefalse
CCTII_CreditCardNumbernewtruetrueoptionaltrueoptional
CCTII_ExpirationMonthnewtruetrueoptionaltrueoptional
CCTII_ExpirationYearnewtruetrueoptionaltrueoptional
CCTII_NameOnCardnewtruetrueoptionaltrueoptional
CCTII_CreditCardAddressnewtruetrueoptionaltrueoptional
CCTII_CreditCardPostalCodenewtruetrueoptionaltrueoptional
CCTII_CommercialCardCodenewtruetrueoptionaltrueoptional
CCTII_TransactionModenewtruetrueoptionaltrueoptional
CCTII_CreditCardTxnTypenewtruetrueoptionaltrueoptional
CCTRI_ResultCodenewtruetrueoptionaltrueoptional
CCTRI_ResultMessagenewtruetrueoptionaltrueoptional
CCTRI_CreditCardTransIDnewtruetrueoptionaltrueoptional
CCTRI_MerchantAccountNumbernewtruetrueoptionaltrueoptional
CCTRI_AuthorizationCodenewtruetrueoptionaltrueoptional
CCTRI_AVSStreetnewtruetrueoptionaltrueoptional
CCTRI_AVSZipnewtruetrueoptionaltrueoptional
CCTRI_CardSecurityCodeMatchnewtruetrueoptionaltrueoptional
CCTRI_ReconBatchIDnewtruetrueoptionaltrueoptional
CCTRI_PaymentGroupingCodenewtruetrueoptionaltrueoptional
CCTRI_PaymentStatusnewtruetrueoptionaltrueoptional
CCTRI_TxnAuthorizationTimenewtruetrueoptionaltrueoptional
CCTRI_TxnAuthorizationStampnewtruetrueoptionaltrueoptional
CCTRI_ClientTransIDnewtruetrueoptionaltrueoptional
CustomField1truetrueoptionaltrueoptional
CustomField2truetrueoptionaltrueoptional
CustomField3truetrueoptionaltrueoptional
CustomField4truetrueoptionaltrueoptional
CustomField5truetrueoptionaltrueoptional
CustomField6truetrueoptionaltrueoptional
CustomField7truetrueoptionaltrueoptional
CustomField8truetrueoptionaltrueoptional
CustomField9truetrueoptionaltrueoptional
CustomField10truetrueoptionaltrueoptional
CustomField11truetrueoptionaltrueoptional
CustomField12truetrueoptionaltrueoptional
CustomField13truetrueoptionaltrueoptional
CustomField14truetrueoptionaltrueoptional
CustomField15truetrueoptionaltrueoptional
ExternalGUIDtruetrueoptionaltrueoptional
UserDatauser field
Operationadd,update,delete
  • AppliedToTxnRet
  • CCTII ->CreditCardTxnInputInfo
  • CCTRI ->CreditCardTxnResultInfo
  • Adding new record: EditSequence=’ApplyAll’

If ApplyAll is set, QuickBooks applies TotalAmount to any outstanding transaction that exactly matches the total amount. If no exact match is found, the payment is applied to the customer job’s outstanding transactions, beginning with the oldest one.
If IsAutoApply isn’t set, QuickBooks receives the payment but does not apply it to any outstanding transaction. Instead, the amount will appear as a credit on the customer job’s next transaction.
Or you can set:

AppliedToTxnRet.PARENT_IDKEY -> ReceivePayment.TxnID
AppliedToTxnRet.TxnID -> Invoice.TxnID

Powered by BetterDocs