CHARGING_PLAN_DICTIONARY

Definition


The CHARGING_PLAN_DICTIONARY table contains the reference dictionary of a charge

Technical Data


Schema Version 5.0.6
Partitioned No

Summary


The CHARGING_PLAN_DICTIONARY 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
INTERNAL_CHARGING_REFERENCE        

    The balance reference
    BACKUP_CHARGING_REFERENCE        

      The backup of the balance reference
      CHRG_OID     IX_CHPD_CHRG  CHARGE_COMPONENT (OID)
       

        The ID of the charge component
        CHARGING_REFERENCE_TYPE        

          The account type of the charging reference

          More...

          Column Details

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

          INTERNAL_CHARGING_REFERENCE

          Definition The balance reference
          Type NVARCHAR(256), NOT NULL

          BACKUP_CHARGING_REFERENCE

          Definition The backup of the balance reference
          Type NVARCHAR(256), NULL

          CHRG_OID

          Definition The ID of the charge component
          Type DECIMAL(28), NOT NULL
          Available Index IX_CHPD_CHRG

          CHARGING_REFERENCE_TYPE

          Definition The account type of the charging reference
          Format

          The possible values are:

          • 0: postpaid
          • 1: prepaid

          Type DECIMAL(1), NULL

          Index Details

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

          IX_CHPD_CHRG

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