CHARGE_COMP_PRODUCT_CODE

Definition


The CHARGE_COMPONENT_PRODUCT_CODE table contains the product codes supported by a charge component

Technical Data


Schema Version 5.0.6
Filegroup CATALOG_DATA
Partitioned No

Summary


The CHARGE_COMP_PRODUCT_CODE 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
CHRG_OID     IX_CCOMP_CC_ID  CHARGE_COMPONENT (OID)
 

    The charge component unique ID
    PRODUCT_CODE     IX_CCOMP_CC_CODE   

      The product code

      Column Details

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

      CHRG_OID

      Definition The charge component unique ID
      Type DECIMAL(28), NOT NULL
      Available Index IX_CCOMP_CC_ID

      PRODUCT_CODE

      Definition The product code
      Type NVARCHAR(256), NOT NULL
      Available Index IX_CCOMP_CC_CODE

      Index Details

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

      IX_CCOMP_CC_ID

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

      IX_CCOMP_CC_CODE

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