ODBC Driver for QuickBooks Online

Build 22.0.8678

Budgets

Query QuickBooks Budgets.

Table Specific Information

Select

All filterable columns support the following operators:

  • =
  • !=
  • >=
  • <=
  • >
  • <
  • IN
  • LIKE
  • CONTAINS

The driver processes other filters client-side within the driver.

Columns

Name Type ReadOnly References Filterable Sortable Description
Id [KEY] String True True True

The Id of the customer.

SyncToken String True False False

Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online.

MetaData_CreateTime Datetime True True True

The time the record was created.

MetaData_LastUpdatedTime Datetime True True True

The time the record was last updated.

Name String True True True

A user recogniyable name for the Account.

StartDate Datetime True False False

The begin date for the Budget.

EndDate Datetime True False False

The end date for the Budget.

BudgetType String True True True

The type of budget.

使用できる値は次のとおりです。ProfitAndLoss, Balance Sheet

BudgetEntryType String True False False

Period that the budget covers.

使用できる値は次のとおりです。Monthly, Quarterly, Annually

Active Boolean True True False

A boolean indicating if the budget is active.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8678