QP_CHARGE_GUIDELINES
QP_CHARGE_GUIDELINES is to store Charge Types Guidelines
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_CHARGE_GUIDELINES_PK |
CHARGE_GUIDELINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHARGE_GUIDELINE_ID | NUMBER | 18 | Yes | Primary Key of the table, Mandatory | |
| PRICING_GUIDELINE_ID | NUMBER | 18 | Yes | Foreign Key to parent Pricing Guideline table | |
| LINE_NUMBER | NUMBER | 9 | Yes | LineNumber is unique number starting with 1 within a given parent (e.g. Pricing Guideline). Combination of Pricing Guideline Id and LineNumber is unique. | |
| CHARGE_GUIDELINE_TYPE_CODE | VARCHAR2 | 30 | Values will be: Item Charge, Coverage Association Charge and Component Item Charge | ||
| 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 | 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 | |||
| ALL_SERVICE_DURATIONS_FLAG | VARCHAR2 | 30 | Mutually exclusive with attribute Coverage Duration. Values contain Y, N. Based on lookup type YES_NO | ||
| 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. | ||
| GUIDELINE_RULE_TYPE_CODE | VARCHAR2 | 30 | Yes | Based on lookup type QP_GUIDE_RULE_TYPES. Indicates if rule is Simple or Complex (using Guideline Matrix) | |
| GUIDELINE_MATRIX_ID | NUMBER | 18 | Stores FK to the Pricing Matrix record | ||
| GUIDELINE_APPLY_TO_TYPE_CODE | VARCHAR2 | 30 | Type of party to whom guideline applies e.g. Role, Employee, Partner Org, etc. Based on lookup type QP_GUIDE_PARTY_TYPES | ||
| GUIDELINE_APPLY_TO_ID | NUMBER | 18 | Id of party to whom guideline applies | ||
| CONSTRAINING_VALUE | NUMBER | The value the Pricing Guideline constrains to. | |||
| SUGGESTED_VALUE | NUMBER | Suggested Value of Pricing Guideline | |||
| START_DATE | TIMESTAMP | Yes | User requested effective start date. | ||
| END_DATE | TIMESTAMP | User requested effective end date. | |||
| 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. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| QP_CHARGE_GUIDELINES | qp_pricing_guidelines_all_b | PRICING_GUIDELINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_CHARGE_GUIDELINES_FK1 | Non Unique | FUSION_TS_TX_IDX | PRICING_GUIDELINE_ID |
| QP_CHARGE_GUIDELINES_FK2 | Non Unique | FUSION_TS_TX_IDX | GUIDELINE_MATRIX_ID |
| QP_CHARGE_GUIDELINES_PK | Unique | FUSION_TS_TX_IDX | CHARGE_GUIDELINE_ID |