FND_DOCUMENTS_TL

This table contains the columns that require translation.

Details

  • Schema: ATTACHMENTS

  • Object owner: FND

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FND_DOCUMENTS_TL_PK

DOCUMENT_ID, LANGUAGE, ENTERPRISE_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
DOCUMENT_ID NUMBER 18 Yes The documents tl table.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
DESCRIPTION VARCHAR2 255 DESCRIPTION
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_APPLICATION_ID NUMBER 18 PROGRAM_APPLICATION_ID
PROGRAM_ID NUMBER 18 PROGRAM_ID
PROGRAM_UPDATE_DATE DATE PROGRAM_UPDATE_DATE
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
TITLE VARCHAR2 80 TITLE
DM_VERSION_NUMBER VARCHAR2 255 DM_VERSION_NUMBER
URL VARCHAR2 4000 URL
DM_NODE NUMBER 18 DM_NODE
DM_FOLDER_PATH VARCHAR2 4000 DM_FOLDER_PATH
DM_DOCUMENT_ID VARCHAR2 255 DM_DOCUMENT_ID
DM_REPOSITORY VARCHAR2 80 DM_REPOSITORY
FILE_NAME VARCHAR2 2048 FILE_NAME
DM_TYPE VARCHAR2 30 DM_TYPE
STATUS VARCHAR2 30 STATUS
DOWNLOAD_STATUS VARCHAR2 1 Yes DOWNLOAD_STATUS
URI VARCHAR2 4000 URI (Uniform Resource Identifier) appended to the base URI derived from the endpoint associated with application identified by the MODULE_ID.
ENT_APP_SHORT_NAME VARCHAR2 80 Foreign key to the ASK_ENTERPRISE_APPLICATIONS table. It is used to identify the application used for Topology Managed attachments.
TRUSTED_FLAG VARCHAR2 1 Trusted state of the content.
OBJECT_BUCKET VARCHAR2 256 Name of the bucket that stores the file in the Object Store.
OBJECT_NAME VARCHAR2 1024 Name of the file in the Object Store
OBJECT_SIZE NUMBER 18 Size in bytes of the Object Store file.
OBJECT_CONTENT_TYPE VARCHAR2 257 Type of the file being uploaded, using the MIME type assigned.
TRACKER_ID VARCHAR2 40 Public Identifier used to synchronize the upload of the file and the attachment it is associated with.
CEC_PARENT_ID VARCHAR2 255 The identifier of the parent folder of the file in Oracle Content and Experience Cloud.
CEC_FILE_ID VARCHAR2 255 The identifier of the file in Oracle Content and Experience Cloud.
SOURCE_CONTENT_TYPE VARCHAR2 257 Original MIME type of the file being uploaded.

Indexes

Index Uniqueness Tablespace Columns
FND_DOCUMENTS_TL_F1 Non Unique FUSION_TS_TX_DATA UPPER("DESCRIPTION"), ENTERPRISE_ID
FND_DOCUMENTS_TL_F2 Non Unique Default ENT_APP_SHORT_NAME
FND_DOCUMENTS_TL_N1 Non Unique FUSION_TS_TX_DATA DESCRIPTION, ENTERPRISE_ID
FND_DOCUMENTS_TL_N2 Non Unique FUSION_TS_TX_DATA DM_DOCUMENT_ID
FND_DOCUMENTS_TL_U1 Unique Default DOCUMENT_ID, LANGUAGE, ENTERPRISE_ID