Entity Definition

Logical Name : Location
Physical Name : LO_LCN

A physical place the retailer conducts business. It may be any or all of the defined sub-types: WorkLocation, SellingLocation, InventoryLocation. As used in ARTS ODM location is intended to reflect non-moveable spaces within a Site (and a Site typically represents a building). A Fixture, is treated as a separate MOVABLE space that merchandise is stored and/or displayed on.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
LocationID (PK) A unique system assigned identifier for the Location. ID_LCN Identity integer
LocationHierarchyGroupID (FK) Token ID for a LocationHierarchyGroup. ID_LCN_HRC_GP Identity integer LocationHierarchyGroup(CO_LCN_HRC_GP)
SizeUnitOfMeasureCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. LU_UOM_SZ Code varchar(20) UnitOfMeasure(CO_UOM)
LocationLevelID (FK) A unique identifier for the Locationlevel, within the location hierarchy that this Location resides at. Eg: Site, RetailStore, Department, DistributionCenter, WareHouse, Floor, Aisle, Rack, Bin, etc... ID_LV_LCN Identity integer LocationLevel(LO_LV_LCN)
ParentLocationID (FK) A unique system assigned identifier for the Location's parent Location. ID_LCN_PRNT Identity integer Location(LO_LCN)
FunctionCode A code that describes what business activities and functions are performed in a specific location. Activities may include: ADMIN - Administration functions (no stock or customer services are handled here) DISPLY - Merchandise display (stock is presented to the customer for sale) CUSTSVC - Customer service - Customer merchandise may be picked up, returned, etc. RETADJ - Returns and adjustments - where a customer may return merchandise for a credit or refund. Where customers may request price adjustments (e.g. when they bought a sale item just before it went on special) STOCKPT - Stock Point - Out of customer sight location where merchandise is stored, counted and tracked at a physical and financial level. This could be the "back room" (like you see in shoe stores) or it could be a receiving dock, etc. RECV - Receiving or merchandise intake location where merchandise is physically unloaded and accepted by the retail store into its inventory (or at least acknowledged). And lots more depending on the retailer. These codes should indicate which locations involve merchandise sales and tracking. Based on the examples above DISPLY, STOCKPT, CUSTSVC, RECV and RETADJ all represent types of locations that involve the storage, sale or return of merchandise. There are many additional functions and codes that might be assigned depending on the retailer. As Internet sales open up, the concept of location changes. Instead of physical locations, merchandise tracking may be by URL and HTML name. The goal is still to understand WHERE merchandise is moving and where the ownership gets transferred from one party to another. CD_FNC Code4 char(4)
SizeQuantity The area of the Location expressed as a quantity in an appropriate UnitOfMeasure QU_SZ_LCN Quantity DECIMAL(9,3)
LocationName The common name for the Location. NM_LCN Name varchar(40)
SiteID (FK) Token ID for a Site ID_STE Identity integer Site(LO_STE)
LocationTypeCode (FK) 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) LocationType(LU_LCN_TYP)


Parent Entity Verb Phrase Child Entity
UnitOfMeasure defines Location
LocationHierarchyGroup defines hierachy for Location
LocationType classifies Location
LocationLevel defines Location
Location has parent Location
Site is divided into Location
Location is location of ItemProcessingTransaction
Location has parent Location
Location is positioned using LocationCoordinate
Location houses MerchandiseHierarchyGroupLocation
Location can be a InventoryLocation
Location can be a SellingLocation
Location can be a NonSellingPublicArea
Location can be a WorkLocation

Logical Views containing Location

Logical View
Logical 02110 - Item Inventory - Location View
Logical 02300 - Retail Transaction - Macro View
Logical 02316 - Distributed Order Management View
Logical 06210 - Access Control - Rules View
Logical 06320 - Party - Address and Contact 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 10110 - Enterprise - Location Retailer Organization View
Logical 10120 - Enterprise - Location, WkStn, Operator, Till
Logical 10200 - Enterprise - Merchandise View
Logical 11120 - Worker - Job Definition View
Logical 11130 - Worker - Access Control View
Logical 11130 - Worker - Access Control View
Logical 21000 - Fresh Item Management Macro View