RMA_CNTCT_VW1 (SQL View)	Index Back
Order Header Search Record

RMA_CNTCT_VW1

(SQL View)

Order Header Search Record

SELECT A.BUSINESS_UNIT , A.RMA_ID , A.SOLD_TO_CUST_ID , A.CNTCT_SEQ_NUM FROM PS_SET_CNTRL_REC C , PS_RMA_HEADER A , PS_CUSTOMER B WHERE C.RECNAME='CUSTOMER' AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND A.RMA_TYPE='O' AND A.SOLD_TO_CUST_ID = B.CUST_ID AND B.CUST_STATUS IN ('A','I')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_RMA Character(5) VARCHAR2(5) NOT NULL RMA Business Unit
Prompt Table: SP_BU_FS_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

4 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_RMA	Character(5)	VARCHAR2(5) NOT NULL	RMA Business Unit Prompt Table: SP_BU_FS_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
4	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number