CITC_FIELD

Charged Item Class Fields

Definition

The CITC_FIELD table describes the fields of a charged item class

Technical Data

Schema Version	5.0.6
Tablespace	CATALOG_DATA
Partitioned	No

Summary

The CITC_FIELD 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
NAME						The name of the field. It must be unique for a charged item class.
INDEX_IN_CLASS						The position of the field in the class
VALUE_TYPE						The type of the field More...
DESCRIPTION						The description of the field
CITC_OID			IX_CITC_FIELD	CHARGED_ITEM_CLASS (OID)		The OID of the charged item class having this field
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:

NAME

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

INDEX_IN_CLASS

Definition	The position of the field in the class
Type	DECIMAL(3), 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

DESCRIPTION

Definition	The description of the field
Type	VARCHAR(2000), NULL

CITC_OID

Definition	The OID of the charged item class having this field
Type	DECIMAL(28), NOT NULL
Available Index	IX_CITC_FIELD

STRING_VALUE

Definition	The value of the field when it is a string
Type	VARCHAR(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	TIMESTAMP, 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	VARCHAR(256), NULL

Index Details

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

IX_CITC_FIELD

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