IN_MACA_COLUMN

Definition

The IN_MACA_COLUMN table contains the input columns used in a mapping table class (see the MACA table)

Technical Data

Schema Version	4.5.13
Filegroup	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
NAME
DESCRIPTION
TYPE
INDEX_IN_MACA
MACA_OID			IX_IN_MACA_COLUMN	MACA (OID)

Column Details

NAME

Definition	The name of the input colum
Type	NVARCHAR(265), NOT NULL

DESCRIPTION

Definition	The description of the input colum
Type	NVARCHAR(2000), NULL

TYPE

Definition	The type of the input
Format	The possible values are: 0: String 1: Currency
Type	DECIMAL(1), NULL

INDEX_IN_MACA

Definition	The position of the input column in the mapping table class
Type	DECIMAL(5), NOT NULL

MACA_OID

Definition	The unique identifier of the input column in the database
Type	DECIMAL(28), NOT NULL
Available Index	IX_IN_MACA_COLUMN

Index Details

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

IX_IN_MACA_COLUMN

Indexed Column(s)	MACA_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX