Entity Definition

Logical Name : SellingLocation
Physical Name : LO_LCN_SL

An area of floor space or shelf space within the RetailStore to which sales can be assigned. This may be assigned to or rented to a Vendor.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
LocationID (FK)(PK) A unique system assigned identifier for the SellingLocation. ID_LCN Identity integer
BusinessUnitID (FK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer BusinessUnit(LO_BSN_UN)
Size The floor area of the Location set asid for Selling activities expressed in an appropriate UnitOfMeasure QU_SZ_LCN_SL QuantityShortCount decimal(3,0)
VendorID (FK) A unique system assigned identifier for the Vendor who has rented or manages the SellingLocation. ID_VN Identity integer Vendor(PA_VN)


Parent Entity Verb Phrase Child Entity
BusinessUnit contains SellingLocation
Vendor rents SellingLocation
SellingLocation is credited with RetailTransaction
SellingLocation is place of RegistrationEvent
SellingLocation conducted SaleReturnLineItem
SellingLocation is place of ConversionEvent
SellingLocation contains Table
SellingLocation is assigned TillLocationAssignment
SellingLocation is assigned WorkstationLocationAssignment
SellingLocation houses Safe
Location can be a SellingLocation

Logical Views containing SellingLocation

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02305 - Retail Transaction - Header View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02316 - Distributed Order Management View
Logical 02360 - Retail Transaction - Food Service View
Logical 02420 - Control Transaction - Till Movement View
Logical 02500 - Tender Control Transaction - Macro View
Logical 06210 - Access Control - Rules View
Logical 06310 - Party - Role 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 11130 - Worker - Access Control View
Logical 11130 - Worker - Access Control View