RI_CLASS

Refill Item Class Table

Definition

The RI_CLASS table contains the description for each refill item class

Technical Data

Schema Version	4.5.13
Filegroup	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
OID	PK_RI_CLASS				RI_PROPERTY_DESCRIPTION (ITEM_OID)
SERVICE_PROVIDER			IX_RI_CLASS_SP
ID			IX_RI_CLASS_ID
DESCRIPTION

Column Details

OID

Definition	The unique ID of the refill item class
Type	DECIMAL(28), NOT NULL
Primary Key	PK_RI_CLASS

SERVICE_PROVIDER

Definition	The service provider that owns the refill item class
Type	NVARCHAR(64), NOT NULL
Available Index	IX_RI_CLASS_SP

ID

Definition	The ID of the refill item class
Type	NVARCHAR(256), NOT NULL
Available Index	IX_RI_CLASS_ID

DESCRIPTION

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

Primary Key Details

PK_RI_CLASS

Column(s)	OID
Filegroup	CATALOG_DATA

Index Details

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

IX_RI_CLASS_ID

Indexed Column(s)	ID
Unique	Yes
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_RI_CLASS_SP

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