Entity Definition

Logical Name : LocationLevel
Physical Name : LO_LV_LCN

A group of locations at the same hierarchical level within the location hierarchy.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
LocationLevelID (PK) A unique identifier for a specific location level. ID_LV_LCN Identity integer
Description A narrative that describes a location level. DE_LV_LCN DescriptionNarrative varchar(4000)
StockLedgerControlFlag A flag that indicates whether or not a LOCATION LEVEL will be used to track stock ledger items. If a LOCATION LEVEL has a stock-ledger-control-flag of 'N', no lower levels can have a stock-ledger-control-flag of 'Y'. FL_CTL_STKG Flag integer


Parent Entity Verb Phrase Child Entity
LocationLevel defines Location

Logical Views containing LocationLevel

Logical View
Logical 07017 - Consumer-Customer Lifecycle Context View
Logical 10100 - Enterprise - Locations Macro View
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View
Logical 10200 - Enterprise - Merchandise View