Entity Definition

Logical Name : PriceLine
Physical Name : AS_LN_PRC

A defined range of retail prices delineated by a low retail and a high retail price. For example price line A may be bounded by a low of $.01 to a high of $.99 (the "Dollar Line"), price line B may be bounded by a low of $1.00 and a high of $4.99 and so on. Price lines allow the retail store to group items around retail price ranges for price management purposes.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PriceLineID (PK) A unique identifier for this price point. ID_LN_PRC Identity integer
MerchandiseHierarchyGroupID (FK)(PK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer MerchandiseHierarchyGroup(CO_MRHRC_GP)
LowAmount The low end of a price range that bounds a price line. LL_LN_PRC Money decimal(16,5)
HighAmount The high end of a price range that bounds a price line. UL_LN_PRC Money decimal(16,5)


Parent Entity Verb Phrase Child Entity
MerchandiseHierarchyGroup applies to PriceLine
PriceLine applies to Item
PriceLine is eligible for PriceLineRewardDerivationRuleEligibility

Logical Views containing PriceLine

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level