AccountBudgets
Return and update general ledger account budgets.
Table Specific Information
Select
MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criterias can be executed by combining the criteria with AND and OR operators.
These columns support the above comparison types for server side filtering: FinancialYear, LastMonthInFinancialYear. All the other columns and operators are processed client side.
SELECT * FROM AccountBudgets WHERE FinancialYear = 13 SELECT * FROM AccountBudgets WHERE LastMonthInFinancialYear = 41
Columns
| Name | Type | ReadOnly | Description |
| FinancialYear | Integer | False |
Financial year can consist of current FY or next FY only. |
| LastMonthInFinancialYear | Integer | True |
Number representing the last month of the financial year. For example, 3 indicates March. |
| URI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
| Budgets | String | False |
An array of account budget information. |
| CompanyFileId | String | True |
The ID of the company file. Takes precedence over the CompanyFileId connection property. |