Special Price Actions Page (Fields)
The following describes the fields that could appear on the page depending on how it is configured.
Absolute Margin Change
The change in margin.
New Margin - Current Margin
Absolute Margin % Change
The change in margin as a percentage.
[(New Margin - Current Margin) / Current Margin] * 100
Absolute Profit Change
The change in profit.
New Profit - Current Profit
Absolute Profit Change %
The change in profit as a percentage
[(New Profit - Current Profit) / Current Profit] * 100
Absolute Revenue Change
The change in revenue.
New Revenue - Current Revenue
Absolute Revenue Change %
The change in revenue as a percentage.
[(New Revenue - Current Revenue) / Current Revenue)] * 100
Approval Level
The approval level in which the SKU is being processed.
Current Custom Cost (1-5)
Custom fields for cost. Represents the current costs for the part.
Current Custom Price (1-20)
Custom fields for price.
Current Damaged Cost
Typically indicates cost for the part if it is broken.
Current Damaged Price
Typically indicates the price for the part if it is broken. This can also be used for price stream values by mapping a price stream to this field.
Current Expedite Cost
Typically indicates the cost for the part if it is expedited for delivery.
Current Expedite Price
Typically indicates the price for the part if it is expedited for delivery. This can also be used for price stream values by mapping a price stream to this field.
Current Margin %
The current margin percentage for the SKU.
(Current Standard Price - Current Standard Cost / Current Standard Price)*100
Current Profit
Current profit amount for the selected SKU.
(Current Price - Current Cost) * Current Volume, aggregated for all the price streams
Current Refurbished Cost
Typically indicates cost for the part if it is remanufactured or repaired.
Current Refurbished Price
Typically indicates price for the part if it is remanufactured or repaired. This can also be used for price stream values by mapping a price stream to this field.
Current Revenue
Current revenue amount for the selected SKU.
Current Price * Current Volume, aggregated for all the price streams
Current Standard Cost
The current standard cost for the part at the location.
Current Supplier Cost
Typically indicates supplier cost for the part.
Current Volume
Current volume is the sum of volumes for the last 12 months, averaged over the period of the promotion.
Total Number of Days = (1st of the current month in present year - 1st of the current month in previous year)
Volume Multiplier = (Promotion End Date – Promotion Effective Date) / Total Number of Days
Current Volume = (Sum(HistoryAmount) for Total Number of Days) * Volume Multiplier
History amount used in the above calculations is the sum of all the history amount for the last 12 months.
Current Volume Cost
Typically indicates cost for the part if it is purchased in a quantity above a set limit.
Current Volume Price
Typically indicates price for the part if it is purchased in a quantity above a set limit. This can also be used for price stream values by mapping a price stream to this field.
Custom Numeric (1-3)
Custom fields storing numeric values.
* 
These fields will be labeled with your organization's custom label - refer to your Integration Guide for more information.
Custom String (1-5)
Custom fields storing string values.
* 
These fields will be labeled with your organization's custom label - refer to your Integration Guide for more information.
Effective Custom Cost (1-5)
Effective custom cost for the selected SKU as of the promotion effective date.
Effective Custom Price (1-20)
Effective custom price for the selected SKU as of the promotion effective date.
Effective Damaged Cost
Effective damaged cost for the selected SKU as of the promotion effective date.
Effective Damaged Price
Effective damaged price for the selected SKU as of the promotion effective date.
Effective Expedite Cost
Effective expedite cost for the selected SKU as of the promotion effective date.
Effective Expedite Price
Effective expedite price for the selected SKU as of the promotion effective date.
Effective Margin Change
The difference in the New Margin and the effective margin.
Effective Margin Change %
The percentage difference in the New Margin and the effective margin.
Effective Margin %
The Margin value as of the new price effective date.
(Effective Price – Effective Cost/Effective Price)*100
Effective Profit
Effective profit amount for the selected SKU.
(Effective Price - Effective Cost) * Current Volume
Effective Profit Change
The difference in the New Profit value and the effective profit value.
Effective Profit Change %
The percentage difference in the New Profit and the effective profit value.
Effective Refurbished Cost
Effective expedite price for the selected SKU as of the promotion effective date.
Effective Refurbished Price
Effective refurbished price for the selected SKU as of the promotion effective date.
Effective Revenue
Effective revenue amount for the selected SKU.
Effective Price x Current Volume, aggregated for all the price streams
Effective Revenue Change
The difference in the New Revenue value and the effective revenue value.
Effective Revenue Change %
The percentage difference in the New Revenue value and the effective revenue value.
Effective Standard Cost
The Standard Cost value as of the promotion effective date.
Effective Standard Price
The Standard Price value as of the promotion effective date.
Effective Supplier Cost
Effective supplier cost for the selected SKU as of the promotion effective date.
Effective Volume
The target volume for the selected SKU.
Effective Volume Cost
The effective volume cost for the selected SKU as of the promotion effective date.
Effective Volume Price
ffective volume Price for the selected SKU as of the promotion effective date
Last Approval Event
The most recent approval event that has occurred.
Last Updated By
The ID of the planner that last updated the record.
Last Updated By Date Time
The date and time the record was last updated.
Location
The name of the location.
New Custom Price (1-20)
Price stream value fields for the SKU.
New Damaged Price
The new damaged price for the selected SKU.
New Expedite Price
The new expedite price for the selected SKU.
New Margin %
New Margin % for the selected SKU.
((New Standard Price - Effective Standard Cost) / New Standard Price) * 100
New Price Override By
The ID of the planner that entered the new price override.
New Price Override Date
The date of the last new price override.
New Profit
New profit amount for the selected SKU.
New Profit = (New Price - Effective Cost) * New Volume
New Refurbished Price
The new refurbished price for the selected SKU.
New Revenue
New revenue amount for the selected SKU.
New Price * New Volume, aggregated for all price streams
New Standard Price
The new recommended standard price for the selected SKU.
New Volume
The target volume for the selected SKU.
New Volume Price
The new recommended volume price of the part.
Part Name
The name of the part.
Part Number
The number of the part.
Promotion Effective Date
The date at which the promotion is effective.
Promotion End Date
The date at which the promotion ends.
Promotion Name
The name assigned to the promotion.
Recommended New Price
Recommended new price for the part at the location as suggested by the promotion.
Target Custom Price (1–20)
The target custom price.
Target Damaged Price
The target price if the part is damaged.
Target Expedite Price
The target price if the part is expedited.
Target Margin
(Target Profit / Target Revenue) * 100
Target Margin Difference
Projected Margin - Target Margin
Target Margin Progress %
(Projected Margin / Target Margin) * 100
Target Profit
(Target Price – Effective Cost) * New Volume
Target Profit Difference
Projected Profit - Target Profit
Target Profit Progress %
(Projected Profit / Target Profit) * 100
Target Refurbished Price
The target price if the part is refurbished.
Target Revenue
Target Price * New Volume
Target Revenue Difference
Projected Revenue - Target Revenue
Target Revenue Progress %
Projected Revenue - Target Revenue
Target Standard Price
The target price for just the standard part.
Target Volume
The total forecasted volume at the promotional price in the promotion time range.
Target Volume Price
The target price if the part is sold by volume.
Workflow
The special price approval workflow in which the SKU is being processed.
Was this helpful?