Sub table:
- AppliedToTxnRet
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 |