EIM_ADDITIONAL_INFO

Exportable Item Mapping Additional Information

Definition

The EIM_ADDITIONAL_INFO table contains additional information about the exportable item mapping

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

The EIM_ADDITIONAL_INFO table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	FK	IX	Uses	Used by	Definition
EIM_OID			IX_EIM_AI	EXPORTABLE_ITEM_MAPPING (OID)		The identifier of the exportable item mapping
NAME						The name of the additional information
VALUE_TYPE						The type of the additional information More...
NUMBER_VALUE						The value of the additional information when it is a number
STRING_VALUE						The value of the additional information when it is a string
DATE_VALUE						The value of the additional information when it is a date

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

EIM_OID

Definition	The identifier of the exportable item mapping
Type	DECIMAL(28), NOT NULL
Available Index	IX_EIM_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	SECONDDATE, NULL

Index Details

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

IX_EIM_AI

Indexed Column(s)	EIM_OID
Unique	No
Partitioned	No