"OPER.Employee to Employee Storage Location Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_esla_to_employee 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Employee 
Child Entity  Employee Storage Location Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Employee to Employee Storage Location Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Employee to Employee Storage Location Association" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"OPER.Employee to Employee Storage Location Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Employee to Employee Storage Location Association" Bound Attachments 
Name  Current Value 


"Storage Location to Employee Storage Location Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_esla_to_stor_loc 
Relationship Business Name   
Logical Only  No 
Parent Entity  Storage Location 
Child Entity  Employee Storage Location Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Storage Location to Employee Storage Location Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Storage Location to Employee Storage Location Association" Foreign Keys 
Parent Key  Child Key 
Storage Identifier  Storage Identifier 

"Storage Location to Employee Storage Location Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Storage Location to Employee Storage Location Association" Bound Attachments 
Name  Current Value 


"Inventory Control Area to Inventory Control Area Subarea" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_icas_to_ctrl_area 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Area 
Child Entity  Inventory Control Area Subarea 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Control Area to Inventory Control Area Subarea" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Area to Inventory Control Area Subarea" Foreign Keys 
Parent Key  Child Key 
ControlArea Identifier  ControlArea Identifier 

"Inventory Control Area to Inventory Control Area Subarea" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Area to Inventory Control Area Subarea" Bound Attachments 
Name  Current Value 


"Inventory Control Item to Inventory Control Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_ici_to_invt_ctrl_item 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Item 
Child Entity  Inventory Control Item 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Inventory Control Item to Inventory Control Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Item to Inventory Control Item" Foreign Keys 
Parent Key  Child Key 
Item Identifier  Parent Item Identifier 

"Inventory Control Item to Inventory Control Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Item to Inventory Control Item" Bound Attachments 
Name  Current Value 


"Inventory Control Item to Inventory Control Infor Item" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_icit_to_invt_ctrl_item 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Item 
Child Entity  Inventory Control Infor Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Control Item to Inventory Control Infor Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Item to Inventory Control Infor Item" Foreign Keys 
Parent Key  Child Key 
Item Identifier  Item Identifier 

"Inventory Control Item to Inventory Control Infor Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Item to Inventory Control Infor Item" Bound Attachments 
Name  Current Value 


"Inventory Control Item to Inventory Item Attachment Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_iia_assc_to_ici 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Item 
Child Entity  Inventory Item Attachment Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Control Item to Inventory Item Attachment Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Item to Inventory Item Attachment Association" Foreign Keys 
Parent Key  Child Key 
Item Identifier  Item Identifier 

"Inventory Control Item to Inventory Item Attachment Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Item to Inventory Item Attachment Association" Bound Attachments 
Name  Current Value 


"Storage Location to Inventory Control Area" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_invt_ctrl_area_to_stor_loc 
Relationship Business Name   
Logical Only  No 
Parent Entity  Storage Location 
Child Entity  Inventory Control Area 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Storage Location to Inventory Control Area" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Storage Location to Inventory Control Area" Foreign Keys 
Parent Key  Child Key 
Storage Identifier  Storage Identifier 

"Storage Location to Inventory Control Area" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Storage Location to Inventory Control Area" Bound Attachments 
Name  Current Value 


"Inventory Control Area to Inventory Control Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_invt_ctrl_item_to_ica 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Area 
Child Entity  Inventory Control Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Control Area to Inventory Control Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Area to Inventory Control Item" Foreign Keys 
Parent Key  Child Key 
ControlArea Identifier  ControlArea Identifier 

"Inventory Control Area to Inventory Control Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Area to Inventory Control Item" Bound Attachments 
Name  Current Value 


"Inventory Control Area Subarea to Inventory Control Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_invt_ctrl_item_to_icas 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Area Subarea 
Child Entity  Inventory Control Item 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Inventory Control Area Subarea to Inventory Control Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Area Subarea to Inventory Control Item" Foreign Keys 
Parent Key  Child Key 
ControlArea Identifier, SubArea Identifier  ControlArea Identifier, SubArea Identifier 

"Inventory Control Area Subarea to Inventory Control Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Area Subarea to Inventory Control Item" Bound Attachments 
Name  Current Value 


"Inventory Control Group to Inventory Control Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_invt_ctrl_item_to_icg 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Group 
Child Entity  Inventory Control Item 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Inventory Control Group to Inventory Control Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Group to Inventory Control Item" Foreign Keys 
Parent Key  Child Key 
Group Identifier  Group Identifier 

