| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Alternate Item A | Alternate name for the item. | Inventory Summary.Alternate Item A | ALTERNATE_ITEMA | ALTERNATE_ITEMA | 115778 |
| Alternate Item B | Second alternate name for the item. | Inventory Summary.Alternate Item B | ALTERNATE_ITEMB | ALTERNATE_ITEMB | 115779 |
| Company Code | Company code of the organization. | Inventory Summary.Company Code | CO_CODE | CO_CODE | 123978 |
| Created By | | Inventory Summary.Created By | CREATED_BY | CREATED_BY | 125190 |
| Creation Date | | Inventory Summary.Creation Date | CREATION_DATE | CREATION_DATE | 126617 |
| Grade | QC grade of the lot. | Inventory Summary.Grade | QC_GRADE | QC_GRADE | 157149 |
| Grade Description | Description of the QC grade. | Inventory Summary.Grade Description | QC_GRADE_DESC | QC_GRADE_DESC | 157158 |
| Intransit Quantity | Not currently used. | Inventory Summary.Intransit Quantity | INTRANSIT_QTY | INTRANSIT_QTY | 137138 |
| Intransit Quantity in secondary UOM | Not currently used. | Inventory Summary.Intransit Quantity in secondary UOM | NTRANSIT_QTY2 | NTRANSIT_QTY2 | 148697 |
| Item Description | Short description of the item that is displayed during the item look up. | Inventory Summary.Item Description | ITEM_DESCRIPTION | ITEM_DESCRIPTION | 137739 |
| Item ID | Surrogate key for the item for which results are recorded. | Inventory Summary.Item ID | ITEM_ID | ITEM_ID | 137777 |
| Item Number | Name of the item. | Inventory Summary.Item Number | ITEM_NO | ITEM_NO | 137820 |
| Last Updated By | | Inventory Summary.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139770 |
| Last Updated Date | | Inventory Summary.Last Updated Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 141144 |
| On-hand Quantity | Total nettable qty of this item/grade in this warehouse, expressed in the primary unit of measure of an item. | Inventory Summary.On-hand Quantity | ONHAND_QTY | ONHAND_QTY | 149407 |
| On-hand Quantity in Secondary UOM | Total nettable qty of this item/grade in this warehouse, expressed in the secondary unit of measure of an item, if dual UOM controlled. | Inventory Summary.On-hand Quantity in Secondary UOM | ONHAND_QTY2 | ONHAND_QTY2 | 149408 |
| Organization Code | | Inventory Summary.Organization Code | ORGN_CODE | ORGN_CODE | 150813 |
| Pending Production Quantity | Total qty of product pending from production, expressed in the primary UOM of an item. | Inventory Summary.Pending Production Quantity | PRODUCTION_PENDING_QTY | PRODUCTION_PENDING_QTY | 155852 |
| Pending Production Quantity in Secondary UOM | Total qty of product pending from production, expressed in the secondary UOM of an item. | Inventory Summary.Pending Production Quantity in Secondary UOM | PRODUCTION_PENDING_QTY2 | PRODUCTION_PENDING_QTY2 | 155853 |
| Pending Purchase Quantity | Total qty pending from purchase orders, expressed in the primary UOM of an item. | Inventory Summary.Pending Purchase Quantity | ONPURCH_QTY | ONPURCH_QTY | 149426 |
| Pending Purchase Quantity in Secondary UOM | Total qty pending from purchase orders, expressed in the secondary UOM of an item if dual UOM controlled. | Inventory Summary.Pending Purchase Quantity in Secondary UOM | ONPURCH_QTY2 | ONPURCH_QTY2 | 149427 |
| Planning Class | Planning class for an item. Used for MPS and MRP reporting. | Inventory Summary.Planning Class | PLANNING_CLASS | PLANNING_CLASS | 154233 |
| Primary UOM | Uom of the item by which the inventory balances are maintained. | Inventory Summary.Primary UOM | ITEM_UOM | ITEM_UOM | 137933 |
| Quantity Available to Ship | Total qty available for shipping, expressed in the primary UOM of an item. | Inventory Summary.Quantity Available to Ship | ONHAND_SHIP_QTY | ONHAND_SHIP_QTY | 149411 |
| Quantity Available to Ship in Secondary UOM | Total qty available for shipping, expressed in the secondary UOM of an item, if dual UOM controlled. | Inventory Summary.Quantity Available to Ship in Secondary UOM | ONHAND_SHIP_QTY2 | ONHAND_SHIP_QTY2 | 149412 |
| Quantity Committed for Production | Total qty of ingredient committed to batches, expressed in the primary UOM of an item. | Inventory Summary.Quantity Committed for Production | COMMITTED_PRODUCTION_QTY | COMMITTED_PRODUCTION_QTY | 122669 |
| Quantity Committed for Production in Secondary UOM | Total qty of ingredient committed to batches, expressed in the secondary UOM of an item if dual UOM controlled. | Inventory Summary.Quantity Committed for Production in Secondary UOM | COMMITTED_PRODUCTION_QTY2 | COMMITTED_PRODUCTION_QTY2 | 122670 |
| Quantity Nettable for Production | Total qty available for use as a production ingredient, expressed in the primary UOM of an item. | Inventory Summary.Quantity Nettable for Production | ONHAND_PRODUCTION_QTY | ONHAND_PRODUCTION_QTY | 149405 |
| Quantity Nettable for Production in Secondary UOM | Total qty available for use as a production ingredient, expressed in the secondary UOM of an itemif dual UOM controlled. | Inventory Summary.Quantity Nettable for Production in Secondary UOM | ONHAND_PRODUCTION_QTY2 | ONHAND_PRODUCTION_QTY2 | 149406 |
| Quantity committed for sales | Total qty committed to sales orders and shipments, expressed in the primary UOM of an item. | Inventory Summary.Quantity committed for sales | COMMITTED_SALES_QTY | COMMITTED_SALES_QTY | 122671 |
| Quantity committed for sales in Secondary UOM | Total qty committed to sales orders and shipments, expressed in the secondary UOM of an item if dual UOM controlled. | Inventory Summary.Quantity committed for sales in Secondary UOM | COMMITTED_SALES_QTY2 | COMMITTED_SALES_QTY2 | 122672 |
| Quanttiy Available to order | Total qty available for ordering, expressed in the primary UOM of an item. | Inventory Summary.Quanttiy Available to order | ONHAND_ORDER_QTY | ONHAND_ORDER_QTY | 149403 |
| Quanttiy Available to order in secondary UOM | Total qty available for ordering, expressed in the secondary UOM of an item, if dual UOM controlled. | Inventory Summary.Quanttiy Available to order in secondary UOM | ONHAND_ORDER_QTY2 | ONHAND_ORDER_QTY2 | 149404 |
| Secondary UOM | Second UOM for in which inventory balances are maintained, for dual UOM items. | Inventory Summary.Secondary UOM | ITEM_UOM2 | ITEM_UOM2 | 137947 |
| Warehouse Code | Warehouse from which the item was taken. | Inventory Summary.Warehouse Code | WHSE_CODE | WHSE_CODE | 167773 |
| Warehouse Name | Name of the warehouse. | Inventory Summary.Warehouse Name | WAREHOUSE_NAME | WAREHOUSE_NAME | 167708 |