OKC_PRICING_TERMS
Base table for storing pricing terms for parent entities such as Sales Agreements, Promotions or Discount Lists.
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
OKC_PRICING_TERMS_PK |
PRICING_TERM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRICING_TERM_ID | NUMBER | 18 | Yes | PRICING_TERM_ID | |
| PRICING_TERM_PUID | VARCHAR2 | 120 | PRICING_TERM_PUID | ||
| DNZ_CHR_ID | NUMBER | 18 | Yes | DNZ_CHR_ID | |
| CLE_ID | NUMBER | 18 | CLE_ID | ||
| MAJOR_VERSION | NUMBER | 18 | Yes | MAJOR_VERSION | |
| VERSION_TYPE | VARCHAR2 | 1 | Yes | VERSION_TYPE | |
| PRICE_TYPE_CODE | VARCHAR2 | 30 | Indicates if the price adjustment is of price types one time,recurring,usuage or ALL. Based on the lookup type QP_PRICE_TYPES. | ||
| PRICE_PERIODICITY_CODE | VARCHAR2 | 3 | Relevant when price type is Recurring. Mutually exclusive with Usage UOM. E.g. Possible values are Monthly (MONTHLY), Weekly (WEEKLY), yearly (YEARLY), etc. | ||
| ADJUSTMENT_TYPE_CODE | VARCHAR2 | 30 | e.g. %Discount, %Markup, etc. Based on a lookup type OKC_SAGR_ADJ_TYPES | ||
| ADJUSTMENT_AMOUNT | NUMBER | Adjustment numeric value associated with the Adjustment Type. | |||
| ADJUSTMENT_BASIS_CODE | VARCHAR2 | 30 | Indicates the basis for calculating a % based adjustment.When adjustment is at line level, Benefit Type is Coverage Price Adjustment, Price Adjustment or Price List Based Adjustment and Adjustment Type is Discount % or Markup %, the list of values for this field are Pricing Basis (setup separately as named entities) of type Adjustment Basis. The Pricing Basis of type Adjustment Basis will only have a single price element associated. Price Type, Charge Type, Subtype for calculation purposes are to be same as price type, charge type, subtype to which the term is applied.When adjustment is at line level, Benefit Type is Coverage Price Adjustment and Adjustment Type is Covered Product Percent Price (applicable only when the item on the pricing term is a coverage/warranty item) then the list of values are Pricing Basis of type Coverage Basis. The Pricing Basis of type Coverage Basis will have one or more combinations of price element, price type, charge type and charge subtype associated. | ||
| LIST_PRICE | NUMBER | LIST_PRICE | |||
| FLOOR_PRICE | NUMBER | FLOOR_PRICE | |||
| PERIOD_NAME | VARCHAR2 | 30 | PERIOD_NAME | ||
| ALLOW_CUSTOM_ADJUSTMENTS_FLAG | VARCHAR2 | 1 | Yes | For use by QOC/Contracts to prevent manual adjustments to the adjustment. Possible values are Y or N. Based lookup type YES_NO. | |
| START_DATE | DATE | Start date for the Term.This date does not contribute to uniqueness of Terms just date enablement. | |||
| END_DATE | DATE | End date for the Term.This date does not contribute to uniqueness of Terms just date enablement. | |||
| ORIG_SYSTEM_ID | NUMBER | 18 | Pricing Term Id of source when this pricing term is copied from another pricing term. | ||
| TIERED_YN | VARCHAR2 | 1 | Yes | TIERED_YN | |
| TIER_BASIS_TYPE_CODE | VARCHAR2 | 30 | TIER_BASIS_TYPE_CODE | ||
| TIER_BASIS_CODE | VARCHAR2 | 30 | TIER_BASIS_CODE | ||
| AGGREGATION_METHOD_CODE | VARCHAR2 | 30 | AGGREGATION_METHOD_CODE | ||
| GRADUATED_CODE | VARCHAR2 | 30 | GRADUATED_CODE | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated 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. | ||
| 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. | ||
| 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. | |
| EXTERNAL_KEY1 | VARCHAR2 | 120 | External key that uniquely identifies a record | ||
| EXTERNAL_KEY2 | VARCHAR2 | 120 | Additional attribute to qualify external key |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| OKC_PRICING_TERMS | okc_k_headers_all_b | DNZ_CHR_ID, MAJOR_VERSION |
| OKC_PRICING_TERMS | okc_k_lines_b | CLE_ID, MAJOR_VERSION |
| okc_tier_lines | okc_pricing_terms | PRICING_TERM_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_PRICING_TERMS_N1 | Non Unique | FUSION_TS_TX_IDX | DNZ_CHR_ID, CLE_ID, MAJOR_VERSION |
| OKC_PRICING_TERMS_PK | Unique | FUSION_TS_TX_IDX | PRICING_TERM_ID |
| OKC_PRICING_TERMS_U1 | Unique | Default | EXTERNAL_KEY1, EXTERNAL_KEY2 |
| OKC_PRICING_TERMS_U2 | Unique | Default | PRICING_TERM_PUID |