ProfitLossReport
The Profit/Loss Report shows all the information involving both your Profits and Losses.
Columns
| Name | Type | Description |
| ProfitsAmount | Decimal | Amount of total profits. |
| ProfitsCode | String | Three-letter currency code. |
| IncomesAmount | Decimal | Amount of total incomes. |
| IncomesCode | String | Three-letter currency code. |
| ExpensesAmount | Decimal | Amount of total expenses. |
| ExpensesCode | String | Three-letter currency code. |
| FromDate | Date | The beginning date of the report. |
| ToDate | Date | The ending date of the report. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| StartDate | String | the starting date for the expense report query. |
| EndDate | String | Will only return invoices that were created before the given date. |