Total Pageviews

August 29, 2018

8/29/2018 01:53:00 PM
Link from PO to Requisition: Table with related column: 
PO_DISTRIBUTIONS_ALL.REQ_DISTRIBUTION_ID(Requisition distribution unique identifier) 

If you autocreate this accounting distribution from a requisition, REQ_DISTRIBUTION_ID corresponds to the ID of the requisition distribution you copy on the purchase order. 


Link from Requisition to PO: PO_REQUISITION_LINES_ALL.LINE_LOCATION_ID(Document shipment schedule unique identifier ) 

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. 

For Purchase Order: PO_LINE_LOCATIONS_ALL table has LINE_LOCATION_ID column.
Related Posts Plugin for WordPress, Blogger...