ENTRY_ID

NUMBER

Translation unique entry ID.

TABLE_ID

NUMBER

Translation unique table ID (the entry belongs to this table from the translation table definition).

TABLE_NAME

VARCHAR2(30)

Translation table name (from the translation table definition).

TABLE_TYPE

VARCHAR2(30)

Translation table type (from the translation table definition).

Legal values: RESOURCE, EVENT_TYPE, VALUE, SERVICE, CONTRACT_PARTY, TIME_ZONE.

TABLE_RETURN_
TYPE

VARCHAR2(10)

The translation returns a value with this type (from the translation table definition).

Legal values: INTEGER, STRING, FLOAT.

FIELD_NAME_1

VARCHAR2(50)

Name of the first input field (from the translation table definition).

FIELD_NAME_2

VARCHAR2(50)

Name of the second input field (from the translation table definition).

FIELD_NAME_3

VARCHAR2(50)

Name of the third input field (from the translation table definition).

FIELD_NAME_4

VARCHAR2(50)

Name of the fourth input field (from the translation table definition).

FIELD_NAME_5

VARCHAR2(50)

Name of the fifth input field (from the translation table definition).

FIELD_VALUE_1

VARCHAR2(256)

The value in the first field to be translated (from the translation entries).

FIELD_VALUE_2

VARCHAR2(256)

The value in the second field to be translated (from the translation entries).

FIELD_VALUE_3

VARCHAR2(256)

The value in the third field to be translated (from the translation entries).

FIELD_VALUE_4

VARCHAR2(256)

The value in the fourth field to be translated (from the translation entries).

FIELD_VALUE_5

VARCHAR2(256)

The value in the fifth field to be translated (from the translation entries).

STATUS

VARCHAR2(15)

The translation entry status.

Legal values: PENDING, TRANSLATED, IGNORED.

MANUAL_
TRANSLATION

CHAR(1)

Whether the user will do the translation.

Legal values: Y, N.

RESOURCE_ID

NUMBER

The resource ID that the entry was translated to.

Only for entries from table with TABLE_TYPE='RESOURCE'.

RESOURCE_NAME

VARCHAR2(100)

The resource name that the entry was translated to.

Only for entries from table with TABLE_TYPE='RESOURCE'.

EVENT_TYPE_ID

NUMBER

The event type ID that the entry was translated to.

Only for entries from table with TABLE_TYPE='EVENT_TYPE'.

EVENT_TYPE_
NAME

VARCHAR2(30)

The event type name that the entry was translated to.

Only for entries from table with TABLE_TYPE=’EVENT_TYPE’.

SERVICE_ID

NUMBER

The service ID that the entry was translated to.

Only for entries from table with TABLE_TYPE=SERVICE'.

SERVICE_NAME

VARCHAR2(30)

The service name that the entry was translated to.

Only for entries from table with TABLE_TYPE=’SERVICE’.

CONTRACT_
PARTY_ID

NUMBER

The service ID that the entry was translated to.

Only for entries from table with TABLE_TYPE=’CONTRACT_PARTY’.

CONTRACT_
PARTY_NAME

VARCHAR2(60)

The service name that the entry was translated to.

Only for entries from table with TABLE_TYPE=’CONTRACT_PARTY’.

TIMEZONE_ID

NUMBER

The time zone ID that the entry was translated to.

Only for entries from table with TABLE_TYPE=’TIMEZONE’.

TIMEZONE_NAME

VARCHAR2(30)

The time zone name the entry translated to.

Only for entries from table with TABLE_TYPE=’TIMEZONE’.

TRANSLATED_TO

VARCHAR2(100)

The translated value for entries from table with TABLE_TYPE='VALUE'.

CREATED_BY_
USER_ID

NUMBER

The ID of the user who created the entry. This field is null if the entry was created by an adapter.

CREATED_BY_
USER_NAME

VARCHAR2(30)

The name of the user who created the entry. This field is null if the entry was created by an adapter.

CREATED_BY_
ADAPTER_ID

NUMBER

The ID of the adapter that created the entry. This field is null if the entry was created manually.

CREATED_BY_
ADAPTER_NAME

VARCHAR2(30)

The name of the adapter that created the entry. This field is null if the entry was created manually.

LAST_ACTION_
DATE

DATE

The date that the entry was last activated manually.

CREATE_DATE

DATE

The date that the entry was created.

MODIFY_DATE

DATE

The date of the last time that the entry was updated.