This table contains the details of the inventory item
Module:
INVENTORY_ITEM_ID, ORGANIZATION_ID
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. | ||||
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 |