MYOB Endpoint: JobsTable
Jump to navigation
Jump to search
Overview
The MYOB JobsTable endpoint allows you to access the list of jobs located within MYOB.
Note this endpoint is an alternate format of the Jobs endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.
Fields
The following fields are available for the JobsTable endpoint.
- DataFileID
- A guid field that provides the id of the data file as setup in OdataLink.
- DataFileName
- A text field provides the name of the data file as setup in OdataLink.
- DataFileCode
- A text field provides the code of the data file as setup in OdataLink.
- UID
- A GUID field representing the internal id of a job. This field can be used to link to other endpoints.
- Number
- A text field used as the job number.
- IsHeader
- A true/false value that indicates if the job is a header or detail job.
- Name
- A text field used as the job name.
- Description
- A text field used as the job description.
- ParentJobUID
- A GUID field that provides the internal id of a job assigned to this line. This field can be used to link to other endpoints.
- ParentJobNumber
- A text field that provides the job number assigned to this line.
- ParentJobName
- A text field that provides the job name assigned to this line.
- LinkedCustomerUID
- A GUID field that provides the internal id of the customer. This field can be used to link to other endpoints.
- LinkedCustomerName
- A text field that provides the full name of the customer.
- LinkedCustomerDisplayID
- A text field that provides the Card ID of the customer.
- PercentComplete
- A decimal field that gives access to the percentage completed as entered in the job screen.
- StartDate
- A date field that gives access to the start date as entered in the job screen.
- EndDate
- A date field that gives access to the end date as entered in the job screen.
- Contact
- A text field that gives access to the contact name as entered in the job screen.
- Manager
- A text field that gives access to the manager name as entered in the job screen.
- IsActive
- A true/false value that indicates if the job is active and useable within MYOB.
- TrackReimbursables
- A true/false value that indicates if the job is used to track reimbursables within MYOB.
- RowVersion
- A row version field.
MYOB API
For a detailed run through of the endpoint, you can see the MYOB API.
Related Endpoints