OFFER_PARAMETER

Table: OFFER_PARAMETER

Table Name

OFFER_PARAMETER

Table Description

The OFFER_PARAMETER table contains information about parameters defined in offers.

Tablespace

CATALOG_DATA

Database

Columns

The OFFER_PARAMETER database table is defined by the following columns.

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

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

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

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

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:

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: OFFER Foreign field(s): OID
Index(es)	IX_OPAR_OFFE
Column Description	The identifier of the offer.

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

Document Version: SP04 and later