马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ： 83569622 。
您需要 登录 才可以下载或查看，没有帐号？注册
x
Overview of Seeded Formulas 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. Seeded Cost-to-Charge Conversion Formulas 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 |
Seeded Markup Formulas 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 |
| 
|Archiver|小黑屋|手机版|壹佰网 ERP100
( 京ICP备19053597号-2 )
IP卡
狗仔卡
发表于 2011/9/29 05:35:29
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
抢沙发
千斤顶
显身卡
发表于 2013/5/15 17:31:39