TABLE DETAIL REFERENCE: ARRefundCreditCardRefundAppliedTo
(UK VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
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
ThisFiscalYeRX<eTT
RefNumber12 VARCHAR 11TrueFalseTrueFalse%s
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%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
RefundAppliedToTxnTxnID12 VARCHAR 36TrueFalseTrueTrue%s
RefundAppliedToTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjusoNKv  ۅT ۅT HۅTHۅT 
RefundAppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
RefundAppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
RefundAppliedToTxnRefCreditRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefundAppliedToTxnRefRefundAmount3 DECIMAL 15TrueFalseTrueFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey