Sub table:
TxnID <!– required –>
RefundAmount (Amount) <!– required –>
CreditCardTxnInputInfo -> CCTII
CreditCardTxnResultInfo -> CCTRI
| FIELD NAME | FIELD NAME (old) | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
| TxnID | true | false | false | false | false | |
| TimeCreated | true | false | false | false | false | |
| TimeModified | true | false | false | false | false | |
| EditSequence | true | false | false | false | false | |
| TxnNumber | true | false | false | false | false | |
| CustomerRef_ListID | true | false | false | true | true | |
| CustomerRef_FullName | true | false | false | true | true | |
| RefundFromAccountRef_ListID | true | false | false | true | optional | |
| RefundFromAccountRef_FullName | true | false | false | true | optional | |
| ARAccountRef_ListID | true | false | false | true | optional | |
| ARAccountRef_FullName | true | false | false | true | optional | |
| TxnDate | true | false | false | true | optional | |
| RefNumber | true | false | false | true | optional | |
| TotalAmount | true | false | false | false | false | |
| Address_Addr1 | true | false | false | true | optional | |
| Address_Addr2 | true | false | false | true | optional | |
| Address_Addr3 | true | false | false | true | optional | |
| Address_Addr4 | true | false | false | true | optional | |
| Address_Addr5 | true | false | false | true | optional | |
| Address_City | true | false | false | true | optional | |
| Address_State | true | false | false | true | optional | |
| Address_PostalCode | true | false | false | true | optional | |
| Address_Country | true | false | false | true | optional | |
| Address_Note | true | false | false | true | optional | |
| PaymentMethodRef_ListID | true | false | false | true | optional | |
| PaymentMethodRef_FullName | true | false | false | true | optional | |
| Memo | true | false | false | true | optional | |
| CCTII_CreditCardNumber | new | true | false | false | true | optional |
| CCTII_ExpirationMonth | new | true | false | false | true | optional |
| CCTII_ExpirationYear | new | true | false | false | true | optional |
| CCTII_NameOnCard | new | true | false | false | true | optional |
| CCTII_CreditCardAddress | new | true | false | false | true | optional |
| CCTII_CreditCardPostalCode | new | true | false | false | true | optional |
| CCTII_CommercialCardCode | new | true | false | false | true | optional |
| CCTII_TransactionMode | new | true | false | false | true | optional |
| CCTII_CreditCardTxnType | new | true | false | false | true | optional |
| CCTRI_ResultCode | new | true | false | false | true | optional |
| CCTRI_ResultMessage | new | true | false | false | true | optional |
| CCTRI_CreditCardTransID | new | true | false | false | true | optional |
| CCTRI_MerchantAccountNumber | new | true | false | false | true | optional |
| CCTRI_AuthorizationCode | new | true | false | false | true | optional |
| CCTRI_AVSStreet | new | true | false | false | true | optional |
| CCTRI_AVSZip | new | true | false | false | true | optional |
| CCTRI_CardSecurityCodeMatch | new | true | false | false | true | optional |
| CCTRI_ReconBatchID | new | true | false | false | true | optional |
| CCTRI_PaymentGroupingCode | new | true | false | false | true | optional |
| CCTRI_PaymentStatus | new | true | false | false | true | optional |
| CCTRI_TxnAuthorizationTime | new | true | false | false | true | optional |
| CCTRI_TxnAuthorizationStamp | new | true | false | false | true | optional |
| CCTRI_ClientTransID | new | true | false | false | true | optional |
| TotalAmountInHomeCurrency | true | false | false | true | optional | |
| ExchangeRate | true | false | false | true | optional | |
| CurrencyRef_ListID | true | false | false | false | false | |
| CurrencyRef_FullName | true | false | false | false | false | |
| ExternalGUID | true | false | false | true | optional | |
| UserData | user field | |||||
| Operation | add, delete, refresh, void |