MYOB EXO Business Job Costing
Project details
ER diagram
Entities
Attributes
Relationships
List of relationships
Relationship details
Name
Relationship type
Parent
Child
Cardinality
GLACCS_JOBCOST_HDR
Non Identifying
GLACCS
JOBCOST_HDR
Zero Or More
GLACCS_JOBCOST_HDR_SALES
Non Identifying
GLACCS
JOBCOST_HDR
Zero Or More
GLACCS_JOBCOST_LINES
Non Identifying
GLACCS
JOBCOST_LINES
Zero Or More
GLACCS_JOB_CONTRACT_BILLINGS
Non Identifying
GLACCS
JOB_CONTRACT_BILLINGS
Zero Or More
GLACCS_JOB_CONTRACT_BILLINGS_SUB
Non Identifying
GLACCS
JOB_CONTRACT_BILLINGS
Zero Or More
GLACCS_JOB_TRANSACTIONS
Non Identifying
GLACCS
JOB_TRANSACTIONS
Zero Or More
GLACCS_STOCK_ITEMS
Non Identifying
GLACCS
STOCK_ITEMS
Zero Or More
GLACCS_STOCK_ITEMS_COS
Non Identifying
GLACCS
STOCK_ITEMS
Zero Or More
GL_ACCS_STOCKITEMS_PO
Non Identifying
GLACCS
STOCK_ITEMS
Zero Or More
JOBCOST_HDR_JOBCOST_FLAGS
Non Identifying
JOBCOST_HDR
JOBCOST_FLAGS
Zero Or More
JOBCOST_HDR_JOBCOST_LINES
Non Identifying
JOBCOST_HDR
JOBCOST_LINES
Zero Or More
JOBCOST_HDR_JOBCOST_LINES_MASTER
Non Identifying
JOBCOST_HDR
JOBCOST_LINES
Zero Or More
JOBCOST_HDR_JOB_CONTRACT_BILLINGS
Non Identifying
JOBCOST_HDR
JOB_CONTRACT_BILLINGS
Zero Or More
JOBCOST_HDR_JOB_CONTRACT_BILLINGS_MASTER
Non Identifying
JOBCOST_HDR
JOB_CONTRACT_BILLINGS
Zero Or More
JOBCOST_HDR_JOB_HIST
Non Identifying
JOBCOST_HDR
JOB_HIST
Zero Or More
JOBCOST_HDR_JOB_OUTPUT_ITEMS
Non Identifying
JOBCOST_HDR
JOB_OUTPUT_ITEMS
Zero Or More
JOBCOST_HDR_JOB_RESOURCE_ALLOCATION
Non Identifying
JOBCOST_HDR
JOB_RESOURCE_ALLOCATION
Zero Or More
JOBCOST_HDR_JOB_TIMESHEETS
Non Identifying
JOBCOST_HDR
JOB_TIMESHEETS
Zero Or More
JOBCOST_HDR_JOB_TIMESHEETS_TITLE
Non Identifying
JOBCOST_HDR
JOB_TIMESHEETS
Zero Or More
JOBCOST_HDR_JOB_TRANSACTIONS
Non Identifying
JOBCOST_HDR
JOB_TRANSACTIONS
Zero Or More
JOBCOST_HDR_JOB_TRANSACTIONS_MASTER
Non Identifying
JOBCOST_HDR
JOB_TRANSACTIONS
Zero Or More
JOBCOST_LINES_JOB_TRANSACTIONS
Non Identifying
JOBCOST_LINES
JOB_TRANSACTIONS
Zero Or More
JOBCOST_PROJ_JOBCOST_HDR
Non Identifying
JOBCOST_PROJ
JOBCOST_HDR
Zero Or More
JOBCOST_RESOURCE_JOB_RESOURCE_ALLOCATION
Non Identifying
JOBCOST_RESOURCE
JOB_RESOURCE_ALLOCATION
Zero Or More
JOB_CATEGORIES_JOBCOST_HDR
Non Identifying
JOB_CATEGORIES
JOBCOST_HDR
Zero Or More
JOB_CONTRACT_BILLINGS_JOBCOST_LINES
Non Identifying
JOB_CONTRACT_BILLINGS
JOBCOST_LINES
Zero Or More
JOB_CONTRACT_BILLINGS_JOB_TRANSACTIONS
Non Identifying
JOB_CONTRACT_BILLINGS
JOB_TRANSACTIONS
Zero Or More
JOB_COSTGROUPS_JOBCOST_LINES
Non Identifying
JOB_COSTGROUPS
JOBCOST_LINES
Zero Or More
JOB_COSTGROUPS_JOB_COSTTYPES
Non Identifying
JOB_COSTGROUPS
JOB_COSTTYPES
Zero Or More
JOB_COSTGROUPS_JOB_TRANSACTIONS
Non Identifying
JOB_COSTGROUPS
JOB_TRANSACTIONS
Zero Or More
JOB_COSTTYPES_JOBCOST_LINES
Non Identifying
JOB_COSTTYPES
JOBCOST_LINES
Zero Or More
JOB_COSTTYPES_JOB_TRANSACTIONS
Non Identifying
JOB_COSTTYPES
JOB_TRANSACTIONS
Zero Or More
JOB_QUOTE_OPTIONS_JOBCOST_LINES
Non Identifying
JOB_QUOTE_OPTIONS
JOBCOST_LINES
Zero Or More
JOB_STATUS_JOBCOST_HDR
Non Identifying
JOB_STATUS
JOBCOST_HDR
Zero Or More
JOB_TIMESHEETS_RATES_JOB_TIMESHEETS
Non Identifying
JOB_TIMESHEETS_RATES
JOB_TIMESHEETS
Zero Or More
JOB_TIMESHEETS_RATES_JOB_TRANSACTIONS
Non Identifying
JOB_TIMESHEETS_RATES
JOB_TRANSACTIONS
Zero Or More
JOB_TIMESHEET_ALLOWANCE_TYPES_JOB_TIMESHEET_ALLOWANCE
Non Identifying
JOB_TIMESHEET_ALLOWANCE_TYPES
JOB_TIMESHEET_ALLOWANCE
Zero Or More
JOB_TIMESHEET_ALLOWANCE_TYPES_JOB_TIMESHEET_ALLOWANCE_DESC
Non Identifying
JOB_TIMESHEET_ALLOWANCE_TYPES
JOB_TIMESHEET_ALLOWANCE
Zero Or More
JOB_TYPES_JOBCOST_HDR
Non Identifying
JOB_TYPES
JOBCOST_HDR
Zero Or More
NARRATIVES_JOBCOST_LINES
Non Identifying
NARRATIVES
JOBCOST_LINES
Zero Or More
NARRATIVES_JOB_CONTRACT_BILLINGS
Non Identifying
NARRATIVES
JOB_CONTRACT_BILLINGS
Zero Or More
NARRATIVES_JOB_TRANSACTIONS
Non Identifying
NARRATIVES
JOB_TRANSACTIONS
Zero Or More
STAFF_JOBCOST_HDR
Non Identifying
STAFF
JOBCOST_HDR
Zero Or More
STAFF_JOBCOST_HDR_MGR
Non Identifying
STAFF
JOBCOST_HDR
Zero Or More
STAFF_JOBCOST_RESOURCE
Non Identifying
STAFF
JOBCOST_RESOURCE
Zero Or More
STAFF_JOB_TIMESHEETS
Non Identifying
STAFF
JOB_TIMESHEETS
Zero Or More
STAFF_JOB_TIMESHEET_ALLOWANCE
Non Identifying
STAFF
JOB_TIMESHEET_ALLOWANCE
Zero Or More
STAFF_JOB_TRANSACTIONS
Non Identifying
STAFF
JOB_TRANSACTIONS
Zero Or More
STOCK_ITEMS_JOBCOST_LINES
Non Identifying
STOCK_ITEMS
JOBCOST_LINES
Zero Or More
STOCK_ITEMS_JOBCOST_LINES_DESC
Non Identifying
STOCK_ITEMS
JOBCOST_LINES
Zero Or More
STOCK_ITEMS_JOB_CONTRACT_BILLINGS
Non Identifying
STOCK_ITEMS
JOB_CONTRACT_BILLINGS
Zero Or More
STOCK_ITEMS_JOB_OUTPUT_ITEMS
Non Identifying
STOCK_ITEMS
JOB_OUTPUT_ITEMS
Zero Or More
STOCK_ITEMS_JOB_OUTPUT_ITEMS_DESC
Non Identifying
STOCK_ITEMS
JOB_OUTPUT_ITEMS
Zero Or More
STOCK_ITEMS_JOB_TIMESHEETS
Non Identifying
STOCK_ITEMS
JOB_TIMESHEETS
Zero Or More
STOCK_ITEMS_JOB_TRANSACTIONS
Non Identifying
STOCK_ITEMS
JOB_TRANSACTIONS
Zero Or More
STOCK_ITEMS_JOB_TRANSACTIONS_DESC
Non Identifying
STOCK_ITEMS
JOB_TRANSACTIONS
Zero Or More