CITM_ENTRY

Offer Charged Item Mapping Table

Definition

The CITM_ENTRY table describes the entries of an offer charged item mapping

Technical Data

Schema Version	5.0.6
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The CITM_ENTRY 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
CITM_OID			IX_CITM_ENTRY	CHARGED_ITEM_MAPPING (OID)		The OID of the charged item mapping having this entry
CITC_FIELD_NAME						The name of the charged item class field. It must be unique for a charged item mapping
VALUE_TYPE						The type of the field More...
STRING_VALUE						The value of the field when it is a string
NUMBER_VALUE						The value of the field when it is a number
DATE_VALUE						The value of the field when it is a date
BOOLEAN_VALUE						The value of the field when it is a boolean
PROPERTY_NAME						The name of the property to map

Column Details

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

CITM_OID

Definition	The OID of the charged item mapping having this entry
Type	DECIMAL(28), NOT NULL
Available Index	IX_CITM_ENTRY

CITC_FIELD_NAME

Definition	The name of the charged item class field. It must be unique for a charged item mapping
Type	NVARCHAR(256), NOT NULL

VALUE_TYPE

Definition	The type of the field
Format	The possible values are: 0: number 1: string 2: date 3: boolean
Type	DECIMAL(1), NOT NULL

STRING_VALUE

Definition	The value of the field when it is a string
Type	NVARCHAR(64), NULL

NUMBER_VALUE

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

DATE_VALUE

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

BOOLEAN_VALUE

Definition	The value of the field when it is a boolean
Type	DECIMAL(1), NULL

PROPERTY_NAME

Definition	The name of the property to map
Type	NVARCHAR(256), NULL

Index Details

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

IX_CITM_ENTRY

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