Open Stock Requisition Line Inquiry (OSRC)
Open Stock Requisition Line Inquiry (OSRC) stores information about each item line of all open and some recently closed Stock Requisition (SR) and Over the Counter (OC) documents such as item descriptive information, requested, backordered, reserved, released, and issued quantities, as well as item price.
A record is added to Open Stock Requisition Line Inquiry (OSRC) for each line of an accepted Stock Requisition (SR) or Over the Counter (OC) document. As modifications are submitted and accepted, records on the table are updated. The
Requested
,
Backordered
, and
Reserved Quantity
fields are updated by Stock Requisition (SR) and Over the Counter (OC) documents. The
Released Quantity
field is updated by the Pick and Issue (PI) document, and the
Issued Quantity
is updated by Issue Confirmation (CI) and Over the Counter (OC) documents.
Records are deleted by the Inventory Subsystem Table Purge offline program when their corresponding Open Stock Requisition Header Inquiry (OSRH) is closed for more days than the number of retention days indicated on Warehouse Management (WHS2). For more information on the Inventory Subsystem Table Purge program, see the
System Administration Guide
.
|
|
|
|
Transaction ID
|
Key field. Enter the unique number assigned to this document.
|
|
Line Number
|
Key field. Enter the number of the stock requisition item line.
|
|
Stock Item
|
Display only. The item code for the stock item from the document is displayed.
|
|
Issue Unit
|
Display only. The unit of measure used to issue this stock item is displayed.
|
|
Description
|
Display only. The description for this item line is inferred from Inventory Inquiry (INVN).
|
|
Reference Account Line
|
Display only. The number of the stock requisition item line from the document is displayed.
|
|
Job Type
|
Display only. If the Work Order Subsystem is installed, the job type for this stock item is displayed.
|
|
Unit Price
|
Display only. The price for one unit of the stock item requested is displayed.
|
|
Total Price
|
Display only. The computed price of this item line is displayed. (
Unit Price
multiplied by
Requested Quantity
).
|
|
Previous Backorder
|
Display only. If
Yes [Y]
is displayed, this item was previously backordered and now the order is filled. If
No [N]
is displayed, the item was not previously backordered.
|
Quantities
|
|
Requested
|
Display only. The quantity requested from the document is displayed.
|
|
Reserved
|
Display only. The quantity of the stock item that is processed for pick and issue but not yet printed on a Pick and Issue (PI) document is displayed.
|
|
Released
|
Display only. The quantity of the stock item that was printed on a Pick and Issue (PI) document, but not yet issued is displayed.
|
|
Issued
|
Display only. The quantity of the stock item issued to date is displayed.
|
|
Backordered
|
Display only. The quantity of the stock item that is not reserved due to insufficient inventory is displayed.
|
