CreditCardPayments

Displays a view of credit card payment transactions, summarizing payments made to credit card accounts for easier reconciliation and expense management.

Table Specific Information

Select

This table will retrieve all the credit card payments from the user's account.

SELECT * FROM CreditCardPayments WHERE Id = '1234'

SELECT * FROM CreditCardPayments WHERE TxnDate > '2020-01-01'

Insert

To add a CreditCardPayment, specify the CreditCardAccountRef, BankAccountRef, and Amount columns. For example, the following will insert a new CreditCardPayment:

INSERT INTO CreditCardPayments (CreditCardAccountRef, BankAccountRef, Amount) VALUES ('71', '156', 501)

Update

To update a CreditCardPayment, you will need to specify the Id column.

UPDATE CreditCardPayments SET Amount = 100 WHERE Id = '25420'

Delete

To delete a CreditCardPayment, you will need to specify the Id column.

DELETE FROM CreditCardPayments WHERE Id = '25420'

Columns


Name	Type	ReadOnly	References	Filterable	Sortable	Description
Id [KEY]	String	True		True	False	Specifies the unique identifier (Id) of the credit-card payment. This value is used to uniquely reference and retrieve the payment record.
SyncToken	String	True		False	False	Specifies the version number that is used to lock the credit-card payment object for use by one application at a time. When an application modifies an object, its sync token is incremented. Attempts to modify an object with an older sync token fail. Only the latest version of the object is maintained by QuickBooks Online.
MetaData_CreateTime	Datetime	True		True	True	Specifies the date and time when the credit-card payment record was created in the source domain.
MetaData_LastUpdatedTime	Datetime	True		True	True	Specifies the date and time when the credit-card payment record was last updated in the source domain.
TxnDate	Date	False		True	True	Specifies the transaction date entered by the user when the credit-card payment occurred.
CurrencyRef	String	False		False	False	Specifies the currency that is entered by the user when the credit-card payment transaction occurred.
ExchangeRate	Decimal	False		False	False	Specifies the exchange rate that is applied when the credit-card payment transaction occurred.
CreditCardAccountRef	String	False		False	False	Identifies the credit-card account to which funds are transferred.
BankAccountRef	String	False		False	False	Identifies the bank account from which funds are transferred to pay the credit-card account.
Amount	Decimal	False		False	False	Specifies the total amount that is recorded for the credit-card payment transaction.
Memo	String	False		False	False	Specifies a user-entered, organization-private note about the credit-card payment transaction. This field maps to the Memo field on the Pay Down Credit Card form.
VendorRef	String	False	Vendors.Id	True	False	Specifies the unique Id of the vendor for this credit-card payment transaction.
VendorRef_Name	String	True	Vendors.Name	False	False	Specifies the name of the vendor for this credit-card payment transaction.
PrivateNote	String	False		False	False	Specifies a user-entered, organization-private note about the credit-card payment transaction. This field maps to the Memo field on the Pay Down Credit Card form.
PrintStatus	String	False		False	False	Specifies the printing status of the credit-card payment transaction. The allowed values are NotSet, NeedToPrint, PrintComplete.
CheckNum	String	False		False	False	Specifies the check number that is entered by the user for the credit-card payment transaction. This field maps to the Check No. field on the Pay Down Credit Card form.