Wednesday, November 23, 2011

PO_REQUISITION_LINES_ALL

Purchasing
Table Or View: Table
Important columns: 
REQUISITION_HEADER_ID : Requisition header unique identifier
LINE_NUM NUMBER : Line number
LINE_TYPE_ID : Line type
CATEGORY_ID : Item category unique identifier
ITEM_DESCRIPTION : Item description
QUANTITY NUMBER : Quantity ordered
DELIVER_TO_LOCATION_ID : Deliver-to location unique identifier

Description: 
PO_REQUISITION_LINES stores information about requisition lines. You need one row for each requisition line you create. Each row contains the line number, item number, item category, item description, need-by date, deliver-to location, item quantities, units, prices, requestor, notes, and suggested supplier information for the requisition line.
 
LINE_LOCATION_ID identifies the purchase order shipment line on which you placed the requisition. LINE_LOCATION_ID is null if you have not placed the requisition line on a purchase order.
 
BLANKET_PO_HEADER_ID and BLANKET_PO_LINE_NUM store the suggested blanket purchase agreement or catalog quotation line information for the requisition line.
 
PARENT_REQ_LINE_ID contains the REQUISITION_LINE_ID from the original requisition line if you exploded or multisourced this requisition line.
 
PO_REQUISITION_LINES is one of three tables storing requisition information. This table corresponds to the Lines region
of the Requisitions window

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect