PO_RTV_VW

(SQL View)
 Index Back

RTV for Exchange Hdr View


SELECT DISTINCT A.BUSINESS_UNIT , A.RTV_ID , A.RETURN_ACTION FROM PS_RTV_LN A WHERE RETURN_ACTION = 'E'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_RTV Character(5) VARCHAR2(5) NOT NULL RTV Business Unit
2 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
3 RETURN_ACTION Character(1) VARCHAR2(1) NOT NULL Return Action
C=Credit
E=Exchange
R=Replace