IV00102 - Item Quantity Master
Tracks quantities on hand, returned, in-use, in-service, and damaged for each item. Contains both overall and site-specific records.
SQL Query Builder
78 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| ITEMNMBR | Item Number | String | 32 | ||
| LOCNCODE | Location Code | String | 12 | ||
| BINNMBR | Bin Number | String | 22 | ||
| RCRDTYPE | Record Type | Integer | 2 | ||
Record Type (Quantity Master) values (2) 1 = Overall (all sites)2 = Site-specific | |||||
| PRIMVNDR | Primary Vendor | String | 16 | ||
| ITMFRFLG | Item Freeze Flag | Boolean | 2 | ||
| BGNGQTY | Beginning QTY | Currency | 10 | ||
| LSORDQTY | Last ORD QTY | Currency | 10 | ||
| LRCPTQTY | Last RCPT QTY | Currency | 10 | ||
| LSTORDDT | Last ORD Date | Date | 4 | ||
| LSORDVND | Last ORD Vendor | String | 16 | ||
| LSRCPTDT | Last RCPT Date | Date | 4 | ||
| QTYRQSTN | QTY Requisitioned | Currency | 10 | ||
| QTYONORD | QTY On Order | Currency | 10 | ||
| QTYBKORD | QTY Back Ordered | Currency | 10 | ||
| QTY_Drop_Shipped | QTY Drop Shipped | Currency | 10 | ||
| QTYINUSE | QTY In Use | Currency | 10 | ||
| QTYINSVC | QTY In Service | Currency | 10 | ||
| QTYRTRND | QTY Returned | Currency | 10 | ||
| QTYDMGED | QTY Damaged | Currency | 10 | ||
| QTYONHND | QTY On Hand | Currency | 10 | ||
| ATYALLOC | QTY Allocated | Currency | 10 | ||
| QTYCOMTD | QTY Committed | Currency | 10 | ||
| QTYSOLD | QTY Sold | Currency | 10 | ||
| NXTCNTDT | Next Count Date | Date | 4 | ||
| NXTCNTTM | Next Count Time | Time | 4 | ||
| LSTCNTDT | Last Count Date | Date | 4 | ||
| LSTCNTTM | Last Count Time | Time | 4 | ||
| STCKCNTINTRVL | Stock Count Interval | Integer | 2 | ||
| Landed_Cost_Group_ID | Landed Cost Group ID | String | 16 | ||
| BUYERID | Buyer ID | String | 16 | ||
| PLANNERID | Planner ID | String | 16 | ||
| ORDERPOLICY | Order Policy1 – Not planned2 – Lot for Lot3 – Fixed Order Quantity4 – Period Order Quantity5 – Order Point6 – Manually Planned (Removed for version 10.0) | Integer | 2 | ||
Order Policy values (6) 1 = Not planned2 = Lot for Lot3 = Fixed Order Quantity4 = Period Order Quantity5 = Order Point6 = Manually Planned | |||||
| FXDORDRQTY | Fixed Order Qty | Currency | 10 | ||
| ORDRPNTQTY | Order Point Qty | Currency | 10 | ||
| NMBROFDYS | Number of Days | Integer | 2 | ||
| MNMMORDRQTY | Minimum Order Qty | Currency | 10 | ||
| MXMMORDRQTY | Maximum Order Qty | Currency | 10 | ||
| ORDERMULTIPLE | Order Multiple | Currency | 10 | ||
| REPLENISHMENTMETHOD | Replenishment Method1 – Make2 – Buy3- Make or Buy | Integer | 2 | ||
| SHRINKAGEFACTOR | Shrinkage Factor | Currency | 10 | ||
| PRCHSNGLDTM | Purchasing Lead Time | Currency | 10 | ||
| MNFCTRNGFXDLDTM | Manufacturing Fixed Lead Time | Currency | 10 | ||
| MNFCTRNGVRBLLDTM | Manufacturing Variable Lead Time | Currency | 10 | ||
| STAGINGLDTME | Staging Lead Time | Currency | 10 | ||
| PLNNNGTMFNCDYS | Planning Time Fence Days | Integer | 2 | ||
| DMNDTMFNCPRDS | Demand Time Fence Periods | Integer | 2 | ||
| INCLDDINPLNNNG | Included in Planning | Boolean | 2 | ||
| CALCULATEATP | Calculate ATP | Boolean | 2 | ||
| AUTOCHKATP | Auto Check ATP | Boolean | 2 | ||
| PLNFNLPAB | Plan Final PAB | Boolean | 2 | ||
| FRCSTCNSMPTNPRD | Forecast Consumption Period1 – Days2 – Weeks3 – Months | Integer | 2 | ||
| ORDRUPTOLVL | Order Up To Level | Currency | 10 | ||
| SFTYSTCKQTY | Safety Stock Qty | Currency | 10 | ||
| REORDERVARIANCE | Reorder Variance | Currency | 10 | ||
| PORECEIPTBIN | Purchase Receipt Bin | String | 16 | ||
| PORETRNBIN | Purchase Returns Bin | String | 16 | ||
| SOFULFILLMENTBIN | SO Fulfillment Bin | String | 16 | ||
| SORETURNBIN | SO Return Bin | String | 16 | ||
| BOMRCPTBIN | BOM Receipt Bin | String | 16 | ||
| MATERIALISSUEBIN | Material Issues Bin | String | 16 | ||
| MORECEIPTBIN | MO Receipt Bin | String | 16 | ||
| REPAIRISSUESBIN | Repair Issues Bin | String | 16 | ||
| ReplenishmentLevel | Replenishment Level | Integer | 2 | ||
| POPOrderMethod | POP Order Method | Integer | 2 | ||
| MasterLocationCode | Master Location Code | String | 12 | ||
| POPVendorSelection | POP Vendor Selection | Integer | 2 | ||
| POPPricingSelection | POP Pricing Selection | Integer | 2 | ||
| PurchasePrice | Purchase Price | Currency | 10 | ||
| IncludeAllocations | Include Allocations | Boolean | 2 | ||
| IncludeBackorders | Include Backorders | Boolean | 2 | ||
| IncludeRequisitions | Include Requisitions | Boolean | 2 | ||
| PICKTICKETITEMOPT | Picking Ticket Item Option | Integer | 2 | ||
| INCLDMRPMOVEIN | IncludeMRPMoveIn | Boolean | 2 | ||
| INCLDMRPMOVEOUT | IncludeMRPMoveOut | Boolean | 2 | ||
| INCLDMRPCANCEL | IncludeMRPCancel | Boolean | 2 | ||
| Move_Out_Fence | Move-Out Fence | Integer | 2 | ||
| INACTIVE | Inactive | Boolean | 2 | ||
Active Status values (2) 0 = Active1 = Inactive | |||||
Reporting Tips
- - RCRDTYPE=1 is the overall record (all sites), RCRDTYPE=2 is site-specific
- - General record is created when item is set up; site records added when assigned to sites
Related Tables
Tables that share columns with IV00102. Click "Join" to add to your query.