Budgets
To get the list of budgets
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- BudgetId supports the '=' comparison.
The rest of the filter is executed client-side in the 本製品.
For example:
SELECT * FROM Budgets WHERE budgetid = 3255827000000081030
Columns
| Name | Type | References | SupportedOperators | Description |
| BudgetId [KEY] | String | = | Budget Id | |
| BudgetStartDate | Integer | Budget Start Date | ||
| Year | Integer | Year | ||
| Frequency | String | Frequency | ||
| CustomFields | String | Custom Fields | ||
| TagOptionName | Date | Tag Option Name | ||
| ProjectName | String | Project Name | ||
| BudgetEndDate | String | Budget End Date | ||
| EntityType | String | Entity Type | ||
| BranchId | String | Branch Id | ||
| ProjectId | String | Project Id | ||
| BranchName | String | Branch Name | ||
| Name | String | Name | ||
| EntityTypeFormatted | String | Formatted display string for the entity type associated with the budget. | ||
| Frequency | String | Internal string representing the frequency setting. | ||
| LocationId | String | ID of the location associated with the budget. | ||
| LocationName | String | Name of the location associated with the budget. | ||
| TagId | String | ID of the tag associated with the budget category. | ||
| TagName | String | Name of the tag associated with the budget category. | ||
| TagOptionIndex | Integer | Index of the tag option for the budget category. | ||
| TagOptionId | String | ID of the tag option for the budget category. | ||
| YearFormatted | String | Formatted string displaying the budget year or period. |