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. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AgingMethod | String | The date upon which aging is determined.
The allowed values are Report_Date, Current. | |
| ARPaid | String | The accounts receivable paid status.
The allowed values are All, Paid, Unpaid. The default value is Unpaid. | |
| Customer | String | Filters report contents to include information for specified customers. This is a comma separated list (spaces omitted after/before separating comma) of one or more Customer IDs. | |
| Department | String | Filters report contents to include information for specified departments if so configured in the company file. This is a comma separated list (spaces omitted after/before separating comma) of one or more Department IDs. | |
| ShipVia | String | Filter by the shipping method as specified in Invoice's ShipMethodRef. This is the name of the shipping method. | |
| Term | String | Filters report contents to include information for specified term or terms supplied. This is a comma separated list (spaces omitted after/before separating comma) of one or more Term IDs. |