C360_OM_RMA_VW

(SQL View)
 Index Back

Comprehensive Customer View


SELECT R.SETID ,H.SOLD_TO_CUST_ID , H.BUSINESS_UNIT , H.RMA_ID , H.RMA_DATE , H.RMA_STATUS , B.XLATLONGNAME ,H.RMA_TYPE ,H.RMA_APPROVED_FLAG , H.RETURN_FROM_BU ,H.RETURN_TO_IBU ,H.REASON_CD FROM PS_RMA_HEADER H ,PS_SET_CNTRL_REC R , PSXLATITEM B WHERE R.SETCNTRLVALUE=H.BUSINESS_UNIT AND R.RECNAME='CUSTOMER' AND R.REC_GROUP_ID='FS_23' AND H.RMA_STATUS = B.FIELDVALUE AND B.FIELDNAME = 'RMA_STATUS' AND B.EFF_STATUS = 'A'

# 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_DATE Date(10) DATE RMA Date
6 RMA_STATUS Character(2) VARCHAR2(2) NOT NULL RMA Status
C=Closed
O=Open
P=Pending
X=Canceled
7 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
8 RMA_TYPE Character(1) VARCHAR2(1) NOT NULL RMA Type
I=Inventory RMA
O=Order Management RMA
9 RMA_APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL Approval Required
10 RETURN_FROM_BU Character(5) VARCHAR2(5) NOT NULL Return From Location
11 RETURN_TO_IBU Character(5) VARCHAR2(5) NOT NULL Return To IBU
12 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code