| "STOR_LOC to EMP_STOR_LOC_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_esla_to_stor_loc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | STOR_LOC |
| Child Table | EMP_STOR_LOC_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "STOR_LOC to EMP_STOR_LOC_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "STOR_LOC to EMP_STOR_LOC_ASSC" Foreign Keys |
| Parent Key | Child Key |
| STOR_ID | STOR_ID |
| "STOR_LOC to EMP_STOR_LOC_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "STOR_LOC to EMP_STOR_LOC_ASSC" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_AREA to INVT_CTRL_AREA_SUBAREA" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_icas_to_ctrl_area |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_AREA |
| Child Table | INVT_CTRL_AREA_SUBAREA |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_AREA to INVT_CTRL_AREA_SUBAREA" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_AREA to INVT_CTRL_AREA_SUBAREA" Foreign Keys |
| Parent Key | Child Key |
| CTRL_AREA_ID | CTRL_AREA_ID |
| "INVT_CTRL_AREA to INVT_CTRL_AREA_SUBAREA" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_AREA to INVT_CTRL_AREA_SUBAREA" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_ITEM to INVT_CTRL_ITEM" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ici_to_invt_ctrl_item |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_ITEM |
| Child Table | INVT_CTRL_ITEM |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_ITEM to INVT_CTRL_ITEM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_ITEM to INVT_CTRL_ITEM" Foreign Keys |
| Parent Key | Child Key |
| ITEM_ID | PARENT_ITEM_ID |
| "INVT_CTRL_ITEM to INVT_CTRL_ITEM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_ITEM to INVT_CTRL_ITEM" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_ITEM to INVT_CTRL_INFOR_ITEM" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_icit_to_invt_ctrl_item |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_ITEM |
| Child Table | INVT_CTRL_INFOR_ITEM |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_ITEM to INVT_CTRL_INFOR_ITEM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_ITEM to INVT_CTRL_INFOR_ITEM" Foreign Keys |
| Parent Key | Child Key |
| ITEM_ID | ITEM_ID |
| "INVT_CTRL_ITEM to INVT_CTRL_INFOR_ITEM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_ITEM to INVT_CTRL_INFOR_ITEM" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_ITEM to INVT_ITEM_ATTACH_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_iia_assc_to_ici |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_ITEM |
| Child Table | INVT_ITEM_ATTACH_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_ITEM to INVT_ITEM_ATTACH_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_ITEM to INVT_ITEM_ATTACH_ASSC" Foreign Keys |
| Parent Key | Child Key |
| ITEM_ID | ITEM_ID |
| "INVT_CTRL_ITEM to INVT_ITEM_ATTACH_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_ITEM to INVT_ITEM_ATTACH_ASSC" Bound Attachments |
| Name | Current Value |
| "STOR_LOC to INVT_CTRL_AREA" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_invt_ctrl_area_to_stor_loc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | STOR_LOC |
| Child Table | INVT_CTRL_AREA |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "STOR_LOC to INVT_CTRL_AREA" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "STOR_LOC to INVT_CTRL_AREA" Foreign Keys |
| Parent Key | Child Key |
| STOR_ID | STOR_ID |
| "STOR_LOC to INVT_CTRL_AREA" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "STOR_LOC to INVT_CTRL_AREA" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_AREA to INVT_CTRL_ITEM" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_invt_ctrl_item_to_ica |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_AREA |
| Child Table | INVT_CTRL_ITEM |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_AREA to INVT_CTRL_ITEM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_AREA to INVT_CTRL_ITEM" Foreign Keys |
| Parent Key | Child Key |
| CTRL_AREA_ID | CTRL_AREA_ID |
| "INVT_CTRL_AREA to INVT_CTRL_ITEM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_AREA to INVT_CTRL_ITEM" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_AREA_SUBAREA to INVT_CTRL_ITEM" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_invt_ctrl_item_to_icas |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_AREA_SUBAREA |
| Child Table | INVT_CTRL_ITEM |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_AREA_SUBAREA to INVT_CTRL_ITEM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_AREA_SUBAREA to INVT_CTRL_ITEM" Foreign Keys |
| Parent Key | Child Key |
| CTRL_AREA_ID, SUBAREA_ID | CTRL_AREA_ID, SUBAREA_ID |
| "INVT_CTRL_AREA_SUBAREA to INVT_CTRL_ITEM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_AREA_SUBAREA to INVT_CTRL_ITEM" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_GRP to INVT_CTRL_ITEM" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_invt_ctrl_item_to_icg |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_GRP |
| Child Table | INVT_CTRL_ITEM |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_GRP to INVT_CTRL_ITEM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_GRP to INVT_CTRL_ITEM" Foreign Keys |
| Parent Key | Child Key |
| GRP_ID | GRP_ID |
| "INVT_CTRL_GRP to INVT_CTRL_ITEM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_GRP to INVT_CTRL_ITEM" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_STAT to INVT_CTRL_ITEM" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_invt_ctrl_item_to_status |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_STAT |
| Child Table | INVT_CTRL_ITEM |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_STAT to INVT_CTRL_ITEM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_STAT to INVT_CTRL_ITEM" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "INVT_CTRL_STAT to INVT_CTRL_ITEM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_STAT to INVT_CTRL_ITEM" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_TYPE to INVT_CTRL_ITEM" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_invt_ctrl_item_to_type |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_TYPE |
| Child Table | INVT_CTRL_ITEM |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_TYPE to INVT_CTRL_ITEM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_TYPE to INVT_CTRL_ITEM" Foreign Keys |
| Parent Key | Child Key |
| INVT_TYPE_ID | INVT_TYPE_ID |
| "INVT_CTRL_TYPE to INVT_CTRL_ITEM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_TYPE to INVT_CTRL_ITEM" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_ITEM to INVT_CTRL_ITEM_VERIF" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_invt_ctrl_item_verf_to_ici |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_ITEM |
| Child Table | INVT_CTRL_ITEM_VERIF |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_ITEM to INVT_CTRL_ITEM_VERIF" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_ITEM to INVT_CTRL_ITEM_VERIF" Foreign Keys |
| Parent Key | Child Key |
| ITEM_ID | ITEM_ID |
| "INVT_CTRL_ITEM to INVT_CTRL_ITEM_VERIF" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_ITEM to INVT_CTRL_ITEM_VERIF" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_ROLE to INVT_CTRL_ROLE_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_invt_ctrl_role_assc_to_icr |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_ROLE |
| Child Table | INVT_CTRL_ROLE_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_ROLE to INVT_CTRL_ROLE_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_ROLE to INVT_CTRL_ROLE_ASSC" Foreign Keys |
| Parent Key | Child Key |
| ROLE_ID | ROLE_ID |
| "INVT_CTRL_ROLE to INVT_CTRL_ROLE_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_ROLE to INVT_CTRL_ROLE_ASSC" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_ITEM to INVT_CTRL_TRANS" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_invt_ctrl_trans_to_ici |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_ITEM |
| Child Table | INVT_CTRL_TRANS |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_ITEM to INVT_CTRL_TRANS" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_ITEM to INVT_CTRL_TRANS" Foreign Keys |
| Parent Key | Child Key |
| ITEM_ID | ITEM_ID |
| "INVT_CTRL_ITEM to INVT_CTRL_TRANS" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_ITEM to INVT_CTRL_TRANS" Bound Attachments |
| Name | Current Value |
| "INVT_ITEM_ATTACH to INVT_ITEM_ATTACH_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_invt_item_attach_to_iiaa |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_ITEM_ATTACH |
| Child Table | INVT_ITEM_ATTACH_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_ITEM_ATTACH to INVT_ITEM_ATTACH_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_ITEM_ATTACH to INVT_ITEM_ATTACH_ASSC" Foreign Keys |
| Parent Key | Child Key |
| ATTACH_ID | ATTACH_ID |
| "INVT_ITEM_ATTACH to INVT_ITEM_ATTACH_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_ITEM_ATTACH to INVT_ITEM_ATTACH_ASSC" Bound Attachments |
| Name | Current Value |
| "PO to PO_HIST" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_po_hist_to_po |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PO |
| Child Table | PO_HIST |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PO to PO_HIST" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PO to PO_HIST" Foreign Keys |
| Parent Key | Child Key |
| PO_NBR, PO_ITEM_NBR | PO_NBR, PO_ITEM_NBR |
| "PO to PO_HIST" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PO to PO_HIST" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_ACT to INVT_CTRL_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_smpl_log_to_inct_ctrl_act |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_ACT |
| Child Table | INVT_CTRL_LOG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_ACT to INVT_CTRL_LOG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_ACT to INVT_CTRL_LOG" Foreign Keys |
| Parent Key | Child Key |
| ACT_ID | ACT_ID |
| "INVT_CTRL_ACT to INVT_CTRL_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_ACT to INVT_CTRL_LOG" Bound Attachments |
| Name | Current Value |
| "INVT_CTRL_ITEM to INVT_CTRL_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_smpl_log_to_invt_ctrl_item |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INVT_CTRL_ITEM |
| Child Table | INVT_CTRL_LOG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INVT_CTRL_ITEM to INVT_CTRL_LOG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INVT_CTRL_ITEM to INVT_CTRL_LOG" Foreign Keys |
| Parent Key | Child Key |
| ITEM_ID | ITEM_ID |
| "INVT_CTRL_ITEM to INVT_CTRL_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INVT_CTRL_ITEM to INVT_CTRL_LOG" Bound Attachments |
| Name | Current Value |