CustomerBalanceDetail
Presents the Customer Balance Detail report from QuickBooks Online, showing outstanding invoices, payments, and credits per customer with running balances.
Columns
| Name | Type | References | Description |
| Label | String | Specifies the label column for the customer-balance detail report. | |
| ReportDate | String | Specifies the report date column for the customer-balance detail report. If this column is used as a filter, it retrieves the records up to the specified date. | |
| TransactionType | String | Specifies the transaction type column containing string data for the customer-balance detail report. | |
| Num | String | Specifies the number column containing string data for the customer-balance detail report. | |
| DueDate | String | Specifies the due date column containing date data for the customer-balance detail report. | |
| Amount | Decimal | Specifies the amount column containing monetary data for the customer-balance detail report. | |
| OpenBalance | Decimal | Specifies the open balance column containing monetary data for the customer-balance detail report. | |
| Balance | Decimal | Specifies the balance column containing monetary data for the customer-balance detail report. | |
| RowType | String | Specifies the row type column for the customer-balance detail report. | |
| RowGroup | String | Specifies the row group column for the customer-balance detail report. |
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.
| Name | Type | Description | |
| AgingMethod | String | Specifies the date upon which aging is determined for the customer-balance detail report.
The allowed values are Report_Date, Current. | |
| ARPaid | String | Specifies the accounts receivable paid status for the customer-balance detail report.
The allowed values are All, Paid, Unpaid. The default value is Unpaid. | |
| Customer | String | Filters the report contents to include transactions for specified customers. Provide a comma separated list (with a space after each comma) of one or more Customer identifiers (Ids). | |
| Department | String | Filters the report contents to include transactions for specified departments. Provide a comma separated list (with a space after each comma) of one or more Department Ids. | |
| ShipVia | String | Filters the report contents by the shipping method as specified in the Invoice's shipping method reference. Provides the name of the shipping method. | |
| Term | String | Filters the report contents to include transactions for specified terms. Provide a comma separated list (with a space after each comma) of one or more Term Ids. |