AccountsAgingReport
The Account Aging Report shows details regarding overdue invoices from clients.
Columns
Name | Type | Description |
UserId [KEY] | String | Unique identifier of the client |
Lname | String | The last name of the client |
Fname | String | The first name of the client |
Organization | String | Organization of the client |
String | Email of the client | |
CurrencyCode | String | Three letter currency code |
CompanyName | String | Company Name of the client |
DownloadToken | String | The download token allows you to download the report into a csv file |
EndDate | Date | The ending date for the profit/loss report query |
Account_0To30Interval_Amount | String | The total amount due for a particular account from all its overdue invoices in 0-30 interval. |
Account_0To30Interval_Code | String | Three letter currency code |
Account_31To60Interval_Amount | String | The total amount due for a particular account from all its overdue invoices in 31-60 interval. |
Account_31To60Interval_Code | String | Three letter currency code |
Account_61To90Interval_Amount | String | The total amount due for a particular account from all its overdue invoices in 61-90 interval. |
Account_61To90Interval_Code | String | Three letter currency code |
Account_From91_Amount | String | The total amount due for a particular account from all its overdue invoices for more than 90 days. |
Account_From91_Code | String | Three letter currency code |
AccountTotalAmount | String | The total amount due for a particular account from all its overdue invoices. |
AccountTotalCode | String | Three letter currency code |
Totals_0To30Interval_Amount | String | The total amount due from all overdue invoices in 0-30 interval. |
Totals_0To30Interval_Code | String | Three letter currency code |
Totals_31To60Interval_Amount | String | The total amount due from all overdue invoices in 31-60 interval |
Totals_31To60Interval_Code | String | Three letter currency code |
Totals_61To90Interval_Amount | String | The total amount due from all overdue invoices in 61-90 interval |
Totals_61To90Interval_Code | String | Three letter currency code |
Totals_From91_Amount | String | The total amount due from all overdue invoices for more than 90 interval |
Totals_From91_Code | String | Three letter currency code |
TotalsTotalAmount | String | The total amount due from all overdue invoices from all the intervals |
TotalsTotalCode | String | Three letter currency code |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
StartDate | String | The starting date for the expense report query. |