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_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, 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 | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | 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 | 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 | 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. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_DOCUMENTS_TL_N1_ | Non Unique | Default | DOCUMENT_ID, LANGUAGE, ENTERPRISE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY |