EIMF_ADDITIONAL_INFO

Exportable Item Mapping Field Additional Information

Definition


The EIMF_ADDITIONAL_INFO table contains additional information about the exportable item mapping field

Technical Data


Schema Version 4.5.13
Segment CATALOG_DATA
Partitioned No

Summary


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

Name PK FK IX Uses Used by
EIMF_OID     IX_EIMF_AI  EIM_FIELD (OID)
 
 
NAME          
VALUE_TYPE          
NUMBER_VALUE          
STRING_VALUE          
DATE_VALUE          

Column Details


EIMF_OID

Definition The identifier of the exportable item mapping field
Type DECIMAL(28), NOT NULL
Available Index IX_EIMF_AI

NAME

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

VALUE_TYPE

Definition The type of the 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 NVARCHAR(2000), NULL

DATE_VALUE

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

Index Details


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

IX_EIMF_AI

Indexed Column(s) EIMF_OID
Unique No
Partitioned No
Clustered No
Segment CATALOG_INDX