PARAMETER

Table: PARAMETER

Table Name

PARAMETER

Table Description

The PARAMETER table contains information about the parameters defined in price plans.

Tablespace

CATALOG_DATA

Database

Columns

The PARAMETER database table is defined by the following columns.

Value Type	DECIMAL(5), NOT NULL
Column Description	The position of the parameter in the price plan.

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

Value Type	VARCHAR(2000)
Column Description	The description of the parameter.

Value Type	DECIMAL(2), NOT NULL
Column Description	The type of the parameter. Possible values are: 0: number 1: string 2: date

Value Type

DECIMAL(2), NOT NULL

Column Description

The type of the parameter.

Possible values are:

Value Type	DECIMAL(1), NOT NULL
Column Description	The IS_PRIVATE field gives the visibility of the parameter. Possible values are: 0: external. The parameter can be modified outside the price plan, in an offer or a subscription for example. 1: internal. The parameter cannot be modified outside the price plan.

Value Type

DECIMAL(1), NOT NULL

Column Description

The IS_PRIVATE field gives the visibility of the parameter.

Possible values are:

0: external. The parameter can be modified outside the price plan, in an offer or a subscription for example.
1: internal. The parameter cannot be modified outside the price plan.

Value Type	DECIMAL(28,6)
Column Description	The value of the parameter when it is a number.

Value Type	VARCHAR(2000)
Column Description	The value of the parameter when it is a string.

Value Type	DATE
Column Description	The value of the parameter when it is a date.

Value Type	BIGINT, NOT NULL
Key(s)	-	Foreign K.: Foreign table: PRICE_PLAN Foreign field(s): OID
Index(es)	IX_PP_PARAMETER
Column Description	The ID of the price plan that owns this parameter.

Value Type	DECIMAL(3), NOT NULL
Column Description	The number of additional info for this parameter

Document Version: SP04 and later