JDBC Driver for MYOB

Build 22.0.8462

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.

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