Entity Definition

Logical Name : LocationType
Physical Name : LU_LCN_TYP

Designates a category or location based on physical properties of a Location. These physical properties include whether a locations "built in" to a site (e.g. a room) or whether it is moveable (i.e. not built-in). For our purposes "Fixture" locations are assumed to be moveable which means they may be relocated with a parent location.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
LocationTypeCode (PK) Designates a category of Location. Examples include: FIXTURE FLOOR SECTION STOREWINDOW ENDCAP Other values as determined by the retailer. CD_LCN_TYP Code varchar(20)
LocationTypeDescription Description of the LocationType DE_LCN_TYP DescriptionShort varchar(255)
MoveableFlag Boolean indicator that if TRUE means this location is moveable (not built-in) to a site or parent location. FL_MVBL Flag integer


Parent Entity Verb Phrase Child Entity
LocationType classifies Location

Logical Views containing LocationType

Logical View
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View