QP_PB_CHARGE_COMPS_B
This table stores all the charge components in Price Books.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_PB_CHARGE_COMPS_B_PK |
PB_CHARGE_COMPONENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PB_CHARGE_COMPONENT_ID | NUMBER | 18 | Yes | Value that uniquely identifies the price book charge component. Oracle Pricing automatically assigns this value. | |
| PRICE_BOOK_CHARGE_ID | NUMBER | 18 | Yes | Value that uniquely identifies the price book charge. Oracle Pricing automatically assigns this value. | |
| PRICE_BOOK_LINE_ID | NUMBER | 18 | Yes | Value that uniquely identifies the price book line. Oracle Pricing automatically assigns this value. | |
| PRICE_BOOK_ID | NUMBER | 18 | Value that uniquely identifies the price book. Oracle Pricing automatically assigns this value. | ||
| CHARGE_CURRENCY_CODE | VARCHAR2 | 15 | The code that identifies the charge currency used in the charge component. | ||
| CHARGE_CURRENCY_EXT_AMOUNT | NUMBER | Value that indicates the charge currency extended amount in the charge currency. | |||
| HEADER_CURRENCY_CODE | VARCHAR2 | 15 | The code that identifies the header currency used in the charge component. | ||
| HEADER_CURRENCY_EXT_AMOUNT | NUMBER | Value that indicates the header currency extended amount in the charge currency. | |||
| PRICE_ELEMENT_CODE | VARCHAR2 | 30 | The code that identifies the element reference to the price elements setup. For example, QP_LIST_PRICE, QP_NET_PRICE. | ||
| PRICE_ELEMENT_USAGE_CODE | VARCHAR2 | 30 | The code that identifies the value used by the consuming applications to indicate how the charge component is used. The list of accepted values is defined in the lookup type ORA_QP_ELEMENT_USAGES. | ||
| SEQUENCE_NUMBER | NUMBER | 9 | Yes | Number that is the sequence for the charge component. | |
| CHARGE_CURRENCY_UNIT_PRICE | NUMBER | Price or adjustment for each unit in the charge currency for the line unit of measure. | |||
| HEADER_CURRENCY_UNIT_PRICE | NUMBER | Price or adjustment for each unit in the header currency for the line unit of measure. | |||
| ROLLUP_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the charge component is for a rolled-up charge. Valid values are Y or N. Defaults to N for new records. | |
| PRICING_SOURCE_ID | VARCHAR2 | 30 | Value that uniquely identifies the lowest level pricing source. For example, price list or discount rule. | ||
| PRICING_SOURCE_TYPE_CODE | VARCHAR2 | 30 | The code that identifies the type of the pricing source. For example, price list charge, rate plan charge, tiered pricing rule, etc. A list of accepted values is defined in the lookup type ORA_QP_SOURCE_TYPES. | ||
| EXPLANATION_MESSAGE_NAME | VARCHAR2 | 30 | The name of an explanation message of a charge component. | ||
| MESSAGE_TOKEN_INFO | CLOB | The explanation message token information. Contains key, value and type of the message in JSON format. | |||
| CHARGE_CURR_DURATION_EXT_AMT | NUMBER | The coverage extended amount in the charge currency for the entire duration of the service on the coverage association. | |||
| HEADER_CURR_DURATION_EXT_AMT | NUMBER | The coverage extended amount in the header currency for the entire duration of the service on the coverage association. | |||
| 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_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. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| QP_PB_CHARGE_COMPS_B | qp_price_book_charges | PRICE_BOOK_CHARGE_ID |
| QP_PB_CHARGE_COMPS_B | qp_price_book_lines | PRICE_BOOK_LINE_ID |
| qp_pb_charge_comps_tl | qp_pb_charge_comps_b | PB_CHARGE_COMPONENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_PB_CHARGE_COMPS_B_N1 | Non Unique | DEFAULT | PRICE_BOOK_CHARGE_ID, SEQUENCE_NUMBER |
| QP_PB_CHARGE_COMPS_B_U1 | Unique | DEFAULT | PB_CHARGE_COMPONENT_ID |