OFFER_CONDITION

Table: OFFER_CONDITION

Table Name

OFFER_CONDITION

Table Description

The OFFER_CONDITION table describes offer conditions. An offer condition enables to use an existing offer as a suboffer in another offer.

Tablespace

CATALOG_DATA

Database

Columns

The OFFER_CONDITION database table is defined by the following columns.

Value Type	BIGINT, NOT NULL
Key(s)	Primary Key: PK_OFFER_CONDITION	Foreign K.: Foreign table: OFFER Foreign field(s): OID
Index(es)	IX_OFFER_CONDITION_OFFER IX_OCON_OFFE
Column Description	The identifier of the offer condition.

Value Type	VARCHAR(256), NOT NULL
Column Description	The code of the offer condition.

Value Type	DECIMAL(1), NOT NULL
Column Description	The status of the offer condition in subscriptions. Possible values are: 0: subscribing the offer is mandatory 1: subscribing the offer is optional

Value Type	BIGINT
Column Description	The minimum number of times that the offer condition can be subscribed to.

Value Type	BIGINT
Column Description	The maximum number of times that the offer condition can be subscribed to.

Value Type	BIGINT
Column Description	The step between the ORDER_MINIMUM and the ORDER_MAXIMUM field. Example: If ORDER_MINIMUM=1, ORDER_MAXIMUM=5 and ORDER_STEP=2, then the offer condition can be subscribed to 1, 3 or 5 times.

Value Type

BIGINT

Column Description

The step between the ORDER_MINIMUM and the ORDER_MAXIMUM field.

Example: If ORDER_MINIMUM=1, ORDER_MAXIMUM=5 and ORDER_STEP=2, then the offer condition can be subscribed to 1, 3 or 5 times.

Value Type	BIGINT, NOT NULL
Key(s)	-	Foreign K.: Foreign table: OFFER Foreign field(s): OID
Index(es)	IX_OFFER_CONDITION_OFFER IX_OCON_OFFE
Column Description	The offer which is redefined by the offer condition.

Value Type	BIGINT, NOT NULL
Key(s)	-	Foreign K.: Foreign table: OFFER Foreign field(s): OID
Index(es)	IX_OFFER_CONDITION_OFFER
Column Description	The offer containing the offer condition.

Document Version: SP04 and later