Table: PRICE_PLAN

Table Name PRICE_PLAN
Table Description The PRICE_PLAN table contains information about price plans.
Tablespace CATALOG_DATA
Database Core Database
Columns
OID
NAME
DESCRIPTION
CURRENCY_CODE
CHRG_OID
VALIDATION_DATE

Columns of the Table

The PRICE_PLAN database table is defined by the following columns.

Column: OID

Value Type BIGINT, NOT NULL
Key(s) Primary Key: PK_PRICE_PLAN

Foreign K.:

  • Foreign table: CHARGE_COMPONENT
  • Foreign field(s): OID

Index(es) IX_PP_CHRG
Column Description The price plan unique id.


Column: NAME

Value Type VARCHAR(256), NOT NULL
Column Description The name of the price plan.


Column: DESCRIPTION

Value Type VARCHAR(256)
Column Description The description of the price plan.


Column: CURRENCY_CODE

Value Type VARCHAR(5)
Column Description The currency code of the price plan.


Column: CHRG_OID

Value Type BIGINT, NOT NULL
Key(s) -

Foreign K.:

  • Foreign table: CHARGE_COMPONENT
  • Foreign field(s): OID

Index(es) IX_PP_CHRG
Column Description The ID of the charge component which contains the price plan.


Column: VALIDATION_DATE

Value Type DATE
Column Description The date when the price plan becomes valid.


Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

(c) Copyright 2011 SAP AG. All rights reserved.