XCI_VALUES

Description


the extended chargeable items (XCIs)

Technical Data


Schema Version 4.5.0
Tablespace
Partitioned No

Summary


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

Name PK FK IX Uses Used by
XCI_ID     IX_XCI_VALUES     
PROP_ID       PROP_INFO (PROP_ID)
 
 
NUMBER_VALUE          
STRING_VALUE          
DATE_VALUE          

Column Details


XCI_ID

Definition The unique ID of the extended chargeable item (XCI) recorded by the IEC application
Type DECIMAL(28), NOT NULL
Available Index IX_XCI_VALUES

PROP_ID

Definition The ID of the property information in the PROP_INFO table
Type DECIMAL(28), NOT NULL

NUMBER_VALUE

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

STRING_VALUE

Definition The value of the property information if type is string
Type VARCHAR(2000), NULL

DATE_VALUE

Definition The value of the property information if type is date
Type TIMESTAMP, NULL

Index Details


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

IX_XCI_VALUES

Indexed Column(s) XCI_ID
Unique Yes
Partitioned No
Tablespace