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. |