BudgetLines
Query Budget line items for a Xero organisation
Columns
| Name | Type | Description |
| Id [KEY] | String | The line item index combined with the Id of the account. |
| BudgetId | String | The Id of the invoice. This field is assigned by Xero. |
| AccountId | String | The account that applies to this budget line item. |
| AccountCode | String | The code of this budget line item account. |
| Period | String | The year and month that the balance applies to. |
| Amount | Decimal | The amount budgeted to the account for the period. |
| Notes | String | Any notes that apply to the balance. |
| TenantId | String | The ID of the tenant to query instead of the connection tenant |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DateFrom | Datetime | Includes budget periods starting from this date. |
| DateTo | Datetime | Includes budget periods until this date. |