BudgetSummary
Query a monthly Budget Summary.
Columns
| Name | Type | Description |
| ID [KEY] | Integer | The row number. |
| BankAccount | String | The Bank account number. |
| Period1 | String | Period 1 of the report |
| Period2 | String | Period 2 of the report |
| Period3 | String | Period 3 of the report |
| Period4 | String | Period 4 of the report |
| Period5 | String | Period 5 of the report |
| Period6 | String | Period 6 of the report |
| Period7 | String | Period 7 of the report |
| Period8 | String | Period 8 of the report |
| Period9 | String | Period 9 of the report |
| Period10 | String | Period 10 of the report |
| Period11 | String | Period 11 of the report |
| Period12 | String | Period 12 of the report |
| TenantId | String | The ID of the tenant to query instead of the connection tenant |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Date | Datetime | As at date. |
| Periods | Integer | The number of periods to compare (integer between 1 and 12). |
| Timeframe | Integer | The period size to compare to: Specify 1 for month, 3 for quarter, or 12 for year). |