OCON_PARAMETER

Table: OCON_PARAMETER

Table Name

OCON_PARAMETER

Table Description

The OCON_PARAMETER table contains information about parameters in offer conditions. These parameters are first created in the offer corresponding to the offer condition. Then they are redefined in the offer condition.

Tablespace

CATALOG_DATA

Database

Core Database

Columns

INDEX_IN_OCON
NAME
DESCRIPTION
PARAMETER_NAME
VALUE_TYPE
IS_PRIVATE
NUMBER_VALUE
STRING_VALUE
DATE_VALUE
OCON_OID
VALIDATION_DATE

Columns of the Table

The OCON_PARAMETER database table is defined by the following columns.

Column: INDEX_IN_OCON

Value Type	DECIMAL(5), NOT NULL
Column Description	The index of the parameter in the offer condition.

Column: NAME

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

Column: DESCRIPTION

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

Column: PARAMETER_NAME

Value Type	VARCHAR(256)
Column Description	The parameter in the offer condition can be linked to a parameter with the same type defined in the offer containing the offer condition. The PARAMETER_NAME field gives the name of the parameter defined in the offer.

Column: VALUE_TYPE

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

Column: IS_PRIVATE

Value Type	DECIMAL(1), NOT NULL
Column Description	The IS_PRIVATE field gives the visibility of the parameter. Possible values are: 0: The parameter can be modified in a subscription. 1: The parameter can be modified in an offer.

Value Type

DECIMAL(1), NOT NULL

Column Description

The IS_PRIVATE field gives the visibility of the parameter.

Possible values are:

0: The parameter can be modified in a subscription.
1: The parameter can be modified in an offer.

Column: NUMBER_VALUE

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

Column: STRING_VALUE

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

Column: DATE_VALUE

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

Column: OCON_OID

Value Type	BIGINT, NOT NULL
Key(s)	-	Foreign K.: Foreign table: OFFER_CONDITION Foreign field(s): OID
Index(es)	IX_OCPA_OCON
Column Description	The identifier of the offer condition owning the parameter.

Column: VALIDATION_DATE

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

Top of the list

SAP Convergent Charging 3.0

Document Version: SP04 and later