RI_PROPERTY_DESCRIPTION

Definition


The RI_PROPERTY_DESCRIPTION table describes the properties of a refill item class

Technical Data


Schema Version 5.0.6
Tablespace CATALOG_DATA
Partitioned No

Summary


The RI_PROPERTY_DESCRIPTION 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 property

    More...

    INDEX_IN_ITEM        

      The position of the property in the item
      VALUE_TYPE        

        The type of the property

        More...

        DESCRIPTION        

          The description of the property
          ITEM_OID     IX_RI_PROPERTY_DESCRIPTION  RI_CLASS (OID)
           

            The OID of the refill item class having this property

            Column Details

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

            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