Entity Definition

Logical Name : PriceModificationType
Physical Name : TR_MDF

A modfication in the selling price that is normally charged as an expense to the RETAIL STORE's general ledger or taken as a POS markdown in its stock ledger. Can be applied by transaction line item or to the whole transaction.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RewardDerivationRuleEligibilityID (FK) A unique identifier for a Price Derivation Rule Eligibility. ID_EL_PRDV Identity integer ZPromotionalOfferRewardDerivationRule(RU_PRM_PRDV)
PriceModificationTypeCode (PK) The type code used as a look up key for the standard price modification types represented in the Price Modification. TY_MDF Code2 char(2)
FinancialLedgerAccountID (FK) The reference for the FinancialLedgeraAccount ID_ACNT_LDG Identity integer FinancialLedgerAccount(CO_LE_ACNT_FN)
PriceModificationTypeName The name of the standard price modification types represented in the Price Modification. NM_MDF Name varchar(40)
Description A text description of the standard price modification types represented in the Price Modification entity collection. DE_MDF DescriptionShort varchar(255)
PriceModificationMethodCode A code denoting the method of modifying the price that is being applied to the transaction. Possible values include, Monetary Amount, Percentage, New Price Amount and Cost Plus Price. CD_RDN_MTH Code2 char(2)
ModifyByPercent The percent adjustment that was applied to the unit retail price to arrive at the modified selling price. Example Base price $10.00 ModifyByPercent 5% (.05) Price Modification to be applied is $.50 PE_MDFR_RT_PRC Percent decimal(7,4)
ModifyByAmount A flat monetary value that is to be added to or subtracted from a base price. (Note typically this is a discount so subtraction is the expected action) Example: Base price $10.00 ModifyByAmountt $.50 Price Modification to be applied is $.50 MO_MDFR_RT_PRC Money decimal(16,5)
NewPriceAmount The amount expressed as the new price for the item. MO_NW_PRC Money decimal(16,5)
AdjustmentMethodCode A symbol code denoting what kind of adjustment is being made to the retail price of the Item. e.g. Increase, Decrease. '+' = Add to base retail (amount before price modifier '-' = Subtract from base retail '=' = Replace base retail with ModifyByAmount CD_MTH_ADJT Code2 char(2)
ProRatedFlag A flag instructing POS to pro-rate the price modification across two or more SaleReturnLineItems and to record the application of this as RetailPriceModifier rather than PriceModificationLineItem. FL_PRRT Flag integer
EffectiveDateTime The date & time after which the Price Modification is applicable. TS_EF EffectiveDateTime datetime
ExpirationDateTime The date & time after which the Price Modification is no longer applicable. TS_EP ExpirationDateTime datetime


Parent Entity Verb Phrase Child Entity
FinancialLedgerAccount defines accounting disposition of PriceModificationType
ZPromotionalOfferRewardDerivationRule defines conditions and derivation of PriceModificationType
PriceModificationType causes RetailPriceModifier
PriceModificationType defines PriceModificationLineItem

Logical Views containing PriceModificationType

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 02300 - Retail Transaction - Macro View
Logical 02316 - Distributed Order Management View
Logical 04100 - Financial Ledger - Retail Transaction View