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 |