Name | Primary key columns | Number of columns | Comment |
GLACCS | ACCNO | 20 | This table contains details of all General Ledger accounts. |
JOBCOST_FLAGS | | 20 | This table records the statuses for the various Job Flags on each job. |
JOBCOST_FLAGSDESC | FLAGCODE | 2 | This table records descriptions for the customisable Job Flags. |
JOBCOST_GENERAL_INFO | SEQNO | 39 | This table is no longer used - Job Costing configuration options are now stored as profile settings. |
JOBCOST_HDR | JOBNO | 66 | This table contains header information for all jobs. |
JOBCOST_LINES | SEQNO | 65 | This table contains the details of all job quote lines. |
JOBCOST_PROJ | SEQNO | 5 | This table contains details of the projects that jobs can be grouped under. |
JOBCOST_RESOURCE | SEQNO | 19 | This table contains details of all job resources. |
JOB_CATEGORIES | CATNO | 5 | This table contains details of all Job Categories. |
JOB_CONTRACT_BILLINGS | SEQNO | 30 | This table contains details of Progress Billing records on jobs. |
JOB_COSTGROUPS | SEQNO | 8 | This table records details of the Job Cost Groups. |
JOB_COSTTYPES | SEQNO | 13 | This table records details of the Job Cost Types |
JOB_HIST | SEQNO | 8 | This table contains details of the History Notes attached to jobs. |
JOB_OTHER_REPORTS | REPORTNO | 3 | This is a legacy table that is no longer used. |
JOB_OUTPUT_ITEMS | SEQNO | 6 | This table records details of any items specified on the Output Items sub-tab of a job. |
JOB_QUOTE_OPTIONS | SEQNO | 5 | This table records details of the Quote Options available for job quotes. |
JOB_RESOURCE_ALLOCATION | SEQNO | 11 | This table records all allocations of resources to jobs. |
JOB_RETENTION_LEVELS | SEQNO | 5 | This table records the default retention levels used by EXO Job Costing. |
JOB_STATUS | STATUSKEY | 11 | This table contains details of Job Statuses. |
JOB_STATUS_CONSTRAINT | SEQNO | 7 | This table contains details of job workflow constraints. |
JOB_TIMESHEETS | SEQNO | 38 | This table records the timesheet lines entered in the EXO Job Costing Timesheets add-on. |
JOB_TIMESHEETS_RATES | SEQNO | 8 | This table records all Timesheet Rates used by the EXO Job Costing Timesheets add-on. |
JOB_TIMESHEET_ALLOWANCE | SEQNO | 6 | This table contains details of all allowances added to timesheet lines. |
JOB_TIMESHEET_ALLOWANCE_TYPES | SEQNO | 6 | This table records all Allowance Types used by the EXO Job Costing Timesheets add-on. |
JOB_TRANSACTIONS | SEQNO | 106 | This table contains line-level information on job transactions. |
JOB_TYPES | TYPENO | 4 | This table contains details of the available Job Types. |
NARRATIVES | SEQNO | 2 | This table contains the narratives attached to transactions. |
STAFF | STAFFNO | 36 | This 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_ITEMS | STOCKCODE | 85 | This table contains details of all stock items. |