PriceLine

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)

Relationships

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