BudgetLines

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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

DateFrom

Datetime

Includes budget periods starting from this date.

DateTo

Datetime

Includes budget periods until this date.

Last updated