Entity Definition

Logical Name : TotalPurchaseMarketBasketTrigger
Physical Name : RU_TRG_MRBK

A generic rule that defines sell unit count and/or sell unit retail value trigger points for triggering the application of a MarketBasket based price derivation rule in a sale transaction. This rule is based on the sales volume of a customer's total purchase and is not dependent on any specific item or items. This rule specifies the criteria for applying price derivation rules -- not the rules themselves.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
MarketBasketTriggerID (PK) A unique identifier for the market basket eligibility rule. ID_TRG_MRBK Identity integer
PriceChangeTriggerTypeCode Identifies the type of trigger (i.e. the condition that causes this rule to be applied to a point of sale transaction). The trigger type for example may be based on a transaction total sell unit count for an item or it may be based on the total retail value being purchased (before application of this rule). TY_PRC_CHN_TRGR Code2 char(2)
TransactionItemQuantityTriggerCount The number of sell units required to cause application of this price change rule. QU_TRGR_QTY Quantity DECIMAL(9,3)
TransactionItemTotalRetailTriggerAmount The extended retail value of sell units required to cause application of this price change rule -- before application of this rule. MO_TRGR_RT_TOT Money decimal(16,5)
TransactionRandomDrawingTriggerMethodTypeCode Defines the method to be used to determine market basket eligibility that is determined by a random drawing or rub off ticket or some other random number based approach to choosing a price change to be applied to a complete customer purchase. TY_MTH_TRGR_TRN_RN Code2 char(2)


Parent Entity Verb Phrase Child Entity
TotalPurchaseMarketBasketTrigger may invoke TotalPurchaseMarketBasketRewardDerivationRuleEligibility

Logical Views containing TotalPurchaseMarketBasketTrigger

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level