"Inventory Control Group to Inventory Control Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Group to Inventory Control Item" Bound Attachments 
Name  Current Value 


"Inventory Control Status to Inventory Control Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_invt_ctrl_item_to_status 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Status 
Child Entity  Inventory Control Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Control Status to Inventory Control Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Status to Inventory Control Item" Foreign Keys 
Parent Key  Child Key 
Status Identifier  Status Identifier 

"Inventory Control Status to Inventory Control Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Status to Inventory Control Item" Bound Attachments 
Name  Current Value 


"Inventory Control Type to Inventory Control Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_invt_ctrl_item_to_type 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Type 
Child Entity  Inventory Control Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Control Type to Inventory Control Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Type to Inventory Control Item" Foreign Keys 
Parent Key  Child Key 
Inventory Type Identifier  Inventory Type Identifier 

"Inventory Control Type to Inventory Control Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Type to Inventory Control Item" Bound Attachments 
Name  Current Value 


"Inventory Control Item to Inventory Control Item Verification" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_invt_ctrl_item_verf_to_ici 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Item 
Child Entity  Inventory Control Item Verification 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Control Item to Inventory Control Item Verification" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Item to Inventory Control Item Verification" Foreign Keys 
Parent Key  Child Key 
Item Identifier  Item Identifier 

"Inventory Control Item to Inventory Control Item Verification" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Item to Inventory Control Item Verification" Bound Attachments 
Name  Current Value 


"Inventory Control Role to Inventory Control Role Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_invt_ctrl_role_assc_to_icr 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Role 
Child Entity  Inventory Control Role Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Control Role to Inventory Control Role Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Role to Inventory Control Role Association" Foreign Keys 
Parent Key  Child Key 
Role Identifer  Role Identifer 

"Inventory Control Role to Inventory Control Role Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Role to Inventory Control Role Association" Bound Attachments 
Name  Current Value 


"Inventory Control Item to Inventory Control Transfer" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_invt_ctrl_trans_to_ici 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Item 
Child Entity  Inventory Control Transfer 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Control Item to Inventory Control Transfer" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Item to Inventory Control Transfer" Foreign Keys 
Parent Key  Child Key 
Item Identifier  Item Identifier 

"Inventory Control Item to Inventory Control Transfer" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Item to Inventory Control Transfer" Bound Attachments 
Name  Current Value 


"Inventory Item Attachment to Inventory Item Attachment Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_invt_item_attach_to_iiaa 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Item Attachment 
Child Entity  Inventory Item Attachment Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Item Attachment to Inventory Item Attachment Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Item Attachment to Inventory Item Attachment Association" Foreign Keys 
Parent Key  Child Key 
Attachment Identifier  Attachment Identifier 

"Inventory Item Attachment to Inventory Item Attachment Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Item Attachment to Inventory Item Attachment Association" Bound Attachments 
Name  Current Value 


"Purchase Order to Purchase Order History" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_po_hist_to_po 
Relationship Business Name   
Logical Only  No 
Parent Entity  Purchase Order 
Child Entity  Purchase Order History 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Purchase Order to Purchase Order History" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Purchase Order to Purchase Order History" Foreign Keys 
Parent Key  Child Key 
Purchase Order Number, Purchase Order Item Number  Purchase Order Number, Purchase Order Item Number 

"Purchase Order to Purchase Order History" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Purchase Order to Purchase Order History" Bound Attachments 
Name  Current Value 


"Inventory Control Activity to Inventory Control Log" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_smpl_log_to_inct_ctrl_act 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Activity 
Child Entity  Inventory Control Log 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Control Activity to Inventory Control Log" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Activity to Inventory Control Log" Foreign Keys 
Parent Key  Child Key 
Activity Identifier  Activity Identifier 

"Inventory Control Activity to Inventory Control Log" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Activity to Inventory Control Log" Bound Attachments 
Name  Current Value 


"Inventory Control Item to Inventory Control Log" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_smpl_log_to_invt_ctrl_item 
Relationship Business Name   
Logical Only  No 
Parent Entity  Inventory Control Item 
Child Entity  Inventory Control Log 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Inventory Control Item to Inventory Control Log" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Inventory Control Item to Inventory Control Log" Foreign Keys 
Parent Key  Child Key 
Item Identifier  Item Identifier 

"Inventory Control Item to Inventory Control Log" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Inventory Control Item to Inventory Control Log" Bound Attachments 
Name  Current Value