ARRefundCreditCard Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
TxnID12VARCHAR36TrueFalseFalseFalse%s1.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s1.0US, CA, UK
TxnNumber4INTEGER9TrueFalseFalseFalse%11.0f1.0US, CA, UK
CustomerRef_ListID12VARCHAR36TrueFalseTrueTrue%sListID1.0US, CA, UK
CustomerRef_FullName12VARCHAR209TrueFalseTrueTrue%sFullName1.0US, CA, UK
RefundFromAccountRef_ListID12VARCHAR36TrueFalseTrueFalse%sListID1.0US, CA, UK
RefundFromAccountRef_FullName12VARCHAR159TrueFalseTrueFalse%sFullName1.0US, CA, UK
ARAccountRef_ListID12VARCHAR36TrueFalseTrueFalse%sListID1.0US, CA, UK
ARAccountRef_FullName12VARCHAR159TrueFalseTrueFalse%sFullName1.0US, CA, UK
CurrencyRef_ListID12VARCHAR36TrueFalseTrueFalse%sListID9.0US, CA, UK
CurrencyRef_FullName12VARCHAR64TrueFalseTrueFalse%sName9.0US, CA, UK
ExchangeRate2NUMERIC18TrueFalseFalseFalse%10.2f1.0US, CA, UK
TotalAmountInHomeCurrency2NUMERIC15TrueFalseFalseFalse%10.2f1.0US, CA, UK
TxnDate91DATE10TrueFalseTrueFalseCCCC-MM-DD1.0US, CA, UK
TxnDateMacro12VARCHAR25TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYear
ThisFiscalYearToDate
Yes -->terday
LastWeek
LastWeekToDate
LastMonth
LastMonthToDate
LastCalendarQuarter
LastCalendarQuarterToDate
LastFiscalQuarter
LastFiscalQuarterToDate
LastCalendarYear
LastCalendarYearToDate
LastFiscalYear
LastFiscalYearToDate
NextWeek
NextFourWeeks
NextMonth
NextCalendarQuarter
NextCalendarYear
NextFiscalQuarter
NextFiscalYear
1.0US, CA, UK
RefNumber12VARCHAR11TrueFalseTrueFalse%s1.0US, CA, UK
TotalAmount2NUMERIC15TrueFalseFalseFalse%10.2f1.0US, CA, UK
Address_Addr112VARCHAR41TrueFalseTrueFalse%s1.0US, CA, UK
Address_Addr212VARCHAR41TrueFalseTrueFalse%s1.0US, CA, UK
Address_Addr312VARCHAR41TrueFalseTrueFalse%s1.0US, CA, UK
Address_Addr412VARCHAR41TrueFalseTrueFalse%s2.0US, CA, UK
Address_Addr512VARCHAR41TrueFalseTrueFalse%s6.0US, CA, UK
Address_City12VARCHAR31TrueFalseTrueFalse%s1.0US, CA, UK
Address_State12VARCHAR21TrueFalseTrueFalse%s1.0US, CA, UK
Address_PostalCode12VARCHAR13TrueFalseTrueFalse%s1.0US, CA, UK
Address_Country12VARCHAR31TrueFalseTrueFalse%s1.0US, CA, UK
Address_Note12VARCHAR41TrueFalseTrueFalse%s6.0US, CA, UK
AddressBlock_Addr112VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
AddressBlock_Addr212VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
AddressBlock_Addr312VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
AddressBlock_Addr412VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
AddressBlock_Addr512VARCHAR41TrueFalseFalseFalse%s6.0US, CA, UK
PaymentMethodRef_ListID12VARCHAR36TrueFalseTrueFalse%sListID1.0US, CA, UK
PaymentMethodRef_FullName12VARCHAR31TrueFalseTrueFalse%sName1.0US, CA, UK
Memo12VARCHAR4095TrueFalseTrueFalse%s1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardNumber12VARCHAR25TrueFalseTrueFalse%s1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationMonth4INTEGER9TrueFalseTrueFalse%11.0f1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationYear4INTEGER9TrueFalseTrueFalse%11.0f1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_NameOnCard12VARCHAR41TrueFalseTrueFalse%s1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardAddress12VARCHAR41TrueFalseTrueFalse%s1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardPostalCode12VARCHAR18TrueFalseTrueFalse%s1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CommercialCardCode12VARCHAR24TrueFalseTrueFalse%s1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_TransactionMode12VARCHAR14TrueFalseTrueFalse
CardNotPresent
CardPresent
6.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardTxnType12VARCHAR18TrueFalseTrueFalse
Authorization
Capture
Charge
Refund
VoiceAuthorization
7.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultCode4INTEGER9TrueFalseTrueFalse%11.0f1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultMessage12VARCHAR60TrueFalseTrueFalse%s1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_CreditCardTransID12VARCHAR24TrueFalseTrueFalse%s1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_MerchantAccountNumber12VARCHAR32TrueFalseTrueFalse%s1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_AuthorizationCode12VARCHAR12TrueFalseTrueFalse%s1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSStreet12VARCHAR12TrueFalseTrueFalse
Pass
Fail
NotAvailable
1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSZip12VARCHAR12TrueFalseTrueFalse
Pass
Fail
NotAvailable
1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_CardSecurityCodeMatch12VARCHAR12TrueFalseTrueFalse
Pass
Fail
NotAvailable
6.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ReconBatchID12VARCHAR84TrueFalseTrueFalse%s1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_PaymentGroupingCode4INTEGER9TrueFalseTrueFalse%11.0f1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_PaymentStatus12VARCHAR9TrueFalseTrueFalse
Unknown
Completed
1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_TxnAuthorizationTime93TIMESTAMP23TrueFalseTrueFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_TxnAuthorizationStamp4INTEGER9TrueFalseTrueFalse%11.0f1.0US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ClientTransID12VARCHAR16TrueFalseTrueFalse%s6.0US, CA, UK
ExternalGUID12VARCHAR40TrueFalseTrueFalse%s9.0US, CA, UK

Back to list of tables.