Skip Headers

Oracle Order Management User's Guide
Release 12.1
Part Number E13408-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Seeded Formulas

This appendix covers the following topics:

Overview of Seeded Formulas

Pricing provides two types of seeded formulas that you can use when setting up freight charges:

Each seeded formula is customized with its own formula expression. So 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.

Alternately, 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 Pricing Formulas window. The Seeded 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.

Seeded Cost to Charge Conversion Formulas

The following list describes the names and setup 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.

QP: Cost to charge conversion of Administration Cost
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.

QP: Cost to charge conversion of Duty Cost
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.

QP: Cost to charge conversion of Export Cost
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.

QP: Cost to charge conversion of Freight Cost
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.

QP: Cost to charge conversion of Handling Cost
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.

QP: Cost to charge conversion of Insurance Cost
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.

QP: Cost to charge conversion of Transportation Price
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.

QP: Cost to charge conversion of Transportation 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

Seeded Markup formulas

The following list describes the names and setup details about 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.

QP: Cost to charge markup of Administration Cost
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.

QP: Cost to charge markup of Duty Cost
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.

QP: Cost to charge markup of Export Cost
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.

QP: Cost to charge markup of Freight Cost
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.

QP: Cost to charge markup of Handling Cost
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.

QP: Cost to charge markup of Insurance Cost
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.

QP: Cost to charge markup of Transportation Price
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.

QP: Cost to charge markup of Transportation 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