RETURN_REASONS (SQL View)	Index Back
List of Return Reasons Return To Vendor (Supplier) Return Reasons

RETURN_REASONS

(SQL View)

List of Return Reasons

Return To Vendor (Supplier) Return Reasons

SELECT setid , reason_cd , descr50 , quality_metric_flg FROM PS_REASON_CD a WHERE a.effdt = ( SELECT MAX(aa.effdt) FROM PS_REASON_CD aa WHERE a.setid = aa.setid AND a.reason_type = aa.reason_type AND a.reason_cd = aa.reason_cd AND aa.effdt <= %CurrentDateIn ) AND a.eff_status = 'A' AND a.reason_type = '26'

Related Language Record: RETURN_REASN_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 RETURN_REASON Character(10) VARCHAR2(10) NOT NULL Reason Code

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

4 QUALITY_METRIC_FLG Character(1) VARCHAR2(1) NOT NULL Include in Quality Metric
Y/N Table Edit
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	RETURN_REASON	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
4	QUALITY_METRIC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include in Quality Metric Y/N Table Edit Default Value: Y