TABLE DETAIL REFERENCE: ARRefundCreditCard
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueFalseTrueTrue%s Yes
RefundFromAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
RefundFromAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYear
ThisFiscalYearToDate
Yesterday
LastWeek
LastWeekToDate
LastMonth
LastMonthToDate
LastCalendarQuarter
LastCalendarQuarterToDate
LastFiscalQuarter
LastFiscalQuarterToDate
LastCalendarYear
LastCalendarYearToDate
LastFiscalYear
LastFiscalYearToDate
NextWeek
NextFourWeeks
NextMonth
NextCalendarQuarter
NextCalendarYear
NextFiscalQuarter
NextFiscalYear
RefNumber12 VARCHAR 11TrueFalseTrueFalse%s
TotalAmount3 DECIMAL 18TrueFalseFalseFalse%10.2f
AddressAddr112 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr212 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr312 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr412 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr512 VARCHAR 41TrueFalseTrueFalse%s
AddressCity12 VARCHAR 31TrueFalseTrueFalse%s
AddressState12 VARCHAR 21TrueFalseTrueFalse%s
AddressProvince12 VARCHAR 21TrueFalseTrueFalse%s
AddressCounty12 VARCHAR 21TrueFalseTrueFalse%s
AddressPostalCode12 VARCHAR 13TrueFalseTrueFalse%s
AddressCountry12 VARCHAR 31TrueFalseTrueFalse%s
AddressNote12 VARCHAR 41TrueFalseTrueFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
PaymentMethodRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 31TrueFalseTrueFalse%s Yes
Memo12 VARCHAR 4095TrueFalseTrueFalse%s
CreditCardTxnInfoInputCreditCardNumber12 VARCHAR 25TrueFalseTrueFalse%s
CreditCardTxnInfoInputExpirationMonth4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoInputExpirationYear4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoInputNameOnCard12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCreditCardAddress12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCreditCardPostalCode12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCommercialCardCode12 VARCHAR 50TrueFalseTrueFalse%s
CreditCardTxnInfoInputTransactionMode12 VARCHAR 14TrueFalseTrueFalse
CardNotPresent
CardPresent
CreditCardTxnInfoInputCreditCardTxnType12 VARCHAR 18TrueFalseTrueFalse
Authorization
Capture
Charge
Refund
VoiceAuthorization
CreditCardTxnInfoResultResultCode4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultResultMessage12 VARCHAR 500TrueFalseTrueFalse%s
CreditCardTxnInfoResultCreditCardTransID12 VARCHAR 24TrueFalseTrueFalse%s
CreditCardTxnInfoResultMerchantAccountNumber12 VARCHAR 32TrueFalseTrueFalse%s
CreditCardTxnInfoResultAuthorizationCode12 VARCHAR 12TrueFalseTrueFalse%s
CreditCardTxnInfoResultAVSStreet12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultAVSZip12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultCardSecurityCodeMatch12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultReconBatchID12 VARCHAR 84TrueFalseTrueFalse%s
CreditCardTxnInfoResultPaymentGroupingCode4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultPaymentStatus12 VARCHAR 9TrueFalseTrueFalse
Unknown
Completed
CreditCardTxnInfoResultTxnAuthorizationTime11 TIMESTAMP 16TrueFalseTrueFalseCCCC-MM-DDThh:mm:ssZ
CreditCardTxnInfoResultTxnAuthorizationStamp4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultClientTransID12 VARCHAR 16TrueFalseTrueFalse%s