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