OFFER

Definition

The OFFER table contains a description of the offer

Technical Data

Schema Version	4.5.13
Segment	CATALOG_DATA
Partitioned	No

Summary

The OFFER table is defined by the following columns. See the column details for more information.

Name	PK	FK	IX	Uses	Used by
OID	PK_OFFER				OFFER_TRANSLATION_INSTANCE (OFFE_OID) OFFER_TIER_TABLE_INSTANCE (OFFE_OID) OFFER_PARAMETER (OFFE_OID) OFFER_PARA_KEY (OFFE_OID) OFFER_COUNTER_DESC (OFFE_OID) OFFER_CONDITION (HOLDER_OFFE_OID) OFFER_CDES_KEY (OFFE_OID) OFFER_ADDITIONAL_INFO (OFFE_OID) CHARGE_DEPENDENCY (OFFE_OID) CHARGE_CONDITION (OFFE_OID)
CODE			IX_OFFER_CODE
OWNER			IX_OFFER_OWNER
SHORT_DESCRIPTION
LONG_DESCRIPTION
EFFECTIVE_DATE
EXPIRATION_DATE

Column Details

OID

Definition	The unique identifier for this offer
Description	The unique identifier for this offer. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_OFFER

CODE

Definition	The code of the offer
Type	NVARCHAR(256), NOT NULL
Available Index	IX_OFFER_CODE

OWNER

Definition	The owner of the offer
Type	NVARCHAR(64), NOT NULL
Available Index	IX_OFFER_OWNER

SHORT_DESCRIPTION

Definition	A short description of the offer
Type	NVARCHAR(256), NULL

LONG_DESCRIPTION

Definition	A long description of the offer
Type	NVARCHAR(2000), NULL

EFFECTIVE_DATE

Definition	The effective date of the offer
Type	DATETIME, NULL

EXPIRATION_DATE

Definition	The expiration date of the offer
Type	DATETIME, NULL

Primary Key Details

PK_OFFER

Column(s)	OID
Segment	CATALOG_INDX

Index Details

The following database indexes are available in the OFFER database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_OFFER_OWNER

Indexed Column(s)	OWNER
Unique	No
Partitioned	No
Clustered	No
Segment	CATALOG_INDX

IX_OFFER_CODE

Indexed Column(s)	CODE
Unique	Yes
Partitioned	No
Clustered	No
Segment	CATALOG_INDX