RCL_SERVICE_CHARGE_COMPONENTS
This table stores information in regard to service charge components object.
Details
-
Schema: FUSION
-
Object owner: RCL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
RCL_SERVICE_CHARGE_COMPON_PK |
SERVICE_CHARGE_COMPONENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SERVICE_CHARGE_COMPONENT_ID | NUMBER | 18 | Yes | Unique identifier and primary key of the service charge component business object. | |
| 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. | |
| SERVICE_CHARGE_ID | NUMBER | 18 | Foreign key to RCL_SERVICE_CHARGES table. | ||
| CHARGE_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the currency used in the charge component. Needed due to service standardization. | ||
| CHARGE_CURRENCY_EXT_AMOUNT | NUMBER | Indicates the extended amount in charge currency. Extended amount equals the unit price multiplied by the line requested quantity for simple products and equals the unit price multiplied by the line extended quantity for CP. | |||
| HEADER_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the header currency. Needed due to service standardization. | ||
| HEADER_CURRENCY_EXT_AMOUNT | NUMBER | Indicates the extended amount in header currency. | |||
| PERCENT_OF_COMPARISON_ELEMENT | NUMBER | The percentage that this unit price is of the basis charge component unit price. By default the basis is the List Price. This attribute captures the Margin %, the % the Net Price is of the List Price etc. | |||
| PRICE_ELEMENT_CODE | VARCHAR2 | 30 | The price element code. | ||
| PRICE_ELEMENT_USAGE_CODE | VARCHAR2 | 30 | The price element usage code. | ||
| SEQUENCE_NUMBER | NUMBER | 18 | Yes | Indicates the sequence for the charge. | |
| CHARGE_CURRENCY_UNIT_PRICE | NUMBER | The unit price in charge line currency. | |||
| HEADER_CURRENCY_UNIT_PRICE | NUMBER | The unit price in charge header currency. | |||
| ROLLUP_FLAG | VARCHAR2 | 1 | Yes | Marks a charge as a rollup/aggregate charge. | |
| PARENT_CHARGE_COMPONENT_ID | NUMBER | 18 | The parent charge component id. | ||
| SOURCE_CHARGE_COMPONENT_ID | VARCHAR2 | 50 | The source charge component id. | ||
| SOURCE_CHARGE_ID | VARCHAR2 | 50 | The unique internal identifier for the charge assigned by the system that captured the transaction. | ||
| SOURCE_PARENT_CHARGE_COMP_ID | VARCHAR2 | 50 | The source parent charge component id. | ||
| EXPLANATION | VARCHAR2 | 1000 | The detailed explanation for the charge component. | ||
| PRICING_SOURCE_ID | VARCHAR2 | 30 | Unique identifier in the pricing system where the charge component was first entered. | ||
| PRICING_SOURCE_TYPE_CODE | VARCHAR2 | 30 | Identifies the pricing system code where the charge component line was first entered. | ||
| EXPLANATION_MESSAGE_NAME | VARCHAR2 | 30 | The message name for the explanation. | ||
| REFERENCE_SRV_CHARGE_COMP_ID | VARCHAR2 | 18 | Used by change mgmt to associate the service charge component id. | ||
| DELTA_TYPE | NUMBER | 18 | Internal column used by change processing framework for tracking types of change such as update, cancel, etc. | ||
| TAX_INCLUDED_FLAG | VARCHAR2 | 1 | Yes | This flag indicates if tax is included in the charge component. | |
| MODIFIED_FLAG | VARCHAR2 | 1 | Indicates that the row has been modified in the current submitted version. | ||
| SOURCE_MPA_ID | VARCHAR2 | 50 | The source MPA id. | ||
| CHARGE_CURR_DURATION_EXT_AMT | NUMBER | The extended calculatd amount based on charge component currency and duration. | |||
| HEADER_CURR_DURATION_EXT_AMT | NUMBER | The extended calculated amount based on charge header currency and duration. | |||
| COVERAGE_PRODUCT_ID | NUMBER | 18 | The coverage product returned by contracts. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RCL_SERVICE_CHARGE_COMPONENTS | rcl_service_charges | SERVICE_CHARGE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCL_SERVICE_CHARGE_COMPON_FK1 | Non Unique | Default | SERVICE_CHARGE_ID |
| RCL_SRV_CHARGE_COMP_U1 | Unique | Default | SERVICE_CHARGE_COMPONENT_ID |