AP_PO_RTV_VW

(SQL View)
 Index Back

PO Inquiry - RTV Details


SELECT A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.BUSINESS_UNIT , A.RTV_ID , A.RTV_LN_NBR , A.RTV_LN_STATUS , A.RETURN_ACTION , A.DISPOSITION_TYPE , A.RETURN_REASON , A.UNIT_MEASURE_VNDR , A.QTY_LN_RETRN_VUOM , A.QTY_LN_SHIP_VUOM FROM PS_RTV_LN A , PS_RTV_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RTV_ID = B.RTV_ID AND B.RTV_STATUS <> 'X'

# 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 BUSINESS_UNIT_RTV Character(5) VARCHAR2(5) NOT NULL RTV Business Unit
6 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
7 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
8 RTV_LN_STATUS Character(1) VARCHAR2(1) NOT NULL RTV Line Status
C=Closed
O=Open
S=Shipped
X=Cancelled
9 RETURN_ACTION Character(1) VARCHAR2(1) NOT NULL Return Action
C=Credit
E=Exchange
R=Replace
10 DISPOSITION_TYPE Character(1) VARCHAR2(1) NOT NULL Disposition Type
0=Ship
1=Destroy
11 RETURN_REASON Character(10) VARCHAR2(10) NOT NULL Reason Code
12 UNIT_MEASURE_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Unit of Measure
13 QTY_LN_RETRN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Vndr Returned Qty
14 QTY_LN_SHIP_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Supp Shipped Qty