"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 |