FOS_PRICING_OPTION_F
This table stores the details of the pricing options used to determine the accounting transfer price, seller's assessable value, and buyer's assessable value.
Details
-
Schema: FUSION
-
Object owner: FOS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FOS_PRICING_OPTION_PK |
PRICING_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRICING_ID | NUMBER | 18 | Yes | This is the primary key and its value is an application generated unique id. | |
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| PRICING_OPTION_NAME | VARCHAR2 | 100 | Yes | The unique name given to a pricing option. | |
| PRICING_OPTION_DESC | VARCHAR2 | 200 | A brief description of the pricing option. | ||
| TP_PRICING_BASIS_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if the pricing strategy checkbox is checked and price list is chosen as basis to calculate transfer price in the Accounting Transfer Price tab. Its default value is 'N'. | |
| TP_TXN_COST_BASIS_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if the transaction cost basis checkbox is checked and cost is chosen as basis to calculate transfer price in Accounting Transfer Price tab. Its default value is 'N'. | |
| TP_DOC_PRICE_BASIS_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if the transaction source document price basis checkbox is checked and source document is chosen as basis to calculate transfer price in in Accounting Transfer Price tab. Its default value is 'N'. | |
| TP_OPTIONS_CRITERIA | VARCHAR2 | 1 | Yes | Stores 'N' if user does not select more than one strategy to calculate transfer price in Accounting Transfer Price tab. It is assigned 'H' or 'L' for Use Highest Price, Use Lowest Price radio buttons respectively. | |
| TP_USE_SOPRICE_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if sales order is used as basis to calculate transfer price in Accounting Transfer Price tab. Its default value is 'N'. | |
| TP_DOC_PRICE_TERM_ID | NUMBER | 18 | Stores the id of the user selected price term to identify the markup on source document price in Accounting Transfer Price tab. | ||
| TP_DOC_MARKUP_TYPE | VARCHAR2 | 30 | Stores the markup type selected by the user on source document price in the Accounting Transfer Price tab. | ||
| TP_DOC_MARKUP_VALUE | NUMBER | Stores the standard markup value on source document price if 'Standard Markup' is chosen as markup type in the Accounting Transfer Price tab. | |||
| TP_COST_MARKUP_TYPE | VARCHAR2 | 30 | Stores the markup type selected by the user on transaction cost in the Accounting Transfer Price tab. | ||
| TP_COST_MARKUP_VALUE | NUMBER | Stores the standard mark up value on transaction cost if 'Standard Markup' is chosen as markup type in the Accounting Transfer Price tab. | |||
| TP_COST_PRICE_TERM_ID | NUMBER | 18 | Stores the id of the price term selected by the user to identify markup on transaction cost in the Accounting Transfer Price tab. | ||
| BUYERS_VALUE_OPTION | VARCHAR2 | 1 | Yes | Stores 'A','S', or 'N' for 'Use Accounting Transfer Price', 'Use Seller's Assessable Value', 'Define New Price Rules' respectively. | |
| SELLERS_VALUE_OPTION | VARCHAR2 | 1 | Yes | Stores 'A' or 'N' for 'Use Accounting Transfer Price', 'Define New Price Rules' respectively. | |
| SELL_PRICING_BASIS_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if the pricing strategy checkbox is checked and price list is chosen as basis to calculate transfer price in in Seller's Assessable Value tab. Its default value is 'N'. | |
| SELL_TXN_COST_BASIS_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if the transaction cost basis checkbox is checked and cost is chosen as basis to calculate transfer price in Seller's Assessable Value tab. Its default value is 'N'. | |
| SELL_DOC_PRICE_BASIS_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if the transaction source document price basis checkbox is checked and source document is chosen as basis to calculate transfer price in in Seller's Assessable Value tab. Its default value is 'N'. | |
| SELL_OPTIONS_CRITERIA | VARCHAR2 | 1 | Yes | Stores 'N' if user does not select more than one strategy to calculate transfer price in Seller's Assessable Value tab. It is assigned 'H' or 'L' for Use Highest Price, Use Lowest Price radio buttons respectively. | |
| SELL_USE_SOPRICE_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if sales order is used as basis to calculate transfer price in Seller's Assessable Value tab. Its default value is 'N'. | |
| SELL_DOC_PRICE_TERM_ID | NUMBER | 18 | Stores the id of the user selected price term to identify the markup on source document price in Seller's Assessable Value tab. | ||
| SELL_DOC_MARKUP_TYPE | VARCHAR2 | 30 | Stores the markup type selected by the user on source document price in the Seller's Assessable Value tab. | ||
| SELL_DOC_MARKUP_VALUE | NUMBER | Stores the standard markup value on source document price if 'Standard Markup' is chosen as markup type in the Sellers Assessable Value tab. | |||
| SELL_COST_MARKUP_TYPE | VARCHAR2 | 30 | Stores the markup type selected by the user on transaction cost in the Seller's Assessable Value tab. | ||
| SELL_COST_MARKUP_VALUE | NUMBER | Stores the standard mark up value on transaction cost if 'Standard Markup' is chosen as the markup type in the Seller's Assessable Value tab. | |||
| SELL_COST_PRICE_TERM_ID | NUMBER | 18 | Stores the id of the price term selected by the user to identify the markup on transaction cost in the Seller's Assessable Value tab. | ||
| BUY_PRICING_BASIS_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if the pricing strategy checkbox is checked and price list is chosen as basis to calculate transfer price in in Buyer's Assessable Value tab. Its default value is 'N'. | |
| BUY_TXN_COST_BASIS_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if the transaction cost basis checkbox is checked and cost is chosen as basis to calculate transfer price in Buyer's Assessable Value tab. Its default value is 'N'. | |
| BUY_DOC_PRICE_BASIS_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if the transaction source document price basis checkbox is checked and source document is chosen as basis to calculate transfer price in in Buyer's Assessable Value tab. Its default value is 'N'. | |
| BUY_OPTIONS_CRITERIA | VARCHAR2 | 1 | Yes | Stores 'N' if user does not select more than one strategy to calculate transfer price in Buyer's Assessable Value tab. It is assigned 'H' or 'L' for Use Highest Price, Use Lowest Price radio buttons respectively. | |
| BUY_USE_SOPRICE_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if sales order is used as basis to calculate transfer price in Buyer's Assessable Value tab. Its default value is 'N'. | |
| BUY_DOC_PRICE_TERM_ID | NUMBER | 18 | Stores the id of the user selected price term to identify the markup on source document price in the Buyer's Assessable Value tab. | ||
| BUY_DOC_MARKUP_TYPE | VARCHAR2 | 30 | Stores the markup type selected by the user on source document price in the Buyer's Assessable Value tab. | ||
| BUY_DOC_MARKUP_VALUE | NUMBER | Stores the standard markup value on source document price if 'Standard Markup' is chosen as the markup type in the Buyers Assessable Value tab. | |||
| BUY_COST_MARKUP_TYPE | VARCHAR2 | 30 | Stores the markup type selected by the user on transaction cost in the Buyer's Assessable Value tab. | ||
| BUY_COST_MARKUP_VALUE | NUMBER | Stores the standard mark up value on transaction cost if 'Standard Markup' is chosen as the markup type in the Buyer's Assessable Value tab. | |||
| BUY_COST_PRICE_TERM_ID | NUMBER | 18 | Stores the id of the price term selected by the user to identify the markup on transaction cost in the Buyer's Assessable Value tab. | ||
| ENTERPRISE_ID | NUMBER | 18 | Yes | Identifier of Enterprise, used for multi-tenancy partitioning. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| TP_ITEM_COST_BASIS_FLAG | VARCHAR2 | 1 | Yes | Stores 'Y' if the item cost basis radio button is selected and item cost is chosen as basis to calculate transfer price. Its default value is 'N'. | |
| TP_ITEM_COST_MARKUP_VALUE | NUMBER | Stores the mark up value on item cost. | |||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FOS_PRICING_OPTION_PK | Unique | Default | PRICING_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ORA_SEED_SET1 |
| FOS_PRICING_OPTION_PK1 | Unique | Default | PRICING_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ORA_SEED_SET2 |
| FOS_PRICING_OPTION_UK1 | Unique | Default | PRICING_OPTION_NAME, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ORA_SEED_SET1 |
| FOS_PRICING_OPTION_UK11 | Unique | Default | PRICING_OPTION_NAME, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ORA_SEED_SET2 |