|
Field
|
Description
|
|---|---|
|
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 Price Change
|
The change in standard part price.
New Standard Price - Current Standard Price
|
|
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
|
|
Current Custom Cost (1–5)
|
Custom fields for cost derived from the IPCS_COST table.
Represents the current costs for the part.
|
|
Current Custom Price (1–20)
|
Current custom price fields.
|
|
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 %
|
((Current Standard Price - Current Standard Cost) / Current Standard Price) * 100
|
|
Current Profit
|
The current profit amount for the selected SKU.
(Current Price - Current Cost) * Current Volume
|
|
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
|
The current revenue amount for the selected SKU.
Current Price x Current Volume
|
|
Current Standard Price
|
The current standard price for the SKU.
|
|
Current Revenue
|
Current Standard Price * Current Volume
|
|
Current Standard Cost
|
The current standard cost for the SKU.
|
|
Current Standard Price
|
The current standard price for the SKU.
|
|
Current Supplier Cost
|
Typically indicates supplier cost for the SKU.
|
|
Current Volume
|
Current volume is the sum of volumes for the last 12 months, averaged over the period of the promotion.
Current Volume = (Sum(HistoryAmount) for Total Number of Days) * Volume Multiplier
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
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 alphanumeric values.
|
|
Effective Custom Cost (1–5)
|
The Custom Cost value as of the promotion effective date.
|
|
Effective Custom Price (1–20)
|
The Custom Price value as of the promotion effective date.
|
|
Effective Damaged Cost
|
The Damaged Cost value as of the promotion effective date.
|
|
Effective Damaged Price
|
The Damaged Price value as of the promotion effective date.
|
|
Effective Expedite Cost
|
The Expedite Cost value as of the promotion effective date.
|
|
Effective Expedite Price
|
The Expedite Price value as of the promotion effective date.
|
|
Effective Margin Change
|
New Margin - Effective Margin
|
|
Effective Margin Change %
|
[(New Margin - Effective Margin) / Effective Margin] * 100
|
|
Effective Margin %
|
((Effective Price – Effective Cost) / Effective Price) * 100
|
|
Effective Profit
|
((Effective Price - Effective Cost) * Current Volume)
|
|
Effective Profit Change
|
New Profit – Effective Profit
|
|
Effective Profit Change %
|
[(New Profit - Effective Profit) / Effective Profit] * 100
|
|
Effective Refurbished Cost
|
Effective refurbished cost 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 Price * Current Volume
|
|
Effective Revenue Change
|
New Revenue - Effective Revenue
|
|
Effective Revenue Change %
|
[(New Revenue - Effective Revenue) / Effective Revenue] * 100
|
|
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
|
Effective volume cost for the selected SKU as of promotion effective date.
|
|
Effective Volume Price
|
Effective volume Price for the selected SKU as of promotion effective date.
|
|
Location Name
|
The name of the location for the SKU.
|
|
New Custom Price (1–20)
|
The price stream value fields for the SKU. To change a field value, enter the new price in the box and click Save. Once the price is approved for uploading, this value is changed on the host system.
|
|
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 Price – Effective Cost) * New Volume
|
|
New Price Override By
|
The name of the user that created an override for the new price.
|
|
New Price Override Date
|
The date that the new price was overridden.
|
|
New Profit
|
New profit amount for the selected SKU.
(New Price - Effective Cost) * New Volume
|
|
New Refurbished Price
|
The new refurbished price for the selected SKU.
|
|
New Revenue
|
New Price * New Volume
|
|
New Standard Price
|
The new standard price that would result from this promotion policy. This field can be modified. Enter a value if you want to override the New Standard Price for a record before applying the simulation results.
|
|
New Volume
|
The target volume for the selected SKU.
|
|
New Volume Price
|
The new recommended volume price for the selected SKU.
|
|
Part Name
|
The name of the part for the SKU.
|
|
Part Number
|
The number of the part for the SKU.
|
|
Promotion Effective Date
|
The date that the promotion is effective.
|
|
Promotion End Date
|
The date that the promotion ends.
|
|
Promotion Name
|
The promotion to be used by the policy. Note that selecting a promotion automatically includes all pairs assigned to the promotion to the promotion policy.
|
|
Recommended New Price
|
The recommended price as calculated using the promotion policy.
|
|
Results Applied By
|
If the promotion policy results have been applied, this field displays the name of the user that performed the action.
|
|
Results Applied Date
|
If the promotion policy results have been applied, this field displays the date/time that they were applied.
|
|
Target Custom Price (1–20)
|
The targeted custom price value as of the promotion effective date.
|
|
Target Damaged Price
|
The targeted Damaged Price value as of the promotion effective date
|
|
Target Expedite Price
|
The targeted Damaged Price value as of the promotion effective date.
|
|
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 promotional 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) * 100
|
|
Target Standard Price
|
The target promotional price for the SKU.
|