Entity Definition

Logical Name : PermanentPriceChangeItemE
Physical Name : MA_ITM_PRN_PRC_ITM

This association between a PERMANENT PRICE CHANGE and ITEM establishes the application of a new permanent price (or percentage or monetary increase or decrease) for an item. A PERMANENT PRICE CHANGE is posted to an ITEM and is not contingent on conditions or events that occur at the point of sale.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupID (FK)(PK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroupItem(AS_BSNGP_ITM)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) BusinessUnitGroupItem(AS_BSNGP_ITM)
EffectiveDateTime (FK)(PK) The date from which the BusinessUnits in the group carry the Item. TS_EF EffectiveDateTime datetime BusinessUnitGroupItem(AS_BSNGP_ITM)
EventID (FK)(PK) A unique, automatically assigned identifier for the Event ID_EV Identity integer PermanentPriceChange(TR_CHN_PRN_PRC)
NewPrice The new Permanent Retail Price to be applied to the Item in all stores in the RetailStoreGroup as a consequence of the PriceChangeEvent MO_PRC_NW MoneyShortRetail decimal(7,2)


Parent Entity Verb Phrase Child Entity
BusinessUnitGroupItem has price changed by PermanentPriceChangeItemE
PermanentPriceChange changes price for PermanentPriceChangeItemE

Logical Views containing PermanentPriceChangeItemE

Logical View
Logical 01300 - Item Price Maintenance View
Logical 06700 - Event Scheduler View