Jobs
Return, update, create and delete a job for an AccountRight company file.
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, Contact, Description, StartDate, FinishDate, IsActive, IsHeader, Manager, Name, Number, PercentComplete, StartDate, TrackReimbursables, LinkedCustomerID, LinkedCustomerDisplayID, LinkedCustomerName, LinkedCustomerUri, ParentJobID, ParentJobName, ParentJobNumber, ParentJobUri. All the other columns and operators are processed client side.
SELECT * FROM Jobs WHERE ID = "797755431-e8d1-411f-9859-5ff2a54f97d9" SELECT * FROM Jobs WHERE Number = "125" OR Name = "Supply of Coolers FH" SELECT * FROM Jobs WHERE ParentJobNumber = "120"
Insert
The following attribute is required when performing an insert: Number.
INSERT INTO Jobs(Number) VALUES ("429")
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Uuid | True |
Unique identifier in the form of a guid. |
| Contact | String | False |
Contact for the job. |
| Description | String | False |
Description of the object. |
| StartDate | Datetime | False |
Date the job was started. |
| FinishDate | Datetime | False |
Date the job was completed. |
| IsActive | Boolean | False |
Defaults to true if left blank on POST. |
| IsHeader | Boolean | False |
Defaults to true if left blank on POST. |
| Manager | String | False |
Manager of the job. |
| Name | String | False |
Name of the object. |
| Number | String | False |
Number assigned to the job. |
| PercentComplete | Double | False |
% of the job completed. |
| LastModified | Datetime | True |
Date the job was Modified. |
| TrackReimbursables | Boolean | False |
True indicates a job is used to track reimbursable expenses. False indicates a job is not used to track reimbursable expenses. |
| LinkedCustomerID | Uuid | False |
Unique guid identifier belonging to the assigned customer contact. |
| LinkedCustomerDisplayID | String | True |
Customer contact Card ID, can also be used as a unique customer contact identifier. |
| LinkedCustomerName | String | True |
Name of the customer contact. |
| LinkedCustomerUri | String | True |
Uniform resource identifier associated with the customer contact object. |
| ParentJobID | Uuid | False |
Unique job identifier in the form of a guid. |
| ParentJobName | String | True |
Name assigned to the job. |
| ParentJobNumber | String | True |
Number assigned to the job. |
| ParentJobUri | String | True |
Uniform resource identifier associated with the job object. |
| URI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
| 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. |
| CompanyFileId | String | True |
The ID of the company file. Takes precedence over the CompanyFileId connection property. |