OFFER_PARA_KEY

Definition


The OFFER_PARA_KEY table is a mapping between the key and the parameter name in offers

Technical Data


Schema Version 5.0.6
Tablespace CATALOG_DATA
Partitioned No

Summary


The OFFER_PARA_KEY 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
OFFE_OID     IX_PKEY_OFFE  OFFER (OID)
 

    The identifier of the offer owning the parameter
    PARA_NAME        

      The name of the parameter
      PARA_KEY        

        The identifier of the parameter

        Column Details

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

        OFFE_OID

        Definition The identifier of the offer owning the parameter
        Type DECIMAL(28), NOT NULL
        Available Index IX_PKEY_OFFE

        PARA_NAME

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

        PARA_KEY

        Definition The identifier of the parameter
        Type DECIMAL(6), NOT NULL

        Index Details

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

        IX_PKEY_OFFE

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