ReceivePaymentToDeposit
Generates reports of payments received and ready to be deposited in QuickBooks.
Table Specific Information
Select
The QuickBooks does not support any filters on the server side. All the columns specified in the WHERE clause of a SELECT query will be processed on the client-side.
For example, the following query processed on the server side:
SELECT * FROM ReceivePaymentToDeposit
Columns
| Name | Type | References | Description |
| ID [KEY] | String | The unique identifier for the payment transaction, used to distinguish it from others. | |
| TxnType | String | The type of transaction, such as a payment or deposit. | |
| TxnLineID | String | The unique identifier for the specific line within the transaction, useful for tracking individual entries. | |
| CustomerRef_ListID | String |
Customers.ID | The Quickbooks assigned unique ID for the customer associated with this transaction. |
| CustomerRef_FullName | String | The full name of the customer associated with the transaction, as recorded in QuickBooks. | |
| TxnDate | Date | The date when the payment transaction occurred, useful for financial tracking and reconciliation. | |
| RefNumber | String | A reference number assigned to the transaction for identification, such as a check number or payment ID. | |
| Amount | Decimal | The total amount for this transaction, calculated automatically by QuickBooks based on line items or expenses. | |
| CurrencyId | String |
Currency.ID | The unique QuickBooks ID for the currency used in the transaction. This requires QBXML version 8.0 or higher. |
| CurrencyName | String | The name of the currency used for the transaction, such as USD or EUR. Requires QBXML version 8.0 or higher. | |
| ExchangeRate | Double | The market exchange rate applied to convert the transaction's currency into the home currency of the QuickBooks file. | |
| AmountInHomeCurrency | Double | The transaction amount expressed in the company's home currency, after applying the exchange rate. |