GPMY_RCP_PYENT (SQL Table)	Index Back
Stores Extra Recipient Infor This record is used for recipient country extension information. This record stores commission type/option and group numbers.

GPMY_RCP_PYENT

(SQL Table)

Stores Extra Recipient Infor

This record is used for recipient country extension information. This record stores commission type/option and group numbers.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Prompt Table: GP_PYENT

4 GPMY_RCP_COMM_AMT Number(9,2) DECIMAL(8,2) NOT NULL The Commission Amount is the percentage or flat amount deducted from payments to a recipient.

5 GPMY_RCP_COMM_TYPE Character(2) VARCHAR2(2) NOT NULL This determines if a payment amount is reduced by any commission amount when paying a recipient.
10=Flat Amount
20=Percentage
30=None
Default Value: 30

6 GPMY_RCP_COMM_OPTN Character(2) VARCHAR2(2) NOT NULL This is used to identify whether to calculate commission amounts or not.
10=Deduct Commission
20=Report Only
30=None
Default Value: 30

7 GPMY_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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT
4	GPMY_RCP_COMM_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	The Commission Amount is the percentage or flat amount deducted from payments to a recipient.
5	GPMY_RCP_COMM_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This determines if a payment amount is reduced by any commission amount when paying a recipient. 10=Flat Amount 20=Percentage 30=None Default Value: 30
6	GPMY_RCP_COMM_OPTN	Character(2)	VARCHAR2(2) NOT NULL	This is used to identify whether to calculate commission amounts or not. 10=Deduct Commission 20=Report Only 30=None Default Value: 30
7	GPMY_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.