FSS_REASON_VW (SQL View)	Index Back
Reasn Code VW Used in Excise Adjustment

FSS_REASON_VW

(SQL View)

Reasn Code VW

Used in Excise Adjustment

SELECT RC.SETID , RC.REASON_TYPE , RC.REASON_CD , RC.DESCR50 FROM PS_REASON_CD RC WHERE RC.REASON_TYPE = '33' AND RC.EFF_STATUS = 'A' AND %EffdtCheck(REASON_CD,RC,%CURRENTDATEIN)

Related Language Record: FSS_REASON_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason Type

3 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	REASON_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Reason Type
3	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50