JDBC Driver for Xero

Build 23.0.8839

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

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839