C360_OM_RMA_VW1

(SQL View)
 Index Back

Comprehensive Customer View


SELECT R.SETID ,H.SOLD_TO_CUST_ID , H.BUSINESS_UNIT , H.RMA_ID ,L.RMA_LINE_NBR ,L.REF_BUS_UNIT_OM ,L.REF_ORDER_NO , H.RMA_DATE , H.RMA_STATUS ,H.RMA_TYPE ,H.RMA_APPROVED_FLAG , H.RETURN_FROM_BU ,H.RETURN_TO_IBU ,H.REASON_CD FROM PS_RMA_HEADER H ,PS_RMA_LINE L ,PS_SET_CNTRL_REC R WHERE L.BUSINESS_UNIT= H.BUSINESS_UNIT AND L.RMA_ID= H.RMA_ID AND R.SETCNTRLVALUE=H.BUSINESS_UNIT AND R.RECNAME='CUSTOMER' AND R.REC_GROUP_ID='FS_23'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
5 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
6 REF_BUS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Reference Order Management Business Unit
7 REF_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Referenced Order Nbr
8 RMA_DATE Date(10) DATE RMA Date
9 RMA_STATUS Character(2) VARCHAR2(2) NOT NULL RMA Status
C=Closed
O=Open
P=Pending
X=Canceled
10 RMA_TYPE Character(1) VARCHAR2(1) NOT NULL RMA Type
I=Inventory RMA
O=Order Management RMA
11 RMA_APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL Approval Required
12 RETURN_FROM_BU Character(5) VARCHAR2(5) NOT NULL Return From Location
13 RETURN_TO_IBU Character(5) VARCHAR2(5) NOT NULL Return To IBU
14 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code