CDT_RMASUM_VW

(SQL View)
Index Back

CDT RMA Summary

Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

SELECT SOLD_TO_CUST_ID , RMA_ID , RMA_DATE , BUSINESS_UNIT , RMA_STATUS FROM PS_RMA_HEADER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
2 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
3 RMA_DATE Date(10) DATE RMA Date
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 RMA_STATUS Character(2) VARCHAR2(2) NOT NULL RMA Status
C=Closed
O=Open
P=Pending
X=Canceled