CI_DESCRIPTION

Description

The CI_DESCRIPTION table contains a description for each chargeable item class included in a product (chargeable item package). A product can include several chargeable item classes. It also contains the chargeable item classes.

Technical Data

Schema Version	4.5.13
Tablespace	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	IX	Uses	Used by
OID	PK_CI_DESCRIPTION			PROPERTY_DESCRIPTION (ITEM_OID)
DESCRIPTION
NAME
PROD_OID		IX_CI_DESCRIPTION	PRODUCT (OID)
SERVICE_PROVIDER
OLD_NAME
OLD_PROD_CODE

Column Details

OID

Definition	The unique ID of the chargeable item description
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CI_DESCRIPTION

DESCRIPTION

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

NAME

Definition	The name of the chargeable item
Type	VARCHAR(256), NOT NULL

PROD_OID

Definition	The identifier of the product (chargeable item package) in which this chargeable item is included
Description	The identifier of the product (chargeable item package) in which this chargeable item is included. See the OID column of the PRODUCT table
Type	DECIMAL(28), NULL
Available Index	IX_CI_DESCRIPTION

SERVICE_PROVIDER

Definition	The service provider that owns the refill item class
Type	VARCHAR(64), NULL

OLD_NAME

Definition	The name of the chargeable item class when it was included in a product (chargeable item package), before the migration to independent chargeable item classes
Type	VARCHAR(256), NULL

OLD_PROD_CODE

Definition	The name of the product (chargeable item package) in which the chargeable item class was included, before the migration to independent chargeable item classes
Type	VARCHAR(256), NULL

Primary Key Details

PK_CI_DESCRIPTION

Column(s)	OID
Tablespace	CATALOG_INDX

Index Details

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

IX_CI_DESCRIPTION

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