Entity Definition

Logical Name : AssociatedBusinessUnitGroup
Physical Name : ST_ASCTN_BSNGP

An associative entity resolving the recursive-many-to-many relationship on BusinessUnitGroup. It denotes a parent & child relationship between two BusinessUnitGroups for a particular BusinessUnitGroupFunction. Each child BusinessUnitGroup will have a different parent BusinessUnitGroup for each BusinessUnitGroupFunction that is defined.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupFunctionID (FK)(PK) A unique system assigned identifier for a BusinessUnit hierarchy business function. ID_BSNGP_FNC Identity integer BusinessUnitGroupLevel(CO_BSNGP_LV)
ParentBusinessUnitGroupLevelID (FK)(PK) A unique system assigned identifier for a level within the BusinessUnit grouping hierarchy. ID_BSNGP_LV Identity integer BusinessUnitGroupLevel(CO_BSNGP_LV)
ParentBusinessUnitGroupID (FK)(PK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP_PRNT Identity integer BusinessUnitGroup(CO_BSNGP)
ChildBusinessUnitGroupID (FK)(PK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP_CHLD Identity integer BusinessUnitGroup(CO_BSNGP)
EffectiveDate The date and time from which the association is applicable. DC_EF EffectiveDate date
ExpirationDate The date and time until which the association is applicable. DC_EP ExpirationDate date


Parent Entity Verb Phrase Child Entity
BusinessUnitGroupLevel defines parent AssociatedBusinessUnitGroup
BusinessUnitGroup is child AssociatedBusinessUnitGroup
BusinessUnitGroup is parent AssociatedBusinessUnitGroup

Logical Views containing AssociatedBusinessUnitGroup

Logical View
Logical 01020 - Item Description - Enterprise View
Logical 03200 - Reporting - Item Sales View
Logical 03300 - Reporting - Stock Ledger View
Logical 06100 - Calendar View
Logical 10102 - EnterpriseWeather
Logical 10110 - Enterprise - Location Retailer Organization View
Logical 10115 - Enterprise - Business Unit Groups Hierarchy View
Logical 10200 - Enterprise - Merchandise View
Logical 10400 - Enterprise - Channels