MACA_ADDITIONAL_INFO

Definition

The MACA_ADDITIONAL_INFO table contains additional information defined in mapping table classes (see the MACA table)

Description

The MACA_ADDITIONAL_INFO database table includes all the additional information items that are defined in the mapping table classes (see the MACA database table) stored in the back-end database system.

Technical Data

Schema Version	5.0.6
Tablespace	CATALOG_DATA
Partitioned	No

Summary

The MACA_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
MACA_OID			IX_MACA_AI	MACA (OID)		The identifier (OID) of the mapping table class that contains the additional information item
NAME						The identification name of the additional information item
DESCRIPTION						The textual description for the additional information item
VALUE_TYPE						The type of the additional information item More...
NUMBER_VALUE						The value of the additional information item when it is a number
STRING_VALUE						The value of the additional information item when it is a string
DATE_VALUE						The value of the additional information item when it is both a date and a time

Column Details

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

MACA_OID

Definition	The identifier (OID) of the mapping table class that contains the additional information item
Type	DECIMAL(28), NOT NULL
Available Index	IX_MACA_AI

NAME

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

DESCRIPTION

Definition	The textual description for the additional information item
Type	VARCHAR(2000), NULL

VALUE_TYPE

Definition	The type of the additional information item
Format	The possible values are: 0: Number 1: String 2: Date/Time
Type	DECIMAL(1), NOT NULL

NUMBER_VALUE

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

STRING_VALUE

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

DATE_VALUE

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

Index Details

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

IX_MACA_AI

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