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. The allowed values are ProfitAndLoss, Balance Sheet. | |
| BudgetEntryType | String | True | False | False |
Period that the budget covers. The allowed values are Monthly, Quarterly, Annually. | |
| Active | Boolean | True | True | False |
A boolean indicating if the budget is active. |