CustomerBalanceDetail
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. |
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. |
Last modified 1yr ago