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 |