Entity Definition

Logical Name : PriceLineRewardDerivationRuleEligibility
Physical Name : CO_EL_PRC_LN_PRDV

Defines an association between a MERCHANDISE STRUCTURE RewardDerivationRule and a PRICE LINE for the purposes of triggering a reward. Example: For any item in Department 232 priced 99.99 to 129.99 take 10% off (covers only those items so this is a line item group subtotal reward derivation rule).

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 PriceLine(AS_LN_PRC)
PriceLineID (FK) A unique identifier for this price point. ID_LN_PRC Identity integer PriceLine(AS_LN_PRC)


Parent Entity Verb Phrase Child Entity
PriceLine is eligible for PriceLineRewardDerivationRuleEligibility
RewardEligibilityRule can be a PriceLineRewardDerivationRuleEligibility

Logical Views containing PriceLineRewardDerivationRuleEligibility

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level