QP_TIER_HEADERS
This table Stores the attributes of Tier Header.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_TIER_HEADERS_PK |
TIERED_PRICING_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TIERED_PRICING_HEADER_ID | NUMBER | 18 | Yes | Primary Key that Identifies a row in this table | |
| ACCRUAL_BASIS_ID | NUMBER | 18 | This points to the Pricing_Basis_Id in QP_PRICING_BASIS_VL where usage = Accrual Basis This is applied when Benefit Type is Accrual and Adjustment Type is percent based.Contains a list of pricing totals when level is header otherwise list of pricing elements when level is line | ||
| PARENT_ENTITY_TYPE_CODE | VARCHAR2 | 30 | Type of Parent Entity to which this Tiered Pricing is related. It may be PRICE_LIST_CHARGE or PRICING_TERM. | ||
| PARENT_ENTITY_ID | NUMBER | 18 | Id of the Entity to which the Tiered Pricing is related.It can be PRICE_LIST_LINE_ID or PRICING_TERM_ID | ||
| 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. | |
| BENEFIT_TYPE_CODE | VARCHAR2 | 30 | Denormalized from the parent. Mandatory for Pricing Term. When called from Price List Line,then the Benefit Type=Price Adjustment.When called from shipping line,then the Benefit Type will be Ship Adjustment,when called from Pricing Term,then the Benefit Type will be Accrual. | ||
| BENEFIT_SUBTYPE_CODE | VARCHAR2 | 30 | Denormalized from the parent.When Benefit Type is Shipping Adjustment, Subtype may be one of Duty,Freight Handling or Insurance. Based on Lookup_type : QP_SHIPPING_CHARGE_TYPE | ||
| ITEM_LEVEL_CODE | VARCHAR2 | 30 | Denormalized from Parent entity. The values are PRODUCT GROUP , ITEM CATEGORY or ITEM | ||
| ITEM_ID | NUMBER | 18 | Denormalized from parent Entity. This will be used to generate Tiered Pricing Name. | ||
| PRICING_UOM_CODE | VARCHAR2 | 3 | Denormalized from the parent entity. Line UOM code. | ||
| LEVEL_CODE | VARCHAR2 | 30 | Denormalized from the parent entity. Indicates Header or Line level.Price List will pass in LINE.Pricing term will pass in LINE/HEADER | ||
| AGGREGATION_METHOD_CODE | VARCHAR2 | 30 | Yes | Accumulation will evaluate the volume for Tiers. When LEVEL is LINE, values include On Line,On Document,Over Time Duration of Agreement,Over Time Specific Duration,or Over Time Recurring Interval,when LEVEL is ORDER Values include On Document,Over Time Duration of Agreement,Over Time Specific Duration or Over Time Recurring Interval. The LOOKUP_TYPE IS : QP_AGGREGATION_METHOD_CODE . | |
| TIER_BASIS_TYPE_CODE | VARCHAR2 | 30 | It is the Volume Attribute of the Transaction for tier evaluation. This value will be used in the PDP for conditional steps in the Tiered Pricing Step. The LOOKUP_TYPE IS : QP_TIER_BASIS . | ||
| TIER_BASIS_ID | NUMBER | 18 | This points to the Pricing_Basis_Id in QP_PRICING_BASIS_VL where usage = Tier Basis or Accumulation Basis. Indicates across what charge or set of charges the tier basis will be evaluated against when the Tier Basis Type is Amount. Indicates across what charge or set of charges the basis will be used for accumulating the values across orders. | ||
| GRADUATED_CODE | VARCHAR2 | 30 | Graduated Flag Checked -> Graduated - Range Pricing , Unchecked - Simple Tiered Pricing | ||
| APPLICATION_METHOD_CODE | VARCHAR2 | 30 | Applicable when Tier Basis Type is Product Quantity Application Method Code - Values are Per Unit , Per Block This determines how the pricing is calculated. The LOOKUP_TYPE IS : QP_APPLICATION_METHOD_CODE | ||
| PERIOD_FROM_DATE_TYPE_CODE | VARCHAR2 | 30 | Orders to be taken for Tier evaluation based on Peroid From Date Type Code. The LOOKUP_TYPE IS : QP_PERIOD_FROM_DATE_TYPE_CODE . | ||
| PERIOD_FROM_DATE | TIMESTAMP | Period From Date is either Start Date or Pricing Date depending on the value of the Period_Date_Type_Code | |||
| AGGREGATION_DURATION | NUMBER | The number of units indicates the duration for the tier evaluation. | |||
| AGGR_DURATION_UOM_CODE | VARCHAR2 | 30 | This indicates the duration unit - for example Day , Month or Year. The LOOKUP_TYPE IS : QP_DURATION_UOM_CODE . | ||
| INCL_VALUE_ON_CURR_DOC_FLAG | VARCHAR2 | 30 | Applicable when aggregation method is Over time options.If checked -> To include the current order amount or quantity in the PDP | ||
| EXPLANATION_MESSAGE_ID | NUMBER | 18 | WATERFALL_MESSAGE_NAME for the Waterfall to indicate if Tiered Pricing apply to Lines.This Points to PRICING_MESSAGE_ID in QP_PRICING_MESSAGES_B | ||
| ADJUSTMENT_TYPE_CODE | VARCHAR2 | 30 | Indicates the type of Adjustment that is applied to the selling price- The LOOKUP_TYPE IS : QP_ADJUSTMENT_TYPE_CODE . | ||
| ADJUSTMENT_BASIS_ID | NUMBER | 18 | This points to the Pricing_Basis_Id in QP_PRICING_BASIS_VL where usage = Adjustment Basis If the value is entered, the value will be defaulted to the Adjustment Basis in Tiered Pricing Lines. This is only applicable when adjustment type is percent based adjustment. | ||
| PARTIAL_BLOCK_ACTION_CODE | VARCHAR2 | 30 | Applicable when Application Method is PER BLOCK.It indicates which block to be considered if increment value is entered. | ||
| AGGREGATION_PERIOD_CODE | VARCHAR2 | 30 | This indicates the accumulation period . For example Daily , Weekly, etc .The LOOKUP_TYPE IS : QP_AGGREGATION_INTERVAL_CODE | ||
| CURRENCY_CODE | VARCHAR2 | 15 | This indicates the currency when the adjustment type code is Price Override/markup amount/discount amount. | ||
| ENFORCE_ADJ_CALCULATION_FLAG | VARCHAR2 | 30 | This flag controls whether certain attributes on the TP line are editable or not. | ||
| ACCRUAL_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the accrual currency when Benefit Type is Accrual and Adjustment Type is Fix Amount. This is based on Lookup_Type : QP_ACCRUAL_CURRENCIES. | ||
| TIER_CONTEXT_CODE | VARCHAR2 | 30 | This attribute will include the following values passed from the parent entity: Item,Coverage,Accrual. The value of this attribute will be used to determine the list of values to be displayed for the adjustment type. | ||
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_TIER_HEADERS_U1 | Unique | FUSION_TS_TX_IDX | TIERED_PRICING_HEADER_ID |