TRANSLATION

Table: TRANSLATION_TABLE

Table Name

TRANSLATION_TABLE

Table Description

The TRANSLATION_TABLE table contains information about translation table.

Tablespace

CATALOG_DATA

Database

Columns

The TRANSLATION_TABLE database table is defined by the following columns.

Value Type	BIGINT, NOT NULL
Key(s)	Primary Key: PK_TRANSLATION_TABLE
Column Description	The translation table unique id. It is generated by the system.

Value Type	VARCHAR(256), NOT NULL
Index(es)	IX_TT_CODE
Column Description	The code of the translation table.

Value Type	VARCHAR(2000)
Column Description	The description of the translation table.

Value Type	VARCHAR(64), NOT NULL
Index(es)	IX_TT_OWNER
Column Description	The owner of the translation table.

Value Type	DECIMAL(1)
Default Value	0
Column Description	The USE_DATES field indicates if the translation table uses dates or not. Possible values are: 1: The translation table uses dates 0: Otherwise

Value Type

DECIMAL(1)

Default Value

Column Description

The USE_DATES field indicates if the translation table uses dates or not.

Possible values are:

Value Type	DECIMAL(1)
Default Value	1
Column Description	The DISABLE_DUPLICATE field indicates if rows with duplicate values for all input attributes are authorized in the translation table. Possible values are: 1: Duplicate values authorized 0: Otherwise

Value Type

DECIMAL(1)

Default Value

Column Description

The DISABLE_DUPLICATE field indicates if rows with duplicate values for all input attributes are authorized in the translation table.

Possible values are:

Document Version: SP04 and later