QP_PRICING_GUIDELINE_ITEMS
The table QP_PRICING_GUIDELINE_ITEMS is to store the item and charge details for the charge guideline. It also stores the reference matrix key for complex guidelines.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_PRICING_GUIDELINE_ITEMS_PK |
PRICING_GUIDELINE_ITEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRICING_GUIDELINE_ITEM_ID | NUMBER | 18 | Yes | Primary Key of the table and it???s a system generated unique number. | |
| PRICING_GUIDE_COMPONENT_ID | NUMBER | 18 | Yes | Foreign Key of the parent table and it???s a system generated unique number. | |
| PRICING_GUIDELINE_ID | NUMBER | 18 | Yes | Foreign Key of the grandparent table and it???s a system generated unique number. | |
| LINE_NUMBER | NUMBER | 9 | LineNumber is unique number starting with 1 within a given parent (e.g. Pricing Guideline). Combination of Pricing Guideline Id and LineNumber is unique. | ||
| ITEM_LEVEL_CODE | VARCHAR2 | 30 | Yes | Contains values: All Items, Item Category, Product Group, and Item Based on lookup type QP_ITEM_LEVELS. | |
| ITEM_ID | NUMBER | 18 | Items will be choicelist lookup to PIM Item table Item Name. Stores the covered product when Coverage Guideline Flag = Y. Stores the Goods or Coverage Service product when the Coverage Guideline Flag = N | ||
| PRICING_UOM_CODE | VARCHAR2 | 3 | Yes | LOV for item???s UOM. Based on PIM entities. The value ???ALL??? should also be available and merged list of values. The value ???ALL??? should appear first in the list. | |
| PRICE_TYPE_CODE | VARCHAR2 | 30 | Yes | Any, One Time, Recurring, or Usage ??? dependent on what is defined in PIM for the item, only those values defined will be available. The value ???Any??? should also be available and merged with the FND Lookup. The value ???Any??? should appear first in the list. | |
| CHARGE_TYPE_CODE | VARCHAR2 | 30 | Yes | Contains all Active and Setup Enabled Charge Types. The value ???Any??? should also be available and merged with the Choicelist Lookup. The value ???Any??? should appear first in the list. | |
| CHARGE_SUBTYPE_CODE | VARCHAR2 | 30 | Yes | Contains all Active and Setup Enabled Charge Subtypes for a given Charge Type. The value ???Any??? should also be available and merged with the Choicelist Lookup. The value ???Any??? should appear first in the list. | |
| USAGE_UOM_CODE | VARCHAR2 | 3 | If price type = Usage, a LOV for the UOM from those defined in PIM for the item. The value ???Any??? should also be available and merged with the FND Lookup. The value ???Any??? should appear first in the list. | ||
| PRICE_PERIODICITY_CODE | VARCHAR2 | 3 | For a recurring or usage price type, a LOV for the UOM from those defined in PIM for the item. The value ???Any??? should also be available and merged with the FND Lookup. The value ???Any??? should appear first in the list. | ||
| LINE_TYPE_CODE | VARCHAR2 | 30 | Yes | LOV from QOC, contains (Buy, Upgrade, etc, Any). The value ???Any??? should also be available and merged with the FND Lookup. The value ???Any??? should appear first in the list. | |
| SERVICE_DURATION | NUMBER | Mutually exclusive with attribute All Coverage Durations Flag. The length of time for an item with a property ???Service Enabled??? in PIM such as a Warranty | |||
| SERVICE_DURATION_PERIOD_CODE | VARCHAR2 | 3 | UOM for the Duration, e.g. Month, Year. Obtained from PIM. The value ???Any??? should also be available and merged with the FND Lookup. The value ???Any??? should appear first in the list. | ||
| ALL_SERVICE_DURATIONS_FLAG | VARCHAR2 | 30 | Mutually exclusive with attribute Coverage Duration. Values contain Y, N. Based on lookup type YES_NO | ||
| APPLY_TO_ROLLUP_FLAG | VARCHAR2 | 30 | Indicates whether the charge guideline rule is defined for a Configuration Root Model. Valid values are ???Y???, ???N??? and null. Defaults to (???N???) for new records. | ||
| APPLIES_TO_CODE | VARCHAR2 | 30 | Yes | APPLIES_TO_CODE sets the applies-to type for pricing charge definition. Will map to FND Lookup: QP_CHARGE_DEF_APPLY_TO | |
| GUIDELINE_MATRIX_ID | NUMBER | 18 | Stores FK to the Pricing Matrix record | ||
| GUIDELINE_VIOLATION_TYPE_CODE | VARCHAR2 | 30 | Exception Type of the Charge Guideline. Based on lookup type QP_GUIDE_EXCEPTION_TYPES. At run time, this value overrides parent???s (Pricing Guideline???s) value if defined. If null, parent???s value prevails. | ||
| 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. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| QP_PRICING_GUIDELINE_ITEMS | qp_pricing_guide_components | PRICING_GUIDE_COMPONENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_PRICING_GUIDELINE_ITEMS_FK1 | Non Unique | FUSION_TS_TX_IDX | PRICING_GUIDE_COMPONENT_ID |
| QP_PRICING_GUIDELINE_ITEMS_N1 | Non Unique | FUSION_TS_TX_IDX | PRICING_GUIDELINE_ID |
| QP_PRICING_GUIDELINE_ITEMS_N2 | Non Unique | FUSION_TS_TX_IDX | GUIDELINE_MATRIX_ID |
| QP_PRICING_GUIDELINE_ITEMS_PK | Unique | FUSION_TS_TX_IDX | PRICING_GUIDELINE_ITEM_ID |