RMA_HDR_SRCH (SQL View)	Index Back
RMA header search Date Initials Issue Description 012501 dms SP2 (DI-EDWONG-2) Deferred processing

RMA_HDR_SRCH

(SQL View)

RMA header search

Date Initials Issue Description 012501 dms SP2 (DI-EDWONG-2) Deferred processing

SELECT business_unit , rma_id , sold_to_cust_id , rma_status , rma_date , rma_date FROM PS_RMA_HEADER WHERE rma_type='O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUOMIN_NONVW

2 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number

3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
Prompt Table: CUST_SLD_VW

4 RMA_STATUS Character(2) VARCHAR2(2) NOT NULL RMA Status
C=Closed
O=Open
P=Pending
X=Canceled

5 RMA_DATE Date(10) DATE RMA Date

6 THRU_RMA_DATE Date(10) DATE Thru RMA Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUOMIN_NONVW
2	RMA_ID	Character(10)	VARCHAR2(10) NOT NULL	RMA Number
3	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer Prompt Table: CUST_SLD_VW
4	RMA_STATUS	Character(2)	VARCHAR2(2) NOT NULL	RMA Status C=Closed O=Open P=Pending X=Canceled
5	RMA_DATE	Date(10)	DATE	RMA Date
6	THRU_RMA_DATE	Date(10)	DATE	Thru RMA Date