RI_PROPERTY_DESCRIPTION

Definition


The RI_PROPERTY_DESCRIPTION table describes the properties of a refill item class

Technical Data


Schema Version 4.5.13
Tablespace CATALOG_DATA
Partitioned No

Summary


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

Name PK FK IX Uses Used by
NAME          
INDEX_IN_ITEM          
VALUE_TYPE          
DESCRIPTION          
ITEM_OID     IX_RI_PROPERTY_DESCRIPTION  RI_CLASS (OID)
 
 

Column Details


NAME

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

INDEX_IN_ITEM

Definition The position of the property in the item
Type DECIMAL(3), NOT NULL

VALUE_TYPE

Definition The type of the property
Format

The possible values are:

  • 0: number
  • 1: string
  • 2: date

Type DECIMAL(1), NOT NULL

DESCRIPTION

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

ITEM_OID

Definition The OID of the refill item class having this property
Type DECIMAL(28), NOT NULL
Available Index IX_RI_PROPERTY_DESCRIPTION

Index Details


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

IX_RI_PROPERTY_DESCRIPTION

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