PV_PO_REQ_XREF

(SQL View)
Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.REQ_ID , A.REQ_LINE_NBR FROM PS_PO_LINE_DISTRIB A WHERE A.REQ_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
6 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number