Open Items by Stock Number Inquiry (OISN)

Open Items by Stock Number Inquiry (OISN) provides a means of tracking which transfers and stock requisitions make up the sum total of the amount fields on Inventory Inquiry (INVN). Records are added to this screen for each line of an accepted Stock Requisition (SR), Over the Counter (OC), or Stock Transfer Issue (TI) document.

The Quantities fields are inferred from Open Stock Requisition Line Inquiry (OSRC) for Stock Requisition (SR) and Over the Counter (OC) documents. For the Stock Transfer Issue (TI) document, these fields are inferred from Open Stock Transfer Receipt Line Inquiry (OTRL).

Records are deleted from this table when the Inventory Subsystem Table Purge offline program is run. For more information on the Inventory Subsystem Table Purge offline program, see the System Administration Guide .


Stock Number	Key field. Enter the stock item from Open Stock Requisition Line Inquiry (OSRC) or Open Stock Transfer Receipt Line Inquiry (OTRL).
Transaction ID	Key field. Enter the transaction ID from the Stock Requisition (SR), Over the Counter (OC), or Stock Transfer Issue (TI) document.
Line Number	Key field. Enter the number of this line from the document.
Warehouse	Display only. On Stock Requisition (SR) and Over the Counter (OC) documents, the warehouse is inferred from Open Stock Requisition Header Inquiry (OSRH). For Stock Transfer Issue (TI) documents, the warehouse is inferred from Open Stock Transfer Receipt Header Inquiry (OTRH).
Reference Transaction ID	Display only. This field is inferred from Open Stock Requisition Item Issue Inquiry (OSRI) for Stock Requisition (SR) and Over the Counter (OC) documents.
Quantities
Requested	Display only. The quantity requested from the document is inferred from Open Stock Requisition Line Inquiry (OSRC) or Open Stock Transfer Receipt Line Inquiry (OTRL).
Backordered	Display only. The quantity of the stock item that is not reserved due to insufficient inventory is inferred from Open Stock Requisition Line Inquiry (OSRC).
Released	Display only. The quantity of the stock item that was printed on a pick and issue document but not issued is inferred from Open Stock Requisition Line Inquiry (OSRC).
Reserved	Display only. The quantity of the stock item that is processed for a pick and issue but not yet printed on a pick and issue document is inferred from Open Stock Requisition Line Inquiry (OSRC).
Issued	Display only. The quantity of the stock item issued to date is inferred from Open Stock Requisition Line Inquiry (OSRC) or Open Stock Transfer Receipt Line Inquiry (OTRL).