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
ENTERPRISE_ID, ATTACHED_DOCUMENT_ID
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