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

LANGUAGE, TRANSACTION_SOURCE_ID, DOC_ENTRY_ID, DOCUMENT_ID

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     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.    

Copyright © 2019, 2023, Oracle and/or its affiliates.