# DW_INVENTORY_ITEM_D

This table contains the details of the inventory item. This table contains historical action records for various items. However, these records can be excluded for items marked as production (ACD_TYPE = 'PROD').

## Details

Module:

## Key Columns

ORGANIZATION_ID, INVENTORY_ITEM_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | True | Unique identifier for an item. | DW_INVENTORY_ITEM_D_TL | INVENTORY_ITEM_ID
ORGANIZATION_ID | NUMBER | 38 | 0 | True | A organizing unit in the internal or external structure of your enterprise. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record id based on concatenation of INVENTORY_ITEM_ID and ORGANIZATION_ID |  |
ITEM_NUMBER | VARCHAR2 | 512 |  |  | Identifier of the Item. |  |
BASE_ITEM_ID | NUMBER | 38 | 0 |  | Attribute indicating the Model from which an ATO configuration was created. #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ITEM_TYPE | VARCHAR2 | 32 |  |  | Indicator or classification for an item, such as finished or purchased. | DW_EGP_ITEM_TYPE_LKP_TL | EGP_ITEM_TYPE_CODE
SOURCE_SUBINVENTORY | VARCHAR2 | 16 |  |  | Attribute indicating the sub inventory from which an internal requisition draws the item. |  |
APPROVAL_STATUS | VARCHAR2 | 32 |  |  | The Approval Status of the Item. | DW_EGP_APPROVAL_STATUS_LKP_TL | EGP_APPROVAL_STATUS_CODE
START_DATE_ACTIVE | TIMESTAMP |  |  |  | The date on which a task, event or business process begins. |  |
END_DATE_ACTIVE | TIMESTAMP |  |  |  | Date on which Item is inactivated |  |
FIXED_ORDER_QUANTITY | NUMBER |  |  |  | Attribute indicating the quantity used to modify the size of planned order quantities or repetitive daily rates |  |
HAZARD_CLASS_ID | NUMBER | 38 | 0 |  | Attribute indicating the category of Hazard material for International trade. | DW_HAZARD_CLASSES_TL | HAZARD_CLASS_ID
ORDER_COST | NUMBER |  |  |  | Attribute indicating the fixed cost associated with placing an order for the item. |  |
PRIMARY_UOM_CODE | VARCHAR2 | 16 |  |  | The principal unit of measure in which the quantity of an item is managed. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
SERIAL_NUMBER_CONTROL_CODE | NUMBER |  |  |  | Attribute indicating number assigned to each unit of an item and used to track the item. | DW_EGP_SERIAL_NUMBER_CONTROL_TYPE_LKP_TL | EGP_SERIAL_NUMBER_CONTROL_TYPE_CODE
VOLUME_UOM_CODE | VARCHAR2 | 16 |  |  | Attribute indicating Volume Unit of Measure. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
WEIGHT_UOM_CODE | VARCHAR2 | 16 |  |  | Attribute indicating Weight Unit of Measure. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
UNIT_VOLUME | NUMBER |  |  |  | Attribute Indicating Volume of One Unit of Item. |  |
UNIT_WEIGHT | NUMBER |  |  |  | Attribute Indicating Weight of One Unit of Item. |  |
PARENT_ITEM_CLASS_ID | NUMBER | 38 | 0 |  | Parent item class identifier. |  |
PARENT_ITEM_CLASS_ID_CHAR | VARCHAR2 | 64 |  |  | Parent item class identifier (in char datatype). | DW_ITEM_CLASS_LKP_TL | ITEM_CLASS_LKP_CODE
ITEM_CLASS_ID | NUMBER | 38 | 0 |  | Item class identifier from which the attribute group is inherited. |  |
ITEM_CLASS_ID_CHAR | VARCHAR2 | 64 |  |  | Item class identifier from which the attribute group is inherited (in char datatype). | DW_ITEM_CLASS_LKP_TL | ITEM_CLASS_LKP_CODE
MINIMUM_ORDER_QUANTITY | NUMBER |  |  |  | Attribute indicating Minimum Order quantity of the Item. |  |
MAXIMUM_ORDER_QUANTITY | NUMBER |  |  |  | Attribute indicating Maximum Order quantity of the Item. |  |
STD_LOT_SIZE | NUMBER |  |  |  | The amount of a particular item that is ordered from the plant or a supplier or issued as a standard quantity to the production process. |  |
SHELF_LIFE_DAYS | NUMBER |  |  |  | Attribute indicating number of days each lot is active. |  |
UNIT_OF_ISSUE | VARCHAR2 | 32 |  |  | Attribute indicating Unit of measure used for issuing the item from inventory. |  |
PLANNER_CODE | VARCHAR2 | 16 |  |  | Attribute indicating the material planner for the item. |  |
MRP_PLANNING_CODE | NUMBER |  |  |  | Attribute indicating the organization level planning for the Item. Choices -Min-Max,Not Planned, Reorder Point. | DW_EGP_PLANNING_CODE_LKP_TL | EGP_PLANNING_CODE
ENABLED_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating the item class is enabled for use. |  |
CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether an item is currently customer orderable. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
INVENTORY_ITEM_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether the Item can be Stocked and transacted. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
PROCESS_QUALITY_ENABLED_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether to use the process manufacturing quality module with this item. |  |
PURCHASING_ENABLED_FLAG | VARCHAR2 | 16 |  |  | Attribute which determines whether the item can be added in to a purchase order. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
RETURNABLE_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether to allow customers to return an item. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
SERVICEABLE_PRODUCT_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether the item is eligible to be covered by a service contract. |  |
INVOICEABLE_ITEM_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether to include an item on an Oracle Receivables invoice. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
INVOICE_ENABLED_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether to activate an item for invoicing in Oracle Receivables. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
PLANNING_TIME_FENCE_DAYS | NUMBER |  |  |  | Attribute indicating the optional day added to the planning time fence when planning time fence is User defined. |  |
FULL_LEAD_TIME | NUMBER |  |  |  | Attribute indicating the days required to procure or manufacture an item. |  |
CUM_MANUFACTURING_LEAD_TIME | NUMBER |  |  |  | Attribute indicating the manufacturing lead time of an assembly (in days) plus the largest adjusted cumulative manufacturing lead time of its components, where each is adjusted by subtracting the operation lead time offset. |  |
FIXED_LEAD_TIME | NUMBER |  |  |  | Attribute indicating the days required to make an assembly independent of order quantity, such as setup or tear down time. |  |
VARIABLE_LEAD_TIME | NUMBER |  |  |  | Attribute indicating time to produce one additional unit of an assembly. |  |
CUMULATIVE_TOTAL_LEAD_TIME | NUMBER |  |  |  | Attribute indicating the total lead time of the assembly plus the largest adjusted cumulative total lead time of its components, where each is adjusted by subtracting the operation lead time offset. |  |
POSTPROCESSING_LEAD_TIME | NUMBER |  |  |  | Attribute indicating the days required to receive a purchased item into inventory from the initial supplier receipt. |  |
PREPROCESSING_LEAD_TIME | NUMBER |  |  |  | Attribute indicating the days which must be added to purchasing or manufacturing lead time to place an order. |  |
INVENTORY_ITEM_STATUS_CODE | VARCHAR2 | 16 |  |  | Code used to control the transaction activity of an item. | DW_ITEM_STATUS_LKP_TL | ITEM_STATUS_LKP_CODE
CURRENT_PHASE_CODE | VARCHAR2 | 128 |  |  | Each phase represents a set of tasks and deliverables that are required before promoting the object to the next phase of the Item Lifecycle. Possible values are Concept, Design, Prototype, Preproduction etc | DW_ITEM_PHASE_LKP_TL | ITEM_PHASE_LKP_CODE
PLANNING_MAKE_BUY_CODE | NUMBER |  |  |  | Attribute indicating whether the item is usually manufactured or bought. | DW_EGP_PLANNING_TYPE_LKP_TL | EGP_PLANNING_TYPE_CODE
MUST_USE_APPROVED_VENDOR_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether to use only approved suppliers. Possible values are Y,N. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
MIN_MINMAX_QUANTITY | NUMBER |  |  |  | Attribute indicating the minimum qty for Min-Max Planning. |  |
MAX_MINMAX_QUANTITY | NUMBER |  |  |  | Attribute indicating the maximum qty for Min-Max Planning. |  |
BACK_TO_BACK_ENABLED | VARCHAR2 | 16 |  |  | Indicates that an item is enabled for back-to-back ordering. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
INTERNAL_ORDER_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether an item can be transferred internally. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
INTERNAL_ORDER_ENABLED_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether to allow an item to be ordered on an internal requisition. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
CURRENT_PHASE_START_DATE | DATE |  |  |  | Indicates the date when current phase of the item becomes active. |  |
CURRENT_PHASE_TYPE | VARCHAR2 | 32 |  |  | One of the four seeded Lifecycle Phases. It can be either of Design, Prototype or Preproduction, Production, and End of Life. | DW_EGP_LIFECYCLE_PHASE_LKP_TL | EGP_LIFECYCLE_PHASE_CODE
OUTSIDE_PROCESS_SERVICE_FLAG | VARCHAR2 | 16 |  |  | This attribute indicates whether the item can be added to a outside processing purchase order | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
CONTRACT_MANUFACTURING | VARCHAR2 | 16 |  |  | Indicates that the item is used in contract manufacturing | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
INVENTORY_ITEM_ID_CHAR | VARCHAR2 | 64 |  |  | Unique identifier for an item (in char datatype). |  |
ORGANIZATION_ID_CHAR | VARCHAR2 | 64 |  |  | A organizing unit in the internal or external structure of your enterprise (in char datatype). |  |
BOM_ITEM_TYPE | NUMBER |  |  |  | Attribute indicating the type of bill of Material the Item can possess such as standard, model, planning, and other. | DW_BOM_ITEM_TYPE_LKP_TL | BOM_ITEM_TYPE_CODE
EFFECTIVITY_CONTROL | NUMBER |  |  |  | Attribute indicating the way to calculate lead time from the either of the choices - Date, Model/Unit Number | DW_EGP_BOM_EFFEC_CTRL_LKP_TL | EGP_BOM_EFFEC_CTRL_CODE
ENGINEERED_ITEM_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating item is designed and engineered using product development application | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
ACD_TYPE | VARCHAR2 | 32 |  |  | Values ADD/UPDATE/DELETE/HISTORY | DW_EGO_ACD_TYPES_LKP_TL | EGO_ACD_TYPES_CODE
ITEM_OBJECT_TYPE | VARCHAR2 | 512 |  |  | Indicates the type of item object. | DW_ORA_EGP_ITEM_OBJECT_TYPE_LKP_TL | ORA_EGP_ITEM_OBJECT_TYPE_CODE
SECONDARY_UOM_CODE | VARCHAR2 | 16 |  |  | Attribute indicating the Secondary Unit of Measure through which the Item can be transacted. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Inventory Item Creation Timestamp |  |
CREATION_DATE | DATE |  |  |  | Inventory Item Creation Date | DW_DAY_D | CALENDAR_DATE
CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
PURCHASING_ITEM_FLAG | VARCHAR2 | 16 |  |  | Attribute which determines whether the Item is purchased and received | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
SHIPPABLE_ITEM_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether to ship an item to a customer. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
CUSTOMER_ORDER_FLAG | VARCHAR2 | 16 |  |  | Attribute Indicating whether to allow an item to be ordered by external customers. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
INVENTORY_ASSET_FLAG | VARCHAR2 | 16 |  |  | Indicate whether to value an item as an asset in inventory | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
SO_TRANSACTIONS_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether demand can be placed for an item by Oracle Order Management, and whether shipment transactions are interfaced to Oracle Inventory.This is a choice list. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
MTL_TRANSACTIONS_ENABLED_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether transaction can be performed on an item. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
STOCK_ENABLED_FLAG | VARCHAR2 | 16 |  |  | Attribute which determines whether Item can be stocked. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
BUILD_IN_WIP_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether to create discrete jobs or repetitive assemblies in Oracle Work in Process. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
REVISION_QTY_CONTROL_CODE | NUMBER |  |  |  | An attribute that tracks inventory by item revision and forces a revision to be specified for each material transaction | DW_EGP_COMMON_NO_YES_NUM_LKP_TL | EGP_COMMON_NO_YES_NUM_CODE
NEGOTIATION_REQUIRED_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether Negotiation is required or not. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
LOT_CONTROL_CODE | NUMBER |  |  |  | Attribute indicating the ability to use lot numbers during material transactions for tracking of batches of Item. | DW_INV_LOT_CONTROL_LKP_TL | INV_LOT_CONTROL_CODE
RESTRICT_SUBINVENTORIES_CODE | NUMBER |  |  |  | Attribute indicating whether to restrict transactions of this item to or from a subinventory specified | DW_EGP_COMMON_YES_NO_NUM_LKP_TL | EGP_COMMON_YES_NO_NUM_CODE
RESTRICT_LOCATORS_CODE | NUMBER |  |  |  | Attribute indicating whether to restrict transaction of this item to or from a locator specified | DW_EGP_COMMON_YES_NO_NUM_LKP_TL | EGP_COMMON_YES_NO_NUM_CODE
LOCATION_CONTROL_CODE | NUMBER |  |  |  | Attribute indicating the physical area within a subinventory where you store material, such as a row, aisle, bin,or shelf. | DW_EGP_LOCATOR_CONTROL_CODE_TYPE_LKP_TL | EGP_LOCATOR_CONTROL_CODE_TYPE_CODE
PLANNING_TIME_FENCE_CODE | NUMBER |  |  |  | Attribute indicating options to determine a point in time inside which certain restrictions on planning recommendations apply. | DW_EGP_TIME_FENCE_LKP_TL | EGP_TIME_FENCE_CODE
DEMAND_TIME_FENCE_CODE | NUMBER |  |  |  | Attribute indicating options to determine a point in time inside which certain restrictions on planning recommendations apply. | DW_EGP_TIME_FENCE_LKP_TL | EGP_TIME_FENCE_CODE
MRP_CALCULATE_ATP_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether to calculate and print available to promise (ATP) on the Planning Detail Report. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
DEMAND_TIME_FENCE_DAYS | NUMBER |  |  |  | Attribute indicating option to determine a point in time inside which the planning process ignores forecast demand and considers only sales order demand when calculating gross requirements. |  |
PICK_COMPONENTS_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether an item has a bill of material with options, classes, or included items picked from finished goods inventory | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
REPLENISH_TO_ORDER_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating is generally built for sales order demand; a final assembly work order is created based on sales order details | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
ATP_COMPONENTS_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether to include, in available to promise checking, additional components in the bill of material for ATO and PTO items. | DW_EGP_ORDATPCHECKVS_TYPE_LKP_TL | EGP_ORDATPCHECKVS_TYPE_CODE
ATP_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating to check available to promise and/or capable to promise information when placing demand. | DW_EGP_ORDATPCHECKVS_TYPE_LKP_TL | EGP_ORDATPCHECKVS_TYPE_CODE
INVENTORY_PLANNING_CODE | NUMBER |  |  |  | Attribute indicating the planning method to be used for the organization | DW_INV_MATERIAL_PLANNING_LKP_TL | INV_MATERIAL_PLANNING_CODE
FIXED_DAYS_SUPPLY | NUMBER |  |  |  | Attribute indicating the number of days used to modify the size and timing of planned order quantities. |  |
RESERVABLE_TYPE | NUMBER |  |  |  | Item attribute which enables to create material reservations for the item. | DW_EGP_COMMON_YES_NO_NUM_LKP_TL | EGP_COMMON_YES_NO_NUM_CODE
COSTING_ENABLED_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether to report, value and account for any item costs | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
CYCLE_COUNT_ENABLED_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether the item is on for automatic cycle count scheduling. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
RELEASE_TIME_FENCE_CODE | NUMBER |  |  |  | Attribute indicating an option to determine a point in time inside which planned orders for discretely planned items are automatically released as WIP jobs or purchase requisitions | DW_EGP_RELEASE_TIME_FENCE_LKP_TL | EGP_RELEASE_TIME_FENCE_CODE
RELEASE_TIME_FENCE_DAYS | NUMBER |  |  |  | Additional days added to the Release Time Fence |  |
DIMENSION_UOM_CODE | VARCHAR2 | 16 |  |  | Attribute indicating unit of measure for the dimension of the item. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
UNIT_LENGTH | NUMBER |  |  |  | Attribute Indicating Length of the Item |  |
UNIT_WIDTH | NUMBER |  |  |  | Attribute Indicating Width of the Item |  |
UNIT_HEIGHT | NUMBER |  |  |  | Attribute Indicating Height of the Item |  |
LOT_STATUS_ENABLED | VARCHAR2 | 16 |  |  | Attribute indicating whether an item is subject to status control at the Lot Level | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
SERIAL_STATUS_ENABLED | VARCHAR2 | 16 |  |  | Attribute indicating whether an item is subject to status control at the Serial Level | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
CREATE_SUPPLY_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating if the system can suggest supply for this item | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
CONSIGNED_FLAG | NUMBER |  |  |  | Attribute indicating the item is residing at your location, but owned by the supplier. | DW_EGP_COMMON_YES_NO_NUM_LKP_TL | EGP_COMMON_YES_NO_NUM_CODE
FORECAST_HORIZON | NUMBER |  |  |  | Period for which a forecast is considered by the Planning Engine. |  |
SAFETY_STOCK_PLANNING_METHOD | VARCHAR2 | 32 |  |  | Indicates the type of safety stock planning method to be used in planning. | DW_ORA_EGP_SAFETY_STK_PLN_METHOD_LKP_TL | ORA_EGP_SAFETY_STK_PLN_METHOD_CODE
DEMAND_PERIOD | NUMBER |  |  |  | Attribute that indicates the demand period. |  |
DAYS_OF_COVER | NUMBER |  |  |  | Attribute that indicates the number of days of cover. |  |
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Indicates the date and time of the last update of the row. |  |
ITEM_PACK_TYPE | VARCHAR2 | 64 |  |  | Trade Item Descriptor also known as Trade Item Unit Descriptor/Pack Type is used to describe the Global Trade Item Number (GTIN) hierarchy level. Hierarchy is used as link between different levels of a product (Item) logistical chain | DW_EGP_PACK_TYPE_LKP_TL | EGP_PACK_TYPE_CODE
IMPLEMENTATION_DATE | DATE |  |  |  | The date when an event will take place. |  |
ASSET_TRACKED_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating whether item is tracked as an asset in installed base | DW_ORA_EGP_ASSET_TRACKING_LKP_TL | ORA_EGP_ASSET_TRACKING_CODE
ALLOW_MAINTENANCE_ASSET_FLAG | VARCHAR2 | 16 |  |  | Attribute indicating that maintainable assets can be defined for the item. | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
COMPLETENESS_SCORE | NUMBER |  |  |  | Attribute indicating the completeness score of the item data |  |
ITEM_DEFINITION_ORG_ID | NUMBER | 38 | 0 |  | Indicates which organization serves as the definition for all items in this organization. If self-referential, it is a definition organization. If it points to any other organization, it is a reference organization. | DW_INTERNAL_ORG_D | ORGANIZATION_ID

## Notes

#1 In these cases to join with DW_INVENTORY_ITEM_D apart from INVENTORY_ITEM_ID the relationship should be based on ORGANIZATION_ID column

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