AR_TR_REASON_VW (SQL View)	Index Back
SEPA Reversal Reason Codes SEPA Reversal Reason Codes used in Receivables

AR_TR_REASON_VW

(SQL View)

SEPA Reversal Reason Codes

SEPA Reversal Reason Codes used in Receivables

SELECT T.TR_REASON_CD ,M.MESSAGE_TEXT FROM PS_TR_REASON_LN T ,PSMSGCATDEFN M WHERE TR_REASON_TYPE = 'SEPA REVERSAL' AND T.MESSAGE_SET_NBR = M.MESSAGE_SET_NBR AND T.MESSAGE_NBR = M.MESSAGE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TR_REASON_CD Character(50) VARCHAR2(50) NOT NULL Reason Code

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	TR_REASON_CD	Character(50)	VARCHAR2(50) NOT NULL	Reason Code
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.