CreditCardRefunds

Facilitates the creation and querying of QuickBooks AR Credit Card Refund transactions for managing customer refunds.

Table Specific Information

CreditCardRefunds may be inserted or queried via the CreditCardRefunds table. CreditCardRefunds may be deleted by using the CreditCardRefunds table. QuickBooks does not currently support updating CreditCardRefunds.

This table has a Custom Fields column. See the Custom Fields page for more information.

Select

By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.

QuickBooks allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison. The available columns for ARCreditCardRefunds are Id, Date, ReferenceNumber, and TimeModified. TimeModified and Date may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. ReferenceNumber may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:

SELECT * FROM CreditCardRefunds WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND ReferenceNumber LIKE '%12345%'

Insert

To add a CreditCardRefund, specify a Customer, Date, and at least one reference to a Credit Memo. For example, the following will insert a new CreditCardRefunds:

INSERT INTO CreditCardRefunds#TEMP (CustomerRef_ListID, PaymentMethodRef_ListID, RefundAppliedToTxnAdd_TxnId, RefundAppliedToTxnAdd_RefundAmount) VALUES ('150000-933272658', '1D575-1544895769', '30000-933272660', 200.00)
INSERT INTO CreditCardRefunds (CustomerRef_ListID, PaymentMethodRef_ListID, RefundAppliedToTxnAdd_TxnId, RefundAppliedToTxnAdd_RefundAmount) SELECT CustomerRef_ListID, PaymentMethodRef_ListID, RefundAppliedToTxnAdd_TxnId, RefundAppliedToTxnAdd_RefundAmount FROM CreditCardRefunds#TEMP

Columns


Name	Type	ReadOnly	References	ColumnSize	Description
ID [KEY]	String	True		255	The unique identifier for the credit card refund transaction.
TxnDate	Date	False			The date of the transaction when the refund was processed.
TxnNumber	Integer	True			A manually assigned transaction number to identify this refund separately from the Quickbooks generated ID.
RefNumber	String	False		21	The transaction reference number for the refund.
CustomerRef_ListID	String	False	Customers.ID	255	The unique ID of the customer associated with the refund. Either CustomerRef_ListID or CustomerRef_FullName must be provided when inserting.
CustomerRef_FullName	String	False		209	The full name of the customer associated with the refund. Either CustomerRef_ListID or CustomerRef_FullName must be provided when inserting.
RefundFromAccountRef_ListID	String	False	Accounts.ID	255	The unique ID of the account where the refund amount originates.
RefundFromAccountRef_FullName	String	False		159	The full name of the account where the refund amount originates.
ARAccountRef_ListID	String	False	Accounts.ID	255	The unique ID of the accounts-receivable account receiving the money from the refund.
ARAccountRef_FullName	String	False		159	The full name of the accounts-receivable account receiving the money from the refund.
TotalAmount	Decimal	True			The total amount refunded in the transaction.
TotalAmountInHomeCurrency	Decimal	True			The total amount refunded, converted to the home currency.
Address_Addr1	String	False		41	The first line of the customer's address.
Address_Addr2	String	False		41	The second line of the customer's address.
Address_Addr3	String	False		41	The third line of the customer's address.
Address_Addr4	String	False		41	The fourth line of the customer's address.
Address_Addr5	String	False		41	The fifth line of the customer's address.
Address_City	String	False		31	The city associated with the customer's address.
Address_State	String	False		21	The state associated with the customer's address.
Address_PostalCode	String	False		13	The postal code associated with the customer's address.
Address_Country	String	False		31	The country associated with the customer's address.
Address_Note	String	False		41	Additional notes related to the customer's address.
PaymentMethodRef_ListID	String	False	PaymentMethods.ID	255	The unique ID of the payment method used for the refund.
PaymentMethodRef_FullName	String	False		31	The full name of the payment method used for the refund.
Memo	String	False		4095	Additional information or notes about the refund transaction.
RefundAppliedToTxnAggregate	String	False		5000	An aggregate of transactions to which this refund is applied.
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardNumber	String	False		25	The credit card number used by the customer for this refund.
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationMonth	Integer	False			The expiration month of the customer's credit card.
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationYear	Integer	False			The expiration year of the customer's credit card.
CreditCardTxnInfo_CreditCardTxnInputInfo_NameOnCard	String	False		41	The name printed on the customer's credit card.
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardAddress	String	False		41	The address associated with the customer's credit card.
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardPostalCode	String	False		18	The postal code associated with the address for the customer's credit card.
CreditCardTxnInfo_CreditCardTxnInputInfo_CommercialCardCode	String	False		24	An optional field for Visa and MasterCard commercial cards, containing additional card details.
CreditCardTxnInfo_CreditCardTxnInputInfo_TransactionMode	String	False		50	Indicates whether the transaction was processed as 'CardPresent' or 'CardNotPresent.' Defaults to 'CardNotPresent.'
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardTxnType	String	False		50	Specifies the type of transaction, such as Authorization, Capture, Charge, Refund, or VoiceAuthorization.
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultCode	Integer	False			The status code returned by the credit card processor for this transaction.
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultMessage	String	False		60	The status message returned by the credit card processor for this transaction.
CreditCardTxnInfo_CreditCardTxnResultInfo_CreditCardTransID	String	False		24	The transaction ID returned by the credit card processor.
CreditCardTxnInfo_CreditCardTxnResultInfo_MerchantAccountNumber	String	False		32	The account number of the merchant processing this refund.
CreditCardTxnInfo_CreditCardTxnResultInfo_AuthorizationCode	String	False		12	The authorization code returned by the credit card processor.
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSStreet	String	False		50	Indicates whether the street address supplied matches the customer's registered address.
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSZip	String	False		50	Indicates whether the postal code supplied matches the customer's registered postal code.
CreditCardTxnInfo_CreditCardTxnResultInfo_CardSecurityCodeMatch	String	False		50	Indicates whether the supplied card security code matches the card's actual code.
CreditCardTxnInfo_CreditCardTxnResultInfo_TxnAuthorizationTime	Datetime	False			The timestamp when the card processor authorized this transaction.
CustomFields	String	False		5000	Custom fields returned from QuickBooks, formatted as XML.
CurrencyRef_ListID	String	True	Currency.ListID	255	The unique ID of the currency code used for this refund.
CurrencyRef_Name	String	True		64	The name of the currency code used for this refund.
ExchangeRate	Decimal	False			The exchange rate used to convert the transaction amount to the home currency.
TimeCreated	Datetime	True			The timestamp of when the refund transaction was created.
TimeModified	Datetime	True			The timestamp of the last modification made to the refund transaction.
EditSequence	String	True		16	A versioning identifier for this refund transaction.

Pseudo-Columns

Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.