Table: OFFER

Table Name OFFER
Table Description The OFFER table contains a description of the offer.
Tablespace CATALOG_DATA
Database Core Database
Columns
OID
CODE
OWNER
SHORT_DESCRIPTION
LONG_DESCRIPTION
EFFECTIVE_DATE
EXPIRATION_DATE

Columns of the Table

The OFFER database table is defined by the following columns.

Column: OID

Value Type BIGINT, NOT NULL
Key(s) Primary Key: PK_OFFER
Column Description The unique identifier for this offer. It is generated by the system.


Column: CODE

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


Column: OWNER

Value Type VARCHAR(64), NOT NULL
Index(es) IX_OFFER_OWNER
Column Description The owner of the offer.


Column: SHORT_DESCRIPTION

Value Type VARCHAR(256)
Column Description A short description of the offer.


Column: LONG_DESCRIPTION

Value Type VARCHAR(2000)
Column Description A long description of the offer.


Column: EFFECTIVE_DATE

Value Type DATE
Column Description The effective date of the offer.


Column: EXPIRATION_DATE

Value Type DATE
Column Description The expiration date of the offer.


Top of the list



SAP Convergent Charging 3.0

Document Version: SP04 and later

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