DW_ITEM_STRUCTURES_D (Preview)
This table requires activation of Item Management functional area. This table stores item Structure details.
Details
Module: Product Hub
Key Columns
BILL_SEQUENCE_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| BILL_SEQUENCE_ID | NUMBER | 38 | 0 | True | Bill of material Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Source Record Identifier | ||||
| 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 | ||
| COMMON_BILL_SEQUENCE_ID | NUMBER | 38 | 0 | Common Bill of Material Identifier | |||
| STRUCTURE_NAME | VARCHAR2 | 128 | Structure Name | ||||
| STRUCTURE_DESCRIPTION | VARCHAR2 | 256 | Structure Description | ||||
| CREATION_DATE | TIMESTAMP | Structure Creation Timestamp | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Structure Last Update Timestamp |