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