# DW_ITEM_ATTACHMENTS_D (Preview)

This table requires activation of Item Management functional area. This table stores attachment details for both Item & Item Revision Level. If ENTITY_NAME is 'ITEM_ENTITY' then Item Attachments ,ENTITY_NAME is 'ITEM_REVISION_ENTITY then item revision Attachments.

## Details

Module: Product Hub

## Key Columns

ATTACHED_DOCUMENT_ID, ENTERPRISE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ATTACHED_DOCUMENT_ID | NUMBER | 38 | 0 | True | Attachment Document Identifier |  |
ENTERPRISE_ID | NUMBER | 38 | 0 | True | Enterprise Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source Record Identifier |  |
DOCUMENT_ID | NUMBER | 38 | 0 |  | Document Identifier #1 | DW_DOCUMENTS_D_TL | DOCUMENT_ID
ENTITY_NAME | VARCHAR2 | 64 |  |  | Entity name |  |
INVENTORY_ITEM_ID | VARCHAR2 | 256 |  |  | Inventory Item Identifier | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID_CHAR
ORGANIZATION_ID | VARCHAR2 | 256 |  |  | Organization Identifier | DW_INVENTORY_ITEM_D | ORGANIZATION_ID_CHAR
REVISION_ID | VARCHAR2 | 256 |  |  | Revision Identifier | DW_ITEM_REVISIONS_D | REVISION_ID_CHAR
CREATION_DATE | TIMESTAMP |  |  |  | Attachment Creation Timestamp |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Attachment Last Update Timestamp |  |

## Notes

#1 In these cases to join with DW_DOCUMENTS_D_TL apart from DOCUMENT_ID the relationship should be based on ENTERPRISE_ID column

Copyright © 2019, 2025, Oracle and/or its affiliates.