Entity Definition

Logical Name : RetailStore
Physical Name : PA_STR_RTL

A retail outlet that sells merchandise and services through either a physical location, catalog, web page or other channel. It may or may not be identical to a Site. It may be co-located at the same Site as a DistributionCenter, InventoryLocation or AdministrativeCenter.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer
OpenDate The opening date for the RETAIL STORE DC_OPN_RT_STR DateCalendar date
ClosingDate The closing date for the RETAIL STORE DC_CL_RT_STR DateCalendar date
Size The size of the RETAIL STORE. This is usually split by the non-sales and sales areas. QU_SZ_STR Quantity DECIMAL(9,3)
SellingAreaSize The size of the selling floor. in a large STORE this is further split by the sales floor and by the merchandise departments. QU_SZ_AR_SL Quantity DECIMAL(9,3)
LastRemodelDate Last date this retail store business unit was remodeled. DC_RMDL_LST DateCalendar date


Parent Entity Verb Phrase Child Entity
RetailStore has clients of RetailStoreCustomer
RetailStore has StockMeter
RetailStore delineates MerchandiseHierarchySalesSummary
RetailStore resides in SupplierPricePromotionZone
RetailStore delineates POSDepartmentHistory
RetailStore houses FuelPump
RetailStore has installed FuelingPoint
RetailStore houses TankLevelGauge
RetailStore is location for RetailStoreLocationEvent
RetailStore issues StoredValueInstrument
RetailStore delineates RelatedItemAssociationSalesSummary
RetailStore delineates PromotionalOfferHistory
RetailStore delineates ItemSalesSummary
RetailStore has SalesMeter
RetailStore is tracked by StoreHistory
RetailStore issues GiftCertificate
BusinessUnit can be a RetailStore

Logical Views containing RetailStore

Logical View
Logical 01020 - Item Description - Enterprise View
Logical 01500 - Item Supplier View
Logical 02110 - Item Inventory - Location View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 02200 - Transaction Macro View
Logical 02305 - Retail Transaction - Header View
Logical 02316 - Distributed Order Management View
Logical 02340 - Retail Transaction - Shipping View
Logical 02360 - Retail Transaction - Food Service View
Logical 02390 - Retail Transaction - Stored Value Instrument
Logical 02400 - Control Transaction Macro View
Logical 02440 - Control Transaction - Voids View
Logical 03120 - Reporting - Store Operations - Period View
Logical 03200 - Reporting - Item Sales View
Logical 05000 - Taxation - Macro View
Logical 05100 - Taxation - Rules View
Logical 05300 - Taxation - Inventory Control Document View
Logical 06210 - Access Control - Rules View
Logical 06310 - Party - Role View
Logical 06320 - Party - Address and Contact View
Logical 06400 - Store Equipment View
Logical 06700 - Event Scheduler View
Logical 07010 - Customer Account Information Extended
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 10115 - Enterprise - Business Unit Groups Hierarchy View
Logical 10120 - Enterprise - Location, WkStn, Operator, Till
Logical 10200 - Enterprise - Merchandise View
Logical 10300 - Enterprise - POS Department View
Logical 10400 - Enterprise - Channels
Logical 11140 - Worker - Retail Transaction View
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20050 - Forecourt Tank Gauge View