DW_TNL_DOCUMENT_ENTRY_TL (Preview)

This table requires activation of Time and Labor functional area. Loads data for OTL document type translation

Details

Module: Time and Labor

Key Columns

DOC_ENTRY_ID, DOCUMENT_ID, TRANSACTION_SOURCE_ID, LANGUAGE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DOC_ENTRY_ID NUMBER 38 0 True Uniquely identifies the document entry row.
DOCUMENT_ID NUMBER 38 0 True ID of the parent document.
TRANSACTION_SOURCE_ID NUMBER 38 0 True Uniquely identifies the transactions source.
LANGUAGE VARCHAR2 16 True Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System Generated unique identifier
DOC_ENTRY_CODE VARCHAR2 32 Internally used Code. This is defaulted to DOC_ENTRY_ID for user-defined document entries.
DOC_ENTRY_NAME VARCHAR2 256 Name of the document entry.
DESCRIPTION VARCHAR2 999 Description
TRANSACTION_SOURCE VARCHAR2 32 Implementation-defined classification of a transaction loaded into PA from an external system. This is defaulted to TRANSACTION_SOURCE_ID for user-defined sources.