Entity Definition

Logical Name : BusinessUnitSite
Physical Name : CO_BSN_UN_STE

A record of the location of a particular BusinessUnit at a particular Site for a period of time.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitSiteID (PK) Token identifier for a BusinessUnit located at a specific Site. ID_BSN_UN_STE Identity integer
EffectiveDateTime The date & time from which the nominated BusinessUnit is operating from the nominated Site. TS_EF EffectiveDateTime datetime
BusinessUnitID (FK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer BusinessUnit(LO_BSN_UN)
ExpirationDateTime The date & time after which the nominated BusinessUnit is no longer operating from the nominated Site. TS_EP ExpirationDateTime datetime
SiteID (FK) Token ID for a Site ID_STE Identity integer Site(LO_STE)
StatusCode Indicates if this association between a BusinessUnit and a Site is active or not. Valid values: A - Active I - Inactive CD_STS Code2Status char(2)


Parent Entity Verb Phrase Child Entity
Site contains BusinessUnitSite
BusinessUnit is located at BusinessUnitSite

Logical Views containing BusinessUnitSite

Logical View
Logical 02110 - Item Inventory - Location View
Logical 02200 - Transaction Macro View
Logical 02316 - Distributed Order Management View
Logical 05000 - Taxation - Macro View
Logical 05100 - Taxation - Rules View
Logical 06210 - Access Control - Rules View
Logical 06320 - Party - Address and Contact View
Logical 06400 - Store Equipment View
Logical 07017 - Consumer-Customer Lifecycle Context View
Logical 07030 - Customer Segment Independent Characteristics
Logical 10100 - Enterprise - Locations Macro View
Logical 10102 - EnterpriseWeather
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 10400 - Enterprise - Channels