MerchandiseHierarchySalesRestriction

Entity Definition

Logical Name : MerchandiseHierarchySalesRestriction
Physical Name : RU_MRHRC

A restriction that limits a particular level's eligibility for sale.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupID (FK)(PK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroup(CO_BSNGP)
MerchandiseHierarchyGroupID (FK)(PK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer MerchandiseHierarchyGroup(CO_MRHRC_GP)
SalesRestrictionTypeCode (FK)(PK) A unique, automatically assigned code for a specific limitation on an ITEM's sale. TY_RST_SLS Code4 char(4) SalesRestriction(RU_RST_SLS)
EffectiveDateTime (PK) The date and time from which the merchandise sales restriction rule is applicable. TS_EF EffectiveDateTime datetime
ExpirationDateTime The date and time until which the merchandise sales restriction rule is applicable. TS_EP ExpirationDateTime datetime

Relationships

Parent Entity Verb Phrase Child Entity
MerchandiseHierarchyGroup sale is restricted by MerchandiseHierarchySalesRestriction
SalesRestriction restricts sale of MerchandiseHierarchySalesRestriction
BusinessUnitGroup defines MerchandiseHierarchySalesRestriction

Logical Views containing MerchandiseHierarchySalesRestriction

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01100 - Item Selling Rules - Macro View
Logical 01110 - Item Selling Rules - Restrictions View
Logical 02350 - Retail Transaction - Restriction Validation View
Logical 10110 - Enterprise - Location Retailer Organization View
Logical 10200 - Enterprise - Merchandise View