| FIELD NAME | FIELD NAME (old) | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
| TxnID | true | false | true | false | false | |
| TimeCreated | true | false | true | false | false | |
| TimeModified | true | false | true | false | false | |
| EditSequence | true | false | true | false | false | |
| TxnNumber | true | false | false | false | false | |
| CustomerRef_ListID | true | true | optional | true | true | |
| CustomerRef_FullName | true | true | optional | true | true | |
| ARAccountRef_ListID | true | true | optional | true | optional | |
| ARAccountRef_FullName | true | true | optional | true | optional | |
| TxnDate | true | true | optional | true | optional | |
| RefNumber | true | true | optional | true | optional | |
| TotalAmount | true | true | optional | true | optional | |
| CurrencyRef_ListID | true | false | false | false | false | |
| CurrencyRef_FullName | true | false | false | false | false | |
| ExchangeRate | true | true | optional | true | optional | |
| TotalAmountInHomeCurrency | true | false | false | false | false | |
| PaymentMethodRef_ListID | true | true | optional | true | optional | |
| PaymentMethodRef_FullName | true | true | optional | true | optional | |
| Memo | true | true | optional | true | optional | |
| DepositToAccountRef_ListID | true | true | optional | true | optional | |
| DepositToAccountRef_FullName | true | true | optional | true | optional | |
| UnusedPayment | true | false | false | false | false | |
| CCTII_CreditCardNumber | new | true | true | optional | true | optional |
| CCTII_ExpirationMonth | new | true | true | optional | true | optional |
| CCTII_ExpirationYear | new | true | true | optional | true | optional |
| CCTII_NameOnCard | new | true | true | optional | true | optional |
| CCTII_CreditCardAddress | new | true | true | optional | true | optional |
| CCTII_CreditCardPostalCode | new | true | true | optional | true | optional |
| CCTII_CommercialCardCode | new | true | true | optional | true | optional |
| CCTII_TransactionMode | new | true | true | optional | true | optional |
| CCTII_CreditCardTxnType | new | true | true | optional | true | optional |
| CCTRI_ResultCode | new | true | true | optional | true | optional |
| CCTRI_ResultMessage | new | true | true | optional | true | optional |
| CCTRI_CreditCardTransID | new | true | true | optional | true | optional |
| CCTRI_MerchantAccountNumber | new | true | true | optional | true | optional |
| CCTRI_AuthorizationCode | new | true | true | optional | true | optional |
| CCTRI_AVSStreet | new | true | true | optional | true | optional |
| CCTRI_AVSZip | new | true | true | optional | true | optional |
| CCTRI_CardSecurityCodeMatch | new | true | true | optional | true | optional |
| CCTRI_ReconBatchID | new | true | true | optional | true | optional |
| CCTRI_PaymentGroupingCode | new | true | true | optional | true | optional |
| CCTRI_PaymentStatus | new | true | true | optional | true | optional |
| CCTRI_TxnAuthorizationTime | new | true | true | optional | true | optional |
| CCTRI_TxnAuthorizationStamp | new | true | true | optional | true | optional |
| CCTRI_ClientTransID | new | true | true | optional | true | optional |
| CustomField1 | true | true | optional | true | optional | |
| CustomField2 | true | true | optional | true | optional | |
| CustomField3 | true | true | optional | true | optional | |
| CustomField4 | true | true | optional | true | optional | |
| CustomField5 | true | true | optional | true | optional | |
| CustomField6 | true | true | optional | true | optional | |
| CustomField7 | true | true | optional | true | optional | |
| CustomField8 | true | true | optional | true | optional | |
| CustomField9 | true | true | optional | true | optional | |
| CustomField10 | true | true | optional | true | optional | |
| CustomField11 | true | true | optional | true | optional | |
| CustomField12 | true | true | optional | true | optional | |
| CustomField13 | true | true | optional | true | optional | |
| CustomField14 | true | true | optional | true | optional | |
| CustomField15 | true | true | optional | true | optional | |
| ExternalGUID | true | true | optional | true | optional | |
| UserData | user field | |||||
| Operation | add,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
