Entity Definition

Logical Name : MerchandiseHierarchyRewardDerivationRuleEligibility
Physical Name : CO_EL_MRHRC_PRDV

Defines an association between a MERCHANDISE STRUCTURE LEVEL and RewardDerivationRule and the conditions which govern the application of the associated rule to an item falling under the merchandise structure at the time an instance of the item is recorded as a line item in a sale. This entity is used to link Rewards to merchandise hierarchy levels like departments, classes, sub-classes, styles and other named merchandise/service categories. Example: Earn 100 Bonus GOLD MEMBER POINTS when you buy $100 or more MEAT DEPARTMENT items.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RewardDerivationRuleEligibilityID (FK)(PK) A unique identifier for a Price Derivation Rule Eligibility. ID_EL_PRDV Identity integer
MerchandiseHierarchyGroupID (FK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer MerchandiseHierarchyGroup(CO_MRHRC_GP)


Parent Entity Verb Phrase Child Entity
MerchandiseHierarchyGroup is eligible for MerchandiseHierarchyRewardDerivationRuleEligibility
RewardEligibilityRule can be a MerchandiseHierarchyRewardDerivationRuleEligibility

Logical Views containing MerchandiseHierarchyRewardDerivationRuleEligibility

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 10200 - Enterprise - Merchandise View