GPAU_SUPTRN_VW2 (SQL View)	Index Back
GPAU - SuperEC Trans Details This view is used on the SuperEC run control when the replacement or duplicate file indicators are checked on. It allows the user to select a previous Sender Transaction Reference or Interchange ID in the SuperEC file.

GPAU_SUPTRN_VW2

(SQL View)

GPAU - SuperEC Trans Details

This view is used on the SuperEC run control when the replacement or duplicate file indicators are checked on. It allows the user to select a previous Sender Transaction Reference or Interchange ID in the SuperEC file.

SELECT GPAU_INTERCHANGEID ,GPAU_SENDTRANSREF ,RECIPIENT_ID ,PAY_ENTITY ,DATE_FROM ,DATE_TO ,GPAU_SNDRTRANSFUNC FROM PS_GPAU_SUPEC_TRAN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPAU_INTERCHANGEID Character(30) VARCHAR2(30) NOT NULL GPAUS - Used as an identifier on a SuperEC message file.

2 GPAU_SENDTRANSREF Number(15,0) DECIMAL(15) NOT NULL GPAUS - Unique reference used in SuperEC processing to identify the SuperEC message file to both the sender and receiver.

3 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID

4 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

5 DATE_FROM Date(10) DATE Date From

6 DATE_TO Date(10) DATE Previous Period Date To

7 GPAU_SNDRTRANSFUNC Character(1) VARCHAR2(1) NOT NULL GPAUS - Flag to indicate if the SuperEC message file to be created is a replacement for a file with errors.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPAU_INTERCHANGEID	Character(30)	VARCHAR2(30) NOT NULL	GPAUS - Used as an identifier on a SuperEC message file.
2	GPAU_SENDTRANSREF	Number(15,0)	DECIMAL(15) NOT NULL	GPAUS - Unique reference used in SuperEC processing to identify the SuperEC message file to both the sender and receiver.
3	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
4	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
5	DATE_FROM	Date(10)	DATE	Date From
6	DATE_TO	Date(10)	DATE	Previous Period Date To
7	GPAU_SNDRTRANSFUNC	Character(1)	VARCHAR2(1) NOT NULL	GPAUS - Flag to indicate if the SuperEC message file to be created is a replacement for a file with errors.