This table requires activation of Time and Labor functional area. Loads data for OTL document type translation
Module: Time and Labor
DOCUMENT_ID, DOC_ENTRY_ID, TRANSACTION_SOURCE_ID, LANGUAGE
| 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. |
Copyright © 2019, 2024, Oracle and/or its affiliates.