RATE_COMPONENT_PROPERTY

Definition


The RATE_COMPONENT_PROPERTY table contains detailed information about rating and charging components

Technical Data


Schema Version 4.5.13
Filegroup CATALOG_DATA
Partitioned No

Summary


The RATE_COMPONENT_PROPERTY table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
RCOM_OID     IX_RCOP_RCOM  RATE_COMPONENT (OID)
 
 
PROPERTY_NAME          
PROPERTY_TYPE          
PROPERTY_INDEX          
NUMBER_VALUE          
STRING_VALUE          
DATE_VALUE          

Column Details


RCOM_OID

Definition The component unique identifier
Type DECIMAL(28), NOT NULL
Available Index IX_RCOP_RCOM

PROPERTY_NAME

Definition The name of the property
Type NVARCHAR(256), NULL

PROPERTY_TYPE

Definition The type of the property
Type DECIMAL(2), NULL

PROPERTY_INDEX

Definition The position of the property in the component
Type DECIMAL(3), NULL

NUMBER_VALUE

Definition The value of the property if it is a number
Type DECIMAL(28,6), NULL

STRING_VALUE

Definition The value of the property if it is a string
Type NVARCHAR(2000), NULL

DATE_VALUE

Definition The value of the property if it is a date
Type DATETIME, NULL

Index Details


The following database indexes are available in the RATE_COMPONENT_PROPERTY database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_RCOP_RCOM

Indexed Column(s) RCOM_OID
Unique No
Partitioned No
Clustered No
Filegroup CATALOG_INDX