CHARGING_PLAN_DICTIONARY

Definition

The CHARGING_PLAN_DICTIONARY table contains the reference dictionary of a charge

Technical Data

Schema Version	4.5.13
Filegroup	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
INTERNAL_CHARGING_REFERENCE
BACKUP_CHARGING_REFERENCE
CHRG_OID			IX_CHPD_CHRG	CHARGE_COMPONENT (OID)
CHARGING_REFERENCE_TYPE

Column Details

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
Filegroup	CATALOG_INDX