|
Relationship: GLACCS_JOBCOST_HDR
| Name | GLACCS_JOBCOST_HDR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | GLACCS (ACCNO) |
| Child with columns | JOBCOST_HDR (COSTGL) |
| Update rule | None |
| Delete rule | None |
Relationship: GLACCS_JOBCOST_HDR_SALES
| Name | GLACCS_JOBCOST_HDR_SALES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | GLACCS (ACCNO) |
| Child with columns | JOBCOST_HDR (SALESGL) |
| Update rule | None |
| Delete rule | None |
Relationship: GLACCS_JOBCOST_LINES
| Name | GLACCS_JOBCOST_LINES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | GLACCS (ACCNO) |
| Child with columns | JOBCOST_LINES (GLCODE) |
| Update rule | None |
| Delete rule | None |
Relationship: GLACCS_JOB_CONTRACT_BILLINGS
| Name | GLACCS_JOB_CONTRACT_BILLINGS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | GLACCS (ACCNO) |
| Child with columns | JOB_CONTRACT_BILLINGS (GLCODE) |
| Update rule | None |
| Delete rule | None |
Relationship: GLACCS_JOB_CONTRACT_BILLINGS_SUB
| Name | GLACCS_JOB_CONTRACT_BILLINGS_SUB |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | GLACCS (ACCNO) |
| Child with columns | JOB_CONTRACT_BILLINGS (GLSUBCODE) |
| Update rule | None |
| Delete rule | None |
Relationship: GLACCS_JOB_TRANSACTIONS
| Name | GLACCS_JOB_TRANSACTIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | GLACCS (ACCNO) |
| Child with columns | JOB_TRANSACTIONS (GLCODE) |
| Update rule | None |
| Delete rule | None |
Relationship: GLACCS_STOCK_ITEMS
| Name | GLACCS_STOCK_ITEMS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | GLACCS (ACCNO) |
| Child with columns | STOCK_ITEMS (SALES_GL_CODE) |
| Update rule | None |
| Delete rule | None |
Relationship: GLACCS_STOCK_ITEMS_COS
| Name | GLACCS_STOCK_ITEMS_COS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | GLACCS (ACCNO) |
| Child with columns | STOCK_ITEMS (COS_GL_CODE) |
| Update rule | None |
| Delete rule | None |
Relationship: GL_ACCS_STOCKITEMS_PO
| Name | GL_ACCS_STOCKITEMS_PO |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | GLACCS (ACCNO) |
| Child with columns | STOCK_ITEMS (PURCH_GL_CODE) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOBCOST_FLAGS
| Name | JOBCOST_HDR_JOBCOST_FLAGS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (JOBNO) |
| Child with columns | JOBCOST_FLAGS (JOBNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOBCOST_LINES
| Name | JOBCOST_HDR_JOBCOST_LINES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (JOBNO) |
| Child with columns | JOBCOST_LINES (JOBNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOBCOST_LINES_MASTER
| Name | JOBCOST_HDR_JOBCOST_LINES_MASTER |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (JOBNO) |
| Child with columns | JOBCOST_LINES (MASTER_JOBNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOB_CONTRACT_BILLINGS
| Name | JOBCOST_HDR_JOB_CONTRACT_BILLINGS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (JOBNO) |
| Child with columns | JOB_CONTRACT_BILLINGS (JOBNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOB_CONTRACT_BILLINGS_MASTER
| Name | JOBCOST_HDR_JOB_CONTRACT_BILLINGS_MASTER |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (JOBNO) |
| Child with columns | JOB_CONTRACT_BILLINGS (MASTER_JOBNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOB_HIST
| Name | JOBCOST_HDR_JOB_HIST |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (JOBNO) |
| Child with columns | JOB_HIST (JOBNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOB_OUTPUT_ITEMS
| Name | JOBCOST_HDR_JOB_OUTPUT_ITEMS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (JOBNO) |
| Child with columns | JOB_OUTPUT_ITEMS (JOBNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOB_RESOURCE_ALLOCATION
| Name | JOBCOST_HDR_JOB_RESOURCE_ALLOCATION |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (JOBNO) |
| Child with columns | JOB_RESOURCE_ALLOCATION (JOBNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOB_TIMESHEETS
| Name | JOBCOST_HDR_JOB_TIMESHEETS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (JOBNO) |
| Child with columns | JOB_TIMESHEETS (JOBNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOB_TIMESHEETS_TITLE
| Name | JOBCOST_HDR_JOB_TIMESHEETS_TITLE |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (TITLE) |
| Child with columns | JOB_TIMESHEETS (TITLE) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOB_TRANSACTIONS
| Name | JOBCOST_HDR_JOB_TRANSACTIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (JOBNO) |
| Child with columns | JOB_TRANSACTIONS (JOBNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_HDR_JOB_TRANSACTIONS_MASTER
| Name | JOBCOST_HDR_JOB_TRANSACTIONS_MASTER |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_HDR (JOBNO) |
| Child with columns | JOB_TRANSACTIONS (MASTER_JOBNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_LINES_JOB_TRANSACTIONS
| Name | JOBCOST_LINES_JOB_TRANSACTIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_LINES (SEQNO) |
| Child with columns | JOB_TRANSACTIONS (SOURCE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_PROJ_JOBCOST_HDR
| Name | JOBCOST_PROJ_JOBCOST_HDR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_PROJ (SEQNO) |
| Child with columns | JOBCOST_HDR (PROJ_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOBCOST_RESOURCE_JOB_RESOURCE_ALLOCATION
| Name | JOBCOST_RESOURCE_JOB_RESOURCE_ALLOCATION |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOBCOST_RESOURCE (SEQNO) |
| Child with columns | JOB_RESOURCE_ALLOCATION (RESOURCE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_CATEGORIES_JOBCOST_HDR
| Name | JOB_CATEGORIES_JOBCOST_HDR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_CATEGORIES (CATNO) |
| Child with columns | JOBCOST_HDR (CATEGORY) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_CONTRACT_BILLINGS_JOBCOST_LINES
| Name | JOB_CONTRACT_BILLINGS_JOBCOST_LINES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_CONTRACT_BILLINGS (SEQNO) |
| Child with columns | JOBCOST_LINES (SCHEDULE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_CONTRACT_BILLINGS_JOB_TRANSACTIONS
| Name | JOB_CONTRACT_BILLINGS_JOB_TRANSACTIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_CONTRACT_BILLINGS (SEQNO) |
| Child with columns | JOB_TRANSACTIONS (SCHEDULE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_COSTGROUPS_JOBCOST_LINES
| Name | JOB_COSTGROUPS_JOBCOST_LINES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_COSTGROUPS (SEQNO) |
| Child with columns | JOBCOST_LINES (COST_CENTRE2) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_COSTGROUPS_JOB_COSTTYPES
| Name | JOB_COSTGROUPS_JOB_COSTTYPES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_COSTGROUPS (SEQNO) |
| Child with columns | JOB_COSTTYPES (DEF_COSTGROUP) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_COSTGROUPS_JOB_TRANSACTIONS
| Name | JOB_COSTGROUPS_JOB_TRANSACTIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_COSTGROUPS (SEQNO) |
| Child with columns | JOB_TRANSACTIONS (COST_GROUP) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_COSTTYPES_JOBCOST_LINES
| Name | JOB_COSTTYPES_JOBCOST_LINES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_COSTTYPES (SEQNO) |
| Child with columns | JOBCOST_LINES (COST_CENTRE) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_COSTTYPES_JOB_TRANSACTIONS
| Name | JOB_COSTTYPES_JOB_TRANSACTIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_COSTTYPES (SEQNO) |
| Child with columns | JOB_TRANSACTIONS (COST_TYPE) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_QUOTE_OPTIONS_JOBCOST_LINES
| Name | JOB_QUOTE_OPTIONS_JOBCOST_LINES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_QUOTE_OPTIONS (SEQNO) |
| Child with columns | JOBCOST_LINES (OPTION_NO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_STATUS_JOBCOST_HDR
| Name | JOB_STATUS_JOBCOST_HDR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_STATUS (STATUSKEY) |
| Child with columns | JOBCOST_HDR (STATUS) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_TIMESHEETS_RATES_JOB_TIMESHEETS
| Name | JOB_TIMESHEETS_RATES_JOB_TIMESHEETS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_TIMESHEETS_RATES (SEQNO) |
| Child with columns | JOB_TIMESHEETS (RATE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_TIMESHEETS_RATES_JOB_TRANSACTIONS
| Name | JOB_TIMESHEETS_RATES_JOB_TRANSACTIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_TIMESHEETS_RATES (SEQNO) |
| Child with columns | JOB_TRANSACTIONS (RATE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_TIMESHEET_ALLOWANCE_TYPES_JOB_TIMESHEET_ALLOWANCE
| Name | JOB_TIMESHEET_ALLOWANCE_TYPES_JOB_TIMESHEET_ALLOWANCE |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_TIMESHEET_ALLOWANCE_TYPES (ALLOWANCE_ID) |
| Child with columns | JOB_TIMESHEET_ALLOWANCE (ALLOWANCE_ID) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_TIMESHEET_ALLOWANCE_TYPES_JOB_TIMESHEET_ALLOWANCE_DESC
| Name | JOB_TIMESHEET_ALLOWANCE_TYPES_JOB_TIMESHEET_ALLOWANCE_DESC |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_TIMESHEET_ALLOWANCE_TYPES (DESCRIPTION) |
| Child with columns | JOB_TIMESHEET_ALLOWANCE (DESCRIPTION) |
| Update rule | None |
| Delete rule | None |
Relationship: JOB_TYPES_JOBCOST_HDR
| Name | JOB_TYPES_JOBCOST_HDR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | JOB_TYPES (TYPENO) |
| Child with columns | JOBCOST_HDR (JOBTYPE) |
| Update rule | None |
| Delete rule | None |
Relationship: NARRATIVES_JOBCOST_LINES
| Name | NARRATIVES_JOBCOST_LINES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | NARRATIVES (SEQNO) |
| Child with columns | JOBCOST_LINES (NARRATIVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: NARRATIVES_JOB_CONTRACT_BILLINGS
| Name | NARRATIVES_JOB_CONTRACT_BILLINGS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | NARRATIVES (SEQNO) |
| Child with columns | JOB_CONTRACT_BILLINGS (NARRATIVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: NARRATIVES_JOB_TRANSACTIONS
| Name | NARRATIVES_JOB_TRANSACTIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | NARRATIVES (SEQNO) |
| Child with columns | JOB_TRANSACTIONS (NARRATIVE_SEQNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_JOBCOST_HDR
| Name | STAFF_JOBCOST_HDR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | JOBCOST_HDR (STAFFNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_JOBCOST_HDR_MGR
| Name | STAFF_JOBCOST_HDR_MGR |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | JOBCOST_HDR (ACTIONBY) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_JOBCOST_RESOURCE
| Name | STAFF_JOBCOST_RESOURCE |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | JOBCOST_RESOURCE (STAFFNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_JOB_TIMESHEETS
| Name | STAFF_JOB_TIMESHEETS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | JOB_TIMESHEETS (STAFFNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_JOB_TIMESHEET_ALLOWANCE
| Name | STAFF_JOB_TIMESHEET_ALLOWANCE |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | JOB_TIMESHEET_ALLOWANCE (STAFFNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STAFF_JOB_TRANSACTIONS
| Name | STAFF_JOB_TRANSACTIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STAFF (STAFFNO) |
| Child with columns | JOB_TRANSACTIONS (STAFFNO) |
| Update rule | None |
| Delete rule | None |
Relationship: STOCK_ITEMS_JOBCOST_LINES
| Name | STOCK_ITEMS_JOBCOST_LINES |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STOCK_ITEMS (STOCKCODE) |
| Child with columns | JOBCOST_LINES (STOCKCODE) |
| Update rule | None |
| Delete rule | None |
Relationship: STOCK_ITEMS_JOBCOST_LINES_DESC
| Name | STOCK_ITEMS_JOBCOST_LINES_DESC |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STOCK_ITEMS (DESCRIPTION) |
| Child with columns | JOBCOST_LINES (DESCRIPTION) |
| Update rule | None |
| Delete rule | None |
Relationship: STOCK_ITEMS_JOB_CONTRACT_BILLINGS
| Name | STOCK_ITEMS_JOB_CONTRACT_BILLINGS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STOCK_ITEMS (STOCKCODE) |
| Child with columns | JOB_CONTRACT_BILLINGS (STOCKCODE) |
| Update rule | None |
| Delete rule | None |
Relationship: STOCK_ITEMS_JOB_OUTPUT_ITEMS
| Name | STOCK_ITEMS_JOB_OUTPUT_ITEMS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STOCK_ITEMS (STOCKCODE) |
| Child with columns | JOB_OUTPUT_ITEMS (STOCKCODE) |
| Update rule | None |
| Delete rule | None |
Relationship: STOCK_ITEMS_JOB_OUTPUT_ITEMS_DESC
| Name | STOCK_ITEMS_JOB_OUTPUT_ITEMS_DESC |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STOCK_ITEMS (DESCRIPTION) |
| Child with columns | JOB_OUTPUT_ITEMS (DESCRIPTION) |
| Update rule | None |
| Delete rule | None |
Relationship: STOCK_ITEMS_JOB_TIMESHEETS
| Name | STOCK_ITEMS_JOB_TIMESHEETS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STOCK_ITEMS (STOCKCODE) |
| Child with columns | JOB_TIMESHEETS (STOCKCODE) |
| Update rule | None |
| Delete rule | None |
Relationship: STOCK_ITEMS_JOB_TRANSACTIONS
| Name | STOCK_ITEMS_JOB_TRANSACTIONS |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STOCK_ITEMS (STOCKCODE) |
| Child with columns | JOB_TRANSACTIONS (STOCKCODE) |
| Update rule | None |
| Delete rule | None |
Relationship: STOCK_ITEMS_JOB_TRANSACTIONS_DESC
| Name | STOCK_ITEMS_JOB_TRANSACTIONS_DESC |
| Comment | |
| Relationship type | Non Identifying |
| Cardinality | Zero Or More |
| Parent with columns | STOCK_ITEMS (DESCRIPTION) |
| Child with columns | JOB_TRANSACTIONS (DESCRIPTION) |
| Update rule | None |
| Delete rule | None |
|