Entity Definition

Logical Name : TotalPurchaseMarketBasketRewardDerivationRuleEligibility
Physical Name : CO_EL_MRBK_PRDV

This entity associates a market basket reward eligibility rule with a specific transaction-level RewardPriceDerivationRule. This association links the rule with the condition triggering its application.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PriceChangeRuleID (PK) A type of price change rule. ID_RU_PRC_CHN Identity integer
RewardDerivationRuleEligibilityID (FK)(PK) A unique identifier for a Price Derivation Rule Eligibility. ID_EL_PRDV Identity integer
MarketBasketTriggerID (FK) A unique identifier for the market basket eligibility rule. ID_TRG_MRBK Identity integer TotalPurchaseMarketBasketTrigger(RU_TRG_MRBK)


Parent Entity Verb Phrase Child Entity
TotalPurchaseMarketBasketTrigger may invoke TotalPurchaseMarketBasketRewardDerivationRuleEligibility
RewardEligibilityRule can be a TotalPurchaseMarketBasketRewardDerivationRuleEligibility

Logical Views containing TotalPurchaseMarketBasketRewardDerivationRuleEligibility

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level