Entity Definition

Logical Name : BusinessUnitGroup
Physical Name : CO_BSNGP

A related group of AdministrationCenters, DistributionCenters and RetailStores, with names like Group, Cluster, Region, District, Zone and State. The lowest level of BusinessUnitGroup is in a one-to-one relationship with BusinessUnit. ie: The lowest level of each BusinessUnitGroupFunction hierarchy is a BusinessUnitGroup containing one & only one BusinessUnit.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupID (PK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer
LanguageID (FK) A combination of ISO-639-1 and ISO-3661-1 to denote a language as spoken in a particular country. ID_LGE Code4External char(4) Language(CO_LGE)
BusinessUnitGroupName The common name for the group of BusinessUnits. NM_BSNGP Name varchar(40)


Parent Entity Verb Phrase Child Entity
Language is preferred in BusinessUnitGroup
BusinessUnitGroup uses BusinessUnitGroupRecipe
BusinessUnitGroup houses BusinessUnitGroupPOSDepartment
BusinessUnitGroup is child AssociatedBusinessUnitGroup
BusinessUnitGroup carries BusinessUnitGroupItem
BusinessUnitGroup defines PromotionalOffer
BusinessUnitGroup is periodically reported by BusinessUnitGroupReportingPeriod
BusinessUnitGroup has BusinessUnit
BusinessUnitGroup uses BusinessUnitGroupChannel
BusinessUnitGroup is located in BusinessUnitGroupGeographicSegmentHierarchyGroup
BusinessUnitGroup defines POSIdentity
BusinessUnitGroup is scheduled by BusinessUnitGroupSchedule
BusinessUnitGroup is debited/credited by RevenueCostCenter
BusinessUnitGroup emits BusinessUnitGroupEvent
BusinessUnitGroup defines MerchandiseHierarchySalesRestriction
BusinessUnitGroup is parent AssociatedBusinessUnitGroup

Logical Views containing BusinessUnitGroup

Logical View
Logical 01020 - Item Description - Enterprise View
Logical 01030 - Item Description - Recipe View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 02316 - Distributed Order Management View
Logical 03200 - Reporting - Item Sales View
Logical 03300 - Reporting - Stock Ledger View
Logical 04000 - Financial Ledger - Macro View
Logical 04300 - Financial Ledger - Inventory Control View
Logical 05000 - Taxation - Macro View
Logical 05300 - Taxation - Inventory Control Document View
Logical 06100 - Calendar View
Logical 06600 - Language Support
Logical 10100 - Enterprise - Locations Macro View
Logical 10102 - EnterpriseWeather
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View
Logical 10110 - Enterprise - Location Retailer Organization View
Logical 10115 - Enterprise - Business Unit Groups Hierarchy View
Logical 10200 - Enterprise - Merchandise View
Logical 10300 - Enterprise - POS Department View
Logical 10400 - Enterprise - Channels