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.
|
||
Custom String (1-5)
|
Custom fields storing string values.
|
||
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.
|