This appendix covers the following topics:
Oracle Advanced Pricing provides the following seeded formulas that you can use when setting up freight charges:
Cost-to-charge conversion formulas (simple pass-through formulas)
Cost-to-charge markup formulas (simple markup formulas)
Each seeded formula consists of a formula expression, which contains the steps that define how to calculate the freight charges. Rather than create a new formula and expression, you can select an existing seeded formula when setting up freight charges. For example, you could select the QP: Cost to charge conversion of Administration Cost formula to convert the Administration Cost pricing attribute to a charge.
Alternatively, you can update the formula header or formula lines for an existing seeded formula.
You can review the available seeded and non-seeded formulas in the Advanced Pricing - Pricing Formulas window. The Seeded check box indicates if the formula is seeded or not.
Note: If the name of a seeded formula is updated then the formula will no longer be identified as seeded.
The following tables list details about the seeded cost to charge conversion (pass-through) formulas:
1) QP: Cost to charge conversion of Administration Cost
Description: Formula to convert Administration Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1 | Header |
| Formula Type | Pricing Attribute | Line |
| Pricing Attribute Context | Pricing Attribute | Line |
| Pricing Attribute | Administration Cost | Line |
| Step | 1 | Line |
2) QP: Cost to charge conversion of Duty Cost
Description: Formula to convert Duty Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1 | Header |
| Formula Type | Pricing Attribute | Line |
| Pricing Attribute Context | Pricing Attribute | Line |
| Pricing Attribute | Duty Cost | Line |
| Step | 1 | Line |
3) QP: Cost to charge conversion of Export Cost
Description: Formula to convert Export Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1 | Header |
| Formula Type | Pricing Attribute | Line |
| Pricing Attribute Context | Pricing Attribute | Line |
| Pricing Attribute | Export Cost | Line |
| Step | 1 | Line |
4) QP: Cost to charge conversion of Freight Cost
Description: Formula to convert Freight Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1 | Header |
| Formula Type | Pricing Attribute | Line |
| Pricing Attribute Context | Pricing Attribute | Line |
| Pricing Attribute | Freight Cost | Line |
| Step | 1 | Line |
5) QP: Cost to charge conversion of Handling Cost
Description: Formula to convert Handling Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1 | Header |
| Formula Type | Pricing Attribute | Line |
| Pricing Attribute Context | Pricing Attribute | Line |
| Pricing Attribute | Handling Cost | Line |
| Step | 1 | Line |
6) QP: Cost to charge conversion of Insurance Cost
Description: Formula to convert Insurance Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1 | Header |
| Formula Type | Pricing Attribute | Line |
| Pricing Attribute Context | Pricing Attribute | Line |
| Pricing Attribute | Insurance Cost | Line |
| Step | 1 | Line |
7) QP: Cost to charge conversion of Transportation Price
Description: Formula to convert Transportation Price to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1 | Header |
| Formula Type | Pricing Attribute | Line |
| Pricing Attribute Context | Pricing Attribute | Line |
| Pricing Attribute | Transportation Price | Line |
| Step | 1 | Line |
8) QP: Cost to charge conversion of Transportation Charge
Description: Formula to convert Transportation Charge to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1 | Header |
| Formula Type | Pricing Attribute | Line |
| Pricing Attribute Context | Pricing Attribute | Line |
| Pricing Attribute | Transportation Charge | Line |
| Step | 1 | Line |
The following tables describe the names and setup details for the seeded cost-to-charge with markup formulas:
1) QP: Cost to charge markup of Administration Cost
Description: Formula to convert Administration Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1*2 | Header |
| Formula Type | Pricing Attribute | Line 1 |
| Pricing Attribute Context | Pricing Attribute | Line 1 |
| Pricing Attribute | Administration Cost | Line 1 |
| Step | 1 | Line 1 |
| Formula Type | Numeric Constant | Line 2 |
| Component | 1 | Line 2 |
| Step | 2 | Line 2 |
2) QP: Cost to charge markup of Duty Cost
Description: Formula to convert Duty Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1*2 | Header |
| Formula Type | Pricing Attribute | Line 1 |
| Pricing Attribute Context | Pricing Attribute | Line 1 |
| Pricing Attribute | Duty Cost | Line 1 |
| Step | 1 | Line 1 |
| Formula Type | Numeric Constant | Line 2 |
| Component | 1 | Line 2 |
| Step | 2 | Line 2 |
3) QP: Cost to charge markup of Export Cost
Description: Formula to convert Export Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1*2 | Header |
| Formula Type | Pricing Attribute | Line 1 |
| Pricing Attribute Context | Pricing Attribute | Line 1 |
| Pricing Attribute | Export Cost | Line 1 |
| Step | 1 | Line 1 |
| Formula Type | Numeric Constant | Line 2 |
| Component | 1 | Line 2 |
| Step | 2 | Line 2 |
4) QP: Cost to charge markup of Freight Cost
Description: Formula to convert Freight Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1*2 | Header |
| Formula Type | Pricing Attribute | Line 1 |
| Pricing Attribute Context | Pricing Attribute | Line 1 |
| Pricing Attribute | Freight Cost | Line 1 |
| Step | 1 | Line 1 |
| Formula Type | Numeric Constant | Line 2 |
| Component | 1 | Line 2 |
| Step | 2 | Line 2 |
5) QP: Cost to charge markup of Handling Cost
Description: Formula to convert Handling Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1*2 | Header |
| Formula Type | Pricing Attribute | Line 1 |
| Pricing Attribute Context | Pricing Attribute | Line 1 |
| Pricing Attribute | Handling Cost | Line 1 |
| Step | 1 | Line 1 |
| Formula Type | Numeric Constant | Line 2 |
| Component | 1 | Line 2 |
| Step | 2 | Line 2 |
6) QP: Cost to charge markup of Insurance Cost
Description: Formula to convert Insurance Cost to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1*2 | Header |
| Formula Type | Pricing Attribute | Line 1 |
| Pricing Attribute Context | Pricing Attribute | Line 1 |
| Pricing Attribute | Insurance Cost | Line 1 |
| Step | 1 | Line 1 |
| Formula Type | Numeric Constant | Line 2 |
| Component | 1 | Line 2 |
| Step | 2 | Line 2 |
7) QP: Cost to charge markup of Transportation Price
Description: Formula to convert Transportation Price to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1*2 | Header |
| Formula Type | Pricing Attribute | Line 1 |
| Pricing Attribute Context | Pricing Attribute | Line 1 |
| Pricing Attribute | Transportation Price | Line 1 |
| Step | 1 | Line 1 |
| Formula Type | Numeric Constant | Line 2 |
| Component | 1 | Line 2 |
| Step | 2 | Line 2 |
8) QP: Cost to charge markup of Transportation Charge
Description: Formula to convert Transportation Charge to charge.
| Field Name | Value | Field Level |
|---|---|---|
| Formula | 1*2 | Header |
| Formula Type | Pricing Attribute | Line 1 |
| Pricing Attribute Context | Pricing Attribute | Line 1 |
| Pricing Attribute | Transportation Charge | Line 1 |
| Step | 1 | Line 1 |
| Formula Type | Numeric Constant | Line 2 |
| Component | 1 | Line 2 |
| Step | 2 | Line 2 |