OFFER_TRANSLATION_INSTANCE

Definition

The OFFER_TRANSLATION_INSTANCE table contains information about translation table instances in offers

Technical Data

Schema Version	4.5.13
Tablespace	CATALOG_DATA
Partitioned	No

Summary

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

Name	PK	FK	IX	Uses	Used by
OID	PK_OFFER_TRANSLATION_INSTANCE				OFFER_TRANSLATION_ROW (TINS_OID)
TTAB_CODE
OFFE_OID			IX_OTIN_OFFE	OFFER (OID)
NAME
IS_PRIVATE
VALIDATION_DATE

Column Details

OID

Definition	The identifier of the translation table instance
Type	DECIMAL(28), NOT NULL
Primary Key	PK_OFFER_TRANSLATION_INSTANCE

TTAB_CODE

Definition	The code of the translation table owning the instance
Type	VARCHAR2(256 CHAR), NULL

OFFE_OID

Definition	The identifier of the offer owning the instance
Type	DECIMAL(28), NOT NULL
Available Index	IX_OTIN_OFFE

NAME

Definition	The name of the instance
Type	VARCHAR2(256 CHAR), NULL

IS_PRIVATE

Definition	This field indicates if the translation table can be redefined at subscription level
Format	The possible values are: 0: cannot be redefined 1: can be redefined
Type	DECIMAL(1), NOT NULL

VALIDATION_DATE

Definition	The date when the instance becomes valid
Type	DATE, NULL

Primary Key Details

PK_OFFER_TRANSLATION_INSTANCE

Column(s)	OID
Tablespace	CATALOG_INDX

Index Details

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

IX_OTIN_OFFE

Indexed Column(s)	OFFE_OID
Unique	No
Partitioned	No
Tablespace	CATALOG_INDX