RACA_ADDITIONAL_INFO

Description


range table classes

Technical Data


Schema Version 4.5.13
Tablespace CATALOG_DATA
Partitioned No

Summary


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

Name PK FK IX Uses Used by
RACA_OID     IX_RACA_AI  RACA (OID)
 
 
NAME          
DESCRIPTION          
VALUE_TYPE          
NUMBER_VALUE          
STRING_VALUE          
DATE_VALUE          

Column Details


RACA_OID

Definition The identifier of the range table class
Type DECIMAL(28), NOT NULL
Available Index IX_RACA_AI

NAME

Definition The name of the additional information
Type VARCHAR(256), NOT NULL

DESCRIPTION

Definition The description of the additional information
Type VARCHAR(2000), NULL

VALUE_TYPE

Definition The type of additional information
Format

The possible values are:

  • 0: Number
  • 1: String
  • 2: Date

Type DECIMAL(1), NOT NULL

NUMBER_VALUE

Definition The value of the additional information when it is a number
Type DECIMAL(28,6), NULL

STRING_VALUE

Definition The value of the additional information when it is a string
Type VARCHAR(2000), NULL

DATE_VALUE

Definition The value of the additional information when it is a date
Type TIMESTAMP, NULL

Index Details


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

IX_RACA_AI

Indexed Column(s) RACA_OID
Unique No
Partitioned No
Tablespace CATALOG_INDX