PO_TLRQPOSCH_VW

(SQL View)
Index Back

Req to PO Schedule


SELECT A.REPORT_ENTITY ,A.REQUESTOR_ID ,A.VENDOR_SETID ,A.VENDOR_ID ,A.VNDR_LOC ,A.BUSINESS_UNIT ,A.REQ_ID ,A.LINE_NBR ,A.SCHED_NBR , A.SHIPTO_SETID , A.SHIPTO_ID FROM PS_PO_SPND_RQDTDTL a WHERE a.req_status = 'A' AND A.AMT_OPEN > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID
2 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
9 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
10 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
11 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location