TR_RV_REASON_VW (SQL View)	Index Back
Position Impacts Header Record

TR_RV_REASON_VW

(SQL View)

Position Impacts Header Record

SELECT %Substring(A.TR_REASON_CD ,1,34) , B.MESSAGE_TEXT FROM PS_TR_REASON_LN A , PSMSGCATDEFN B WHERE A.TR_REASON_TYPE = 'SEPA REVERSAL' AND B.MESSAGE_SET_NBR = A.MESSAGE_SET_NBR AND B.MESSAGE_NBR = A.MESSAGE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RVL_REASON Character(34) VARCHAR2(34) NOT NULL Reversal Reason - used when payments are reversed. Will store Reversal Reason Code. Reason Codes: AC04 - ClosedAccountNumber AG02 - InvalidBankOperationCode AM05 - Duplication MD01 - NoMandate MD05 - CollectionNotDue

2 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RVL_REASON	Character(34)	VARCHAR2(34) NOT NULL	Reversal Reason - used when payments are reversed. Will store Reversal Reason Code. Reason Codes: AC04 - ClosedAccountNumber AG02 - InvalidBankOperationCode AM05 - Duplication MD01 - NoMandate MD05 - CollectionNotDue
2	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.