RI_CLASS

Refill Item Class Table

Definition

The RI_CLASS table contains the description for each refill item class

Technical Data

Schema Version	2025.0.0
Partitioned	No

Summary

The RI_CLASS 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
OID	PK_RI_CLASS				RI_PROPERTY_DESCRIPTION (ITEM_OID)	The unique ID of the refill item class
CLIENT_NUMBER			IX_RI_CLASS_IDIX_RI_CLASS_SP			The client number associated to the refill item class
SERVICE_PROVIDER			IX_RI_CLASS_SP			The service provider that owns the refill item class
ID			IX_RI_CLASS_ID			The ID of the refill item class
DESCRIPTION						The description of the chargeable item

Column Details

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

OID

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

CLIENT_NUMBER

Definition	The client number associated to the refill item class
Type	DECIMAL(3), NOT NULL
Available Index	IX_RI_CLASS_ID
Available Index	IX_RI_CLASS_SP

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

See the primary key information:

PK_RI_CLASS

Column(s)	OID
Tablespace	CATALOG_INDX

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)	CLIENT_NUMBER, ID
Unique	Yes
Partitioned	No

IX_RI_CLASS_SP

Indexed Column(s)	CLIENT_NUMBER, SERVICE_PROVIDER
Unique	No
Partitioned	No