Entity Definition

Logical Name : ItemRewardDerivationRuleEligibility
Physical Name : CO_EL_ITM_PRDV

Defines an association between an ITEM and a RewardDerivationRule and the conditions which govern the application of the associated rule to an item at the time an instance of the item is recorded as a line item in a sale.

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
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)


Parent Entity Verb Phrase Child Entity
Item is eligibile for ItemRewardDerivationRuleEligibility
RewardEligibilityRule can be a ItemRewardDerivationRuleEligibility

Logical Views containing ItemRewardDerivationRuleEligibility

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level