DW_INVENTORY_ITEM_D

This table contains the details of the inventory item

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.    
ORGANIZATION_ID NUMBER 38 0 True A organizing unit in the internal or external structure of your enterprise.    
SOURCE_RECORD_ID VARCHAR2 128     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.    
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.    
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.    
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. 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. 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.    
INVENTORY_ITEM_FLAG VARCHAR2 16     Attribute indicating whether the Item can be Stocked and transacted.    
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.    
RETURNABLE_FLAG VARCHAR2 16     Attribute indicating whether to allow customers to return an item.    
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.    
INVOICE_ENABLED_FLAG VARCHAR2 16     Attribute indicating whether to activate an item for invoicing in Oracle Receivables.    
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_EGP_LIFECYCLE_PHASE_LKP_TL EGP_LIFECYCLE_PHASE_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_YN_LKP_TL YN_LKP_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.    
INTERNAL_ORDER_FLAG VARCHAR2 16     Attribute indicating whether an item can be transferred internally.    
INTERNAL_ORDER_ENABLED_FLAG VARCHAR2 16     Attribute indicating whether to allow an item to be ordered on an internal requisition.    
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