CreditCardPayments
Displays a view of credit card payment transactions, summarizing payments made to credit card accounts for easier reconciliation and expense management.
View Specific Information
Select
This view 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'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Specifies the unique identifier (Id) of the credit-card payment. This value is used to uniquely reference and retrieve the payment record. | |
| SyncToken | String | 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 | Specifies the date and time when the credit-card payment record was created in the source domain. | |
| MetaData_LastUpdatedTime | Datetime | Specifies the date and time when the credit-card payment record was last updated in the source domain. | |
| TxnDate | Date | Specifies the transaction date entered by the user when the credit-card payment occurred. | |
| CurrencyRef | String | Specifies the currency that is entered by the user when the credit-card payment transaction occurred. | |
| ExchangeRate | Decimal | Specifies the exchange rate that is applied when the credit-card payment transaction occurred. | |
| CreditCardAccountRef | String | Identifies the credit-card account to which funds are transferred. | |
| BankAccountRef | String | Identifies the bank account from which funds are transferred to pay the credit-card account. | |
| Amount | Decimal | Specifies the total amount that is recorded for the credit-card payment transaction. | |
| Memo | String | 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 |
Vendors.Id | Specifies the unique Id of the vendor for this credit-card payment transaction. |
| VendorRef_Name | String |
Vendors.Name | Specifies the name of the vendor for this credit-card payment transaction. |
| PrivateNote | String | 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 | Specifies the printing status of the credit-card payment transaction.
The allowed values are NotSet, NeedToPrint, PrintComplete. | |
| CheckNum | String | 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. |