CreditCardRefunds

Query and Insert Reckon AR Credit Card Refund transactions.

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

The following filters support server-side execution. Other filters are executed client-side.

Reckon 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	Description
ID [KEY]	String	True		The unique identifier.
TxnDate	Date	False		The date of the transaction.
TxnNumber	Integer	True		The transaction number. An identifying number for the transaction, different from the Reckon-generated Id
RefNumber	String	False		The transaction reference number.
CustomerRef_ListID	String	False	Customers.ID	The ID of the customer on the refund. Either CustomerRef_ListID or CustomerRef_ListName must have a value when inserting.
CustomerRef_FullName	String	False		The name of the customer on the refund. Either CustomerRef_ListID or CustomerRef_ListName must have a value when inserting.
RefundFromAccountRef_ListID	String	False	Accounts.ID	The Id of the account which is the source of funds for the credit card refund.
RefundFromAccountRef_FullName	String	False		The Name of the account which is the source of funds for the credit card refund.
ARAccountRef_ListID	String	False	Accounts.ID	A reference to the accounts-receivable account where the money received from this transaction will be deposited.
ARAccountRef_FullName	String	False		A reference to the accounts-receivable account where the money received from this transaction will be deposited.
TotalAmount	Decimal	True		Total amount of the refund.
TotalAmountInHomeCurrency	Decimal	True		Total amount of the refund in home currency.
Address_Addr1	String	False		First line of the address.
Address_Addr2	String	False		Second line of the address.
Address_Addr3	String	False		Third line of the address.
Address_Addr4	String	False		Fourth line of the address.
Address_Addr5	String	False		Fifth line of the address.
Address_City	String	False		City name for the address of the check.
Address_State	String	False		State name for the address of the check.
Address_PostalCode	String	False		Postal code for the address of the check.
Address_Country	String	False		Country for the address of the check.
Address_Note	String	False		Note for the address of the check.
PaymentMethodRef_ListID	String	False	PaymentMethods.ID	The Id of the Customer's payment method.
PaymentMethodRef_FullName	String	False		The Name of the Customer's payment method.
Memo	String	False		Additional information about the refund.
RefundAppliedToTxnAggregate	String	False		An aggregate of the transactions this refund is applied to.
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardNumber	String	False		The Credit Card Number for the Customer.
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationMonth	Integer	False		The month when the credit card expires.
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationYear	Integer	False		The year when the credit card expires.
CreditCardTxnInfo_CreditCardTxnInputInfo_NameOnCard	String	False		The name on the Customer's credit card.
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardAddress	String	False		The address associated with this credit card.
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardPostalCode	String	False		The postal code associated with the address for this credit card.
CreditCardTxnInfo_CreditCardTxnInputInfo_CommercialCardCode	String	False		This optional field is used only for Visa and Master Card commercial cards.
CreditCardTxnInfo_CreditCardTxnInputInfo_TransactionMode	String	False		Indicates whether this transaction came from a card swipe (CardPresent ) or not (CardNotPresent). Defaults to CardNotPresent
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardTxnType	String	False		Indicates from where the current transaction data originated. Values:Authorization, Capture, Charge, Refund, VoiceAuthorization
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultCode	Integer	False		Contains the status code returned in the original ransaction response.
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultMessage	String	False		Contains the status message returned in the original transaction response.
CreditCardTxnInfo_CreditCardTxnResultInfo_CreditCardTransID	String	False		The transaction ID is returned from the credit card processor.
CreditCardTxnInfo_CreditCardTxnResultInfo_MerchantAccountNumber	String	False		The account number of the merchant who is running the transaction using the customer's credit card.
CreditCardTxnInfo_CreditCardTxnResultInfo_AuthorizationCode	String	False		The authorization code is returned from the credit card processor.
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSStreet	String	False		Pass if the street address supplied in the transaction request matches the customer's address. Fail if does not match.
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSZip	String	False		Pass if the zip supplied in the transaction request matches the customer's zip. Fail if does not match.
CreditCardTxnInfo_CreditCardTxnResultInfo_CardSecurityCodeMatch	String	False		Pass if the security colde supplied in the transaction request matches the Credit Card's security Code. Fail if does not match.
CreditCardTxnInfo_CreditCardTxnResultInfo_TxnAuthorizationTime	Datetime	False		Timestamp indicating the time in which the card processor authorized the transaction.
CustomFields	String	False		Custom fields returned from Reckon and formatted into XML.
CurrencyRef_ListID	String	True	Currency.ListID	Name of the currency code used for this refund.
CurrencyRef_Name	String	True		Id of the currency code used for this refund.
ExchangeRate	Decimal	False		Currency exchange rate for this invoice.
TimeCreated	Datetime	True		The datetime the transaction was made.
TimeModified	Datetime	True		The last datetime the transaction was modified.
EditSequence	String	True		An identifier used for versioning for this copy of the object.

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.