CustomerOrderProductPriceModifier

Entity Definition

Logical Name : CustomerOrderProductPriceModifier
Physical Name : CO_MDFR_CTOLTM_PDT

The agreed line item discount / retail price modification that will be applied to this item when it is purchased by the Customer.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerOrderLineItemSequenceNumber (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM LineNumber smallint CustomerOrderProductLineItem(DO_CTOLTM_PDT)
CustomerOrderID (FK)(PK) A unique system assigned identifier for the CustomerOrder. ID_ORD Identity integer CustomerOrderProductLineItem(DO_CTOLTM_PDT)
PriceModifierSequenceNumber (PK) Non-significant number assigned as a sequence value used to make each CustomerOrderProductPriceModifier unique. This is required because a customer order line item may have more than one price modifier associated with it. IC_PRC_MDFR LineNumber smallint
PromotionalOfferID (FK) The unique identifier for a promotion. ID_PRM_OFR Identity integer PromotionalOffer(CO_PRM)
Percent The percentage price modification that is to applied to the CustomerOrder Product line item. PE_MDFR Percent decimal(7,4)
Amount The monetary value of the price modification that is to applied to the CustomerOrder Product line item. MO_AMT MoneyShortRetail decimal(7,2)
ReasonCode (FK) The reason code for the price modification that is to applied to the CustomerOrder Product line item. CD_RSN Code varchar(20) Reason(CO_CD_RSN)
PreviousPrice The original price of the CustomerOrder Product line item before the price modification was applied MO_PRC_PRV MoneyShortRetail decimal(7,2)
NewPrice The new price of the CustomerOrder Product line item after the price modification was applied MO_PRC_NEW MoneyShortRetail decimal(7,2)
PromotionalInitiativeID (FK) A token ID for a retailer's PromotionInitiative instance. ID_PRML_INITV Identity integer PromotionalOffer(CO_PRM)

Relationships

Parent Entity Verb Phrase Child Entity
PromotionalOffer is cause of CustomerOrderProductPriceModifier
CustomerOrderProductLineItem has CustomerOrderProductPriceModifier
Reason explains CustomerOrderProductPriceModifier

Logical Views containing CustomerOrderProductPriceModifier

Logical View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 07600 - Customer Order - Macro View
Logical 07610 - Customer Order - Maintenance View