Entity Definition

Logical Name : BrandRewardDerivationRuleEligibility
Physical Name : CO_EL_BRN_PRDV

Defines an association between a BRAND and RewardDerivationRule and the conditions that govern the application of the associated rule to an item belonging to the specified BRAND 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
BrandName (FK) A unique name to denote a class of ITEMs as a product. The brand can include private label ITEMs. NM_BRN Name varchar(40) Brand(ID_BRN)


Parent Entity Verb Phrase Child Entity
Brand may trigger BrandRewardDerivationRuleEligibility
RewardEligibilityRule can be a BrandRewardDerivationRuleEligibility

Logical Views containing BrandRewardDerivationRuleEligibility

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level