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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| AgingMethod | String | The date upon which aging is determined.
使用できる値は次のとおりです。Report_Date, Current | |
| ARPaid | String | The accounts receivable paid status.
使用できる値は次のとおりです。All, Paid, Unpaid デフォルト値は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. |