JobBudgets
Return and update job 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: ID, JobID, JobName, JobNumber. All the other columns and operators are processed client side.
SELECT * FROM JobBudgets WHERE ID = "7cabea25-6250-4df5-bb37-77eb2d38f803" SELECT * FROM JobBudgets WHERE JobName = "job name"
Update
To update an existing JobBudget, along with its Budgets, we can either pass a JSON string to the Budgets value or use a temporary table like below.
Note: this will replace all the current Budgets with the ones below.
INSERT INTO JobBudgetItems#TEMP(Amount, AccountID) VALUES (444.21, "44a7b2bc-0a0e-4381-86fc-9b2c7a479f8f") UPDATE JobBudgets SET Budgets = "JobBudgetItems#TEMP" WHERE ID = "992163e5-f46d-4b45-9296-965aa89a2a71"
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Uuid | False |
Unique identifier in the form of a guid. |
| RowVersion | String | True |
Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time. |
| URI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
| JobID | Uuid | False |
Unique job identifier in the form of a guid. |
| JobName | String | True |
Name assigned to the job. |
| JobNumber | String | True |
Number assigned to the job. |
| JobURI | String | True |
Uniform resource identifier associated with the job object. |
| Budgets | String | False |
An array of job budget information. |
| CompanyFileId | String | True |
The ID of the company file. Takes precedence over the CompanyFileId connection property. |