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

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.