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