QP_PRICE_LIST_CHARGES
This table stores the price list charges
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_PRICE_LIST_CHARGES_PK |
PRICE_LIST_CHARGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRICE_LIST_CHARGE_ID | NUMBER | 18 | Yes | Primary Key for the Charge record | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 240 | Value that uniquely identifies the charge for the price list item in the source system. This attribute is used for uniquely locating the charge record for supporting update scenarios. | ||
| PRICING_BASIS_ID | NUMBER | 18 | Column to store the Pricing Basis ID for a Return Charge | ||
| CHARGE_LINE_NUMBER | NUMBER | 9 | Yes | Unique Charge Line Number. This number is unique for a parent entity | |
| START_DATE | TIMESTAMP | Yes | The date starting from which this charge is valid | ||
| TIER_CONTEXT_CODE | VARCHAR2 | 30 | If Parent Type is Price List Item, the value of this attribute will be set to Item. If parent type is Covered Item, the value of this attribute will be set to Coverage | ||
| CHARGE_DEFINITION_ID | NUMBER | 18 | Yes | The charge definition for the associated price. | |
| PARENT_ENTITY_TYPE_CODE | VARCHAR2 | 30 | Yes | The Parent type to which the charge applies to | |
| PARENT_ENTITY_ID | NUMBER | 18 | Yes | The Parent ID to which the charge applies to | |
| BASE_PRICE | NUMBER | Base Price beore applying adjustments to on the PLL (AP, CP, TP, FP) | |||
| USAGE_UOM_CODE | VARCHAR2 | 3 | UOM Code for the usage price of the product | ||
| PRICE_PERIODICITY_CODE | VARCHAR2 | 3 | UOM Code for the Price Periodicity of the product | ||
| CAN_ADJUST_FLAG | VARCHAR2 | 30 | Flag that indicates if the price returned by this line can be adjusted manually | ||
| END_DATE | TIMESTAMP | The date starting to which this charge is valid | |||
| TIERED_PRICING_HEADER_ID | NUMBER | 18 | Foreign Key to Tiered Pricing header entity | ||
| ATTRIBUTE_PRICING_MATRIX_ID | NUMBER | 18 | Foreign Key to Attribute Pricing Model header entity | ||
| CALCULATION_METHOD_CODE | VARCHAR2 | 30 | Yes | The price calculation method for the charge | |
| CALCULATION_TYPE_CODE | VARCHAR2 | 30 | Indicates how coverage will be priced or adjusted. The adjustment type for adjusting the coverage when adjusting coverage or the coverage calculation type when pricing coverage.Can be Price Override or Percentage of Covered Product. | ||
| COST_CALCULATION_AMOUNT | NUMBER | Indicates the adjustment amount for cost based pricing | |||
| CALCULATION_AMOUNT | NUMBER | Indicates the calculation amount for the pricing charge | |||
| CHARGE_PERIOD_CODE | VARCHAR2 | 3 | Abbreviation that identifies the charge period for the usage charge. The charge period determines how frequently Pricing and Subscription Management add up the usages for a usage charge. Use a time unit of measure when you set the value for CHARGE_PERIOD_CODE. Pricing uses the UOM Class that you set in the RCS_DEFAULT_UOM_SERVICE_DURATION_CLASS profile option to validate the charge period that you set. | ||
| PRICE_LIST_ID | NUMBER | 18 | Id of the Price List to which this charge belongs. | ||
| QUANTITY_ATTRIBUTE | VARCHAR2 | 300 | Specify the name of an attribute that you use for the quantity in the Line entity of a service mapping. The Line entity comes with predefined attributes LineQuantity and UsageQuantity. You can use QUANTITY_ATTRIBUTE to specify your own attribute instead of using one of the predefined attributes. | ||
| QUANTITY_UOM_ATTRIBUTE | VARCHAR2 | 300 | Specify the name of an attribute that you use for the unit of measure in the Line entity of a service mapping. The Line entity comes with predefined attributes LineQuantityUOMCode and UsageQuantityUOMCode. You can use QUANTITY_UOM_ATTRIBUTE to specify your own attribute instead of using one of the predefined attributes. | ||
| BASE_PRICE_MATRIX_ID | NUMBER | 18 | Value that uniquely identifies the pricing matrix that pricing uses to calculate the base price | ||
| PERIODIC_BILLING_FLAG | VARCHAR2 | 1 | Periodic billing for a subscription. This attribute applies only to one-time charges. It is disabled for subscriptions that don't have an end date. | ||
| PERIODIC_REV_RECOGNITION_FLAG | VARCHAR2 | 1 | Periodic revenue recognition for a subscription. This attribute applies only to one-time charges. It is disabled for subscriptions that don't have an end date. | ||
| 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. | |
| 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_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | 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_PRICE_LIST_CHARGES | qp_price_lists_all_b | PRICE_LIST_ID |
| QP_PRICE_LIST_CHARGES | qp_price_list_charges | PRICE_LIST_CHARGE_ID |
| qp_price_list_charges | qp_price_list_charges | PRICE_LIST_CHARGE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_PRICE_LIST_CHARGES_FK1 | Non Unique | FUSION_TS_TX_IDX | PRICE_LIST_ID |
| QP_PRICE_LIST_CHARGES_FK2 | Non Unique | FUSION_TS_TX_IDX | TIERED_PRICING_HEADER_ID |
| QP_PRICE_LIST_CHARGES_FK3 | Non Unique | FUSION_TS_TX_IDX | CHARGE_DEFINITION_ID |
| QP_PRICE_LIST_CHARGES_FK4 | Non Unique | FUSION_TS_TX_IDX | ATTRIBUTE_PRICING_MATRIX_ID |
| QP_PRICE_LIST_CHARGES_N1 | Non Unique | FUSION_TS_TX_IDX | PARENT_ENTITY_TYPE_CODE, PARENT_ENTITY_ID, START_DATE, END_DATE |
| QP_PRICE_LIST_CHARGES_PK | Unique | FUSION_TS_TX_IDX | PRICE_LIST_CHARGE_ID |