CNTRCT_REQPO_VW

(SQL View)
Index Back

Contract Event Req/PO View


SELECT POHD.BUSINESS_UNIT , POLD.PO_ID , POHD.BUYER_ID , O.OPRDEFNDESC , POLD.LINE_NBR , POLD.SCHED_NBR , POLD.DISTRIB_LINE_NUM , POLD.QTY_PO , POLS.PRICE_PO , POLS.CURRENCY_CD , POLS.DUE_DT , POHD.PO_STATUS , POHD.RECV_STATUS , POLD.BUSINESS_UNIT_REQ , POLD.REQ_ID , POLD.REQ_LINE_NBR , POL.RELEASE_NBR FROM PS_PO_LINE_DISTRIB POLD , PS_PO_LINE_SHIP POLS , PS_PO_LINE POL , PS_PO_HDR POHD ,PSOPRDEFN O WHERE POLD.PO_ID = POLS.PO_ID AND POLD.LINE_NBR = POLS.LINE_NBR AND POLD.SCHED_NBR = POLS.SCHED_NBR AND POHD.PO_ID = POLS.PO_ID AND POHD.BUSINESS_UNIT = POLS.BUSINESS_UNIT AND POHD.BUYER_ID = O.OPRID AND POLD.BUSINESS_UNIT = POLS.BUSINESS_UNIT AND POLD.BUSINESS_UNIT = POL.BUSINESS_UNIT AND POLD.PO_ID = POL.PO_ID AND POLD.LINE_NBR = POL.LINE_NBR

# 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 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
4 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
8 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
9 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
12 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
13 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
14 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
15 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
16 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
17 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number