MYOB EXO Business Job Costing
List of entities
Entity details
NamePrimary key columnsNumber of columnsComment
GLACCSACCNO20This table contains details of all General Ledger accounts.
JOBCOST_FLAGS20This table records the statuses for the various Job Flags on each job.
JOBCOST_FLAGSDESCFLAGCODE2This table records descriptions for the customisable Job Flags.
JOBCOST_GENERAL_INFOSEQNO39This table is no longer used - Job Costing configuration options are now stored as profile settings.
JOBCOST_HDRJOBNO66This table contains header information for all jobs.
JOBCOST_LINESSEQNO65This table contains the details of all job quote lines.
JOBCOST_PROJSEQNO5This table contains details of the projects that jobs can be grouped under.
JOBCOST_RESOURCESEQNO19This table contains details of all job resources.
JOB_CATEGORIESCATNO5This table contains details of all Job Categories.
JOB_CONTRACT_BILLINGSSEQNO30This table contains details of Progress Billing records on jobs.
JOB_COSTGROUPSSEQNO8This table records details of the Job Cost Groups.
JOB_COSTTYPESSEQNO13This table records details of the Job Cost Types
JOB_HISTSEQNO8This table contains details of the History Notes attached to jobs.
JOB_OTHER_REPORTSREPORTNO3This is a legacy table that is no longer used.
JOB_OUTPUT_ITEMSSEQNO6This table records details of any items specified on the Output Items sub-tab of a job.
JOB_QUOTE_OPTIONSSEQNO5This table records details of the Quote Options available for job quotes.
JOB_RESOURCE_ALLOCATIONSEQNO11This table records all allocations of resources to jobs.
JOB_RETENTION_LEVELSSEQNO5This table records the default retention levels used by EXO Job Costing.
JOB_STATUSSTATUSKEY11This table contains details of Job Statuses.
JOB_STATUS_CONSTRAINTSEQNO7This table contains details of job workflow constraints.
JOB_TIMESHEETSSEQNO38This table records the timesheet lines entered in the EXO Job Costing Timesheets add-on.
JOB_TIMESHEETS_RATESSEQNO8This table records all Timesheet Rates used by the EXO Job Costing Timesheets add-on.
JOB_TIMESHEET_ALLOWANCESEQNO6This table contains details of all allowances added to timesheet lines.
JOB_TIMESHEET_ALLOWANCE_TYPESSEQNO6This table records all Allowance Types used by the EXO Job Costing Timesheets add-on.
JOB_TRANSACTIONSSEQNO106This table contains line-level information on job transactions.
JOB_TYPESTYPENO4This table contains details of the available Job Types.
NARRATIVESSEQNO2This table contains the narratives attached to transactions.
STAFFSTAFFNO36This table stores details of all EXO Business staff members. These are the people who are authorised to log in to and use the EXO Business system.
STOCK_ITEMSSTOCKCODE85This table contains details of all stock items.