CustomerBalanceDetail
The QuickBooks report CustomerBalanceDetail.
Columns
| Name | Type | References | Description |
| Label | String | A column for Label. | |
| ReportDate | String | A column for Date. If used as a filter it will retrieve the records up to the specified date. | |
| TransactionType | String | A column for TransactionType containing String data. | |
| Num | String | A column for Num containing String data. | |
| DueDate | String | A column for Due_Date containing Date data. | |
| Amount | Decimal | A column for Amount containing Money data. | |
| OpenBalance | Decimal | A column for OpenBalance containing Money data. | |
| Balance | Decimal | A column for Balance containing Money data. | |
| RowType | String | A column for Type of the row. | |
| RowGroup | String | A column for Group of the row. |
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 | 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. |