GPSG_RCP_FT_TMP (SQL Table)	Index Back
Temporary RCP file footer line The temporary table stores recipient payment file footer line.

GPSG_RCP_FT_TMP

(SQL Table)

Temporary RCP file footer line

The temporary table stores recipient payment file footer line.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 GPSG_RCP_GROUP_ID Character(10) VARCHAR2(10) NOT NULL The Group ID is an identifier that has been assigned to the Pay Entity by a recipient. It is used when reporting payments to recipients to identify the company the payments are from.

4 GPSG_TT_PAY_AMT Number(11,2) DECIMAL(10,2) NOT NULL Total Payment Amount

5 GPSG_TT_COMM_AMT Number(9,2) DECIMAL(8,2) NOT NULL Total Commission Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
2	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
3	GPSG_RCP_GROUP_ID	Character(10)	VARCHAR2(10) NOT NULL	The Group ID is an identifier that has been assigned to the Pay Entity by a recipient. It is used when reporting payments to recipients to identify the company the payments are from.
4	GPSG_TT_PAY_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Total Payment Amount
5	GPSG_TT_COMM_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Total Commission Amount