PO_RTV_RC_VW

(SQL View)
Index Back

RTV Header Line


SELECT H.BUSINESS_UNIT , H.BUYER_ID , H.VENDOR_SETID , H.VENDOR_ID , L.PO_ID , H.RTV_ID , H.RTV_STATUS , L.RTV_LN_NBR , L.INV_ITEM_ID , L.DESCR254_MIXED , L.RETURN_ACTION , L.RETURN_REASON , L.QTY_LN_RETRN_VUOM , L.UNIT_MEASURE_VNDR , L.RTV_LN_STATUS , L.RMA_ID , L.BUSINESS_UNIT_PO , L.BUSINESS_UNIT_RECV , L.RECEIVER_ID FROM PS_RTV_HDR H , PS_RTV_LN L WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.RTV_ID = L.RTV_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
7 RTV_STATUS Character(1) VARCHAR2(1) NOT NULL Return Status
C=Closed
O=Open
S=Shipped
X=Cancelled
8 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
11 RETURN_ACTION Character(1) VARCHAR2(1) NOT NULL Return Action
C=Credit
E=Exchange
R=Replace
12 RETURN_REASON Character(10) VARCHAR2(10) NOT NULL Reason Code
13 QTY_LN_RETRN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Vndr Returned Qty
14 UNIT_MEASURE_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Unit of Measure
15 RTV_LN_STATUS Character(1) VARCHAR2(1) NOT NULL RTV Line Status
C=Closed
O=Open
S=Shipped
X=Cancelled
16 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
17 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
18 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
19 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number