FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnIDtrue
TimeCreatedtrue
TimeModifiedtrue
EditSequencetrue
TxnNumbertrue
CustomerRef_ListIDtrue
CustomerRef_FullNametrue
ARAccountRef_ListIDtrue
ARAccountRef_FullNametrue
TxnDatetrue
RefNumbertrue
TotalAmounttrue
CurrencyRef_ListIDtrue
CurrencyRef_FullNametrue
ExchangeRatetrue
TotalAmountInHomeCurrencytrue
PaymentMethodRef_ListIDtrue
PaymentMethodRef_FullNametrue
Memotrue
DepositToAccountRef_ListIDtrue
DepositToAccountRef_FullNametrue
UnusedPaymenttrue
CCTII_CreditCardNumbernewtrue
CCTII_ExpirationMonthnewtrue
CCTII_ExpirationYearnewtrue
CCTII_NameOnCardnewtrue
CCTII_CreditCardAddressnewtrue
CCTII_CreditCardPostalCodenewtrue
CCTII_CommercialCardCodenewtrue
CCTII_TransactionModenewtrue
CCTII_CreditCardTxnTypenewtrue
CCTRI_ResultCodenewtrue
CCTRI_ResultMessagenewtrue
CCTRI_CreditCardTransIDnewtrue
CCTRI_MerchantAccountNumbernewtrue
CCTRI_AuthorizationCodenewtrue
CCTRI_AVSStreetnewtrue
CCTRI_AVSZipnewtrue
CCTRI_CardSecurityCodeMatchnewtrue
CCTRI_ReconBatchIDnewtrue
CCTRI_PaymentGroupingCodenewtrue
CCTRI_PaymentStatusnewtrue
CCTRI_TxnAuthorizationTimenewtrue
CCTRI_TxnAuthorizationStampnewtrue
CCTRI_ClientTransIDnewtrue
CustomField1true
CustomField2true
CustomField3true
CustomField4true
CustomField5true
CustomField6true
CustomField7true
CustomField8true
CustomField9true
CustomField10true
CustomField11true
CustomField12true
CustomField13true
CustomField14true
CustomField15true
ExternalGUIDtrue
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