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 Core Database
Columns
OID
SUB_CODE
OPTIONAL_ORDER
ORDER_MINIMUM
ORDER_MAXIMUM
ORDER_STEP
OFFE_OID
HOLDER_OFFE_OID

Columns of the Table

The OFFER_CONDITION database table is defined by the following columns.

Column: OID

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.


Column: SUB_CODE

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


Column: OPTIONAL_ORDER

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


Column: ORDER_MINIMUM

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


Column: ORDER_MAXIMUM

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


Column: ORDER_STEP

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.



Column: OFFE_OID

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.


Column: HOLDER_OFFE_OID

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.


Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

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