PRICE_PLAN

Definition

The PRICE_PLAN table contains information about price plans

Technical Data

Schema Version	4.5.13
Filegroup	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
OID	PK_PRICE_PLAN				USAGE_RATE (PLAN_OID) RECURRING_RATE (PLAN_OID) PRICE_PLAN_FREE_TEXT (PLAN_OID) PARAMETER (PLAN_OID) CCPP_ADDITIONAL_INFO (PLAN_OID) ONE_SHOT_RATE (PLAN_OID) ACCOUNT_EVENT_RATE (PLAN_OID) COUNTER_DESC (PLAN_OID) CHARGING_PLAN (PLAN_OID) EVENT_RATE (PLAN_OID)
NAME
DESCRIPTION
CURRENCY_CODE
CHRG_OID			IX_PP_CHRG	CHARGE_COMPONENT (OID)
VALIDATION_DATE

Column Details

OID

Definition	The unique identifier of the price plan
Type	DECIMAL(28), NOT NULL
Primary Key	PK_PRICE_PLAN

NAME

Definition	The name of the price plan
Type	NVARCHAR(256), NOT NULL

DESCRIPTION

Definition	The description of the price plan
Type	NVARCHAR(256), NULL

CURRENCY_CODE

Definition	The currency code of the price plan
Type	NVARCHAR(5), NULL

CHRG_OID

Definition	The ID of the charge component which contains the price plan
Type	DECIMAL(28), NOT NULL
Available Index	IX_PP_CHRG

VALIDATION_DATE

Definition	The date when the price plan becomes valid
Type	DATETIME, NULL

Primary Key Details

PK_PRICE_PLAN

Column(s)	OID
Filegroup	CATALOG_DATA

Index Details

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

IX_PP_CHRG

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