TR_CN_REASON_VW (SQL View)	Index Back
ISO Cancellation Reason Code

TR_CN_REASON_VW

(SQL View)

ISO Cancellation Reason Code

SELECT %Substring(A.TR_REASON_CD ,1,34) , B.MESSAGE_TEXT FROM PS_TR_REASON_LN A , PSMSGCATDEFN B WHERE A.TR_REASON_TYPE = 'ISO CANCELLATION' 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 CAN_REASON Character(34) VARCHAR2(34) NOT NULL Cancellation Reason - used when payments are cancelled. Will store Cancellation Reason Code. Reason Codes: AGNT - IncorrectAgent CURR - IncorrectCurrency CUST - RequestedByCustomer DUPL - DuplicatePayment SUSP - SuspiciousPayment UPAY - UnduePayment

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	CAN_REASON	Character(34)	VARCHAR2(34) NOT NULL	Cancellation Reason - used when payments are cancelled. Will store Cancellation Reason Code. Reason Codes: AGNT - IncorrectAgent CURR - IncorrectCurrency CUST - RequestedByCustomer DUPL - DuplicatePayment SUSP - SuspiciousPayment UPAY - UnduePayment
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.