ARRefundCreditCardRefundAppliedTo Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
TxnID 12 VARCHAR 36 True False False False %s TxnID 1.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 1.0 US, CA, UK
TxnNumber 4 INTEGER 9 True False False False %11.0f 1.0 US, CA, UK
CustomerRef_ListID 12 VARCHAR 36 True False True True %s ListID 1.0 US, CA, UK
CustomerRef_FullName 12 VARCHAR 209 True False True True %s FullName 1.0 US, CA, UK
RefundFromAccountRef_ListID 12 VARCHAR 36 True False True False %s ListID 1.0 US, CA, UK
RefundFromAccountRef_FullName 12 VARCHAR 159 True False True False %s FullName 1.0 US, CA, UK
ARAccountRef_ListID 12 VARCHAR 36 True False True False %s ListID 1.0 US, CA, UK
ARAccountRef_FullName 12 VARCHAR 159 True False True False %s FullName 1.0 US, CA, UK
TxnDate 91 DATE 10 True False True False CCCC-MM-DD 1.0 US, CA, UK
TxnDateMacro 12 VARCHAR 25 True False False False
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
 1.0 US, CA, UK
RefNumber 12 VARCHAR 11 True False True False %s 1.0 US, CA, UK
TotalAmount 2 NUMERIC 15 True False False False %10.2f 1.0 US, CA, UK
Address_Addr1 12 VARCHAR 41 True False True False %s 1.0 US, CA, UK
Address_Addr2 12 VARCHAR 41 True False True False %s 1.0 US, CA, UK
Address_Addr3 12 VARCHAR 41 True False True False %s 1.0 US, CA, UK
Address_Addr4 12 VARCHAR 41 True False True False %s 2.0 US, CA, UK
Address_Addr5 12 VARCHAR 41 True False True False %s 6.0 US, CA, UK
Address_City 12 VARCHAR 31 True False True False %s 1.0 US, CA, UK
Address_State 12 VARCHAR 21 True False True False %s 1.0 US, CA, UK
Address_PostalCode 12 VARCHAR 13 True False True False %s 1.0 US, CA, UK
Address_Country 12 VARCHAR 31 True False True False %s 6.0 US, CA, UK
Address_Note 12 VARCHAR 41 True False True False %s 6.0 US, CA, UK
AddressBlock_Addr1 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
AddressBlock_Addr2 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
AddressBlock_Addr3 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
AddressBlock_Addr4 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
AddressBlock_Addr5 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
PaymentMethodRef_ListID 12 VARCHAR 36 True False True False %s 1.0 US, CA, UK
PaymentMethodRef_FullName 12 VARCHAR 31 True False True False %s 1.0 US, CA, UK
Memo 12 VARCHAR 4095 True False True False %s 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardNumber 12 VARCHAR 25 True False True False %s 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationMonth 4 INTEGER 9 True False True False %11.0f 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationYear 4 INTEGER 9 True False True False %11.0f 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_NameOnCard 12 VARCHAR 41 True False True False %s 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardAddress 12 VARCHAR 41 True False True False %s 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardPostalCode 12 VARCHAR 41 True False True False %s 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CommercialCardCode 12 VARCHAR 24 True False True False %s 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_TransactionMode 12 VARCHAR 14 True False True False
CardNotPresent
CardPresent
 6.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardTxnType 12 VARCHAR 18 True False True False
Authorization
Capture
Charge
Refund
VoiceAuthorization
 7.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultCode 4 INTEGER 9 True False True False %11.0f 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultMessage 12 VARCHAR 60 True False True False %s 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_CreditCardTransID 12 VARCHAR 24 True False True False %s 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_MerchantAccountNumber 12 VARCHAR 32 True False True False %s 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_AuthorizationCode 12 VARCHAR 12 True False True False %s 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSStreet 12 VARCHAR 12 True False True False
Pass
Fail
NotAvailable
 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSZip 12 VARCHAR 12 True False True False
Pass
Fail
NotAvailable
 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_CardSecurityCodeMatch 12 VARCHAR 12 True False True False
Pass
Fail
NotAvailable
 6.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ReconBatchID 12 VARCHAR 84 True False True False %s 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_PaymentGroupingCode 4 INTEGER 9 True False True False %11.0f 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_PaymentStatus 12 VARCHAR 9 True False True False
Unknown
Completed
 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_TxnAuthorizationTime 93 TIMESTAMP 23 True False True False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_TxnAuthorizationStamp 4 INTEGER 9 True False True False %11.0f 1.0 US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ClientTransID 12 VARCHAR 16 True False True False %s 6.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 True False True False %s 9.0 US, CA, UK
RefundAppliedToTxn_TxnID 12 VARCHAR 36 True False True True %s 1.0 US, CA, UK
RefundAppliedToTxn_TxnType 12 VARCHAR 14 True False False False
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjustment
Paycheck
PayrollLiabilityCheck
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
Transfer
VendorCredit
YTDAdjustment
ARRefundCreditCard
 1.0 US, CA, UK
RefundAppliedToTxn_TxnDate 91 DATE 10 True False False False CCCC-MM-DD 1.0 US, CA, UK
RefundAppliedToTxn_RefNumber 12 VARCHAR 20 True False False False %s 1.0 US, CA, UK
RefundAppliedToTxnRef_CreditRemaining 2 NUMERIC 15 True False False False %10.2f 1.0 US, CA, UK
RefundAppliedToTxnRef_RefundAmount 2 NUMERIC 15 True False True False %10.2f 1.0 US, CA, UK
RefundAppliedToTxnRef_CreditRemainingInHomeCurrency 2 NUMERIC 15 True False False False %10.2f 9.0 US, CA, UK
RefundAppliedToTxn_RefundAmountInHomeCurrency 2 NUMERIC 15 True False False False %10.2f 9.0 US, CA, UK
RQUseCachedID -7 BIT 2

Back to list of tables.