GPHK_RCP_PYNT_S (SQL Table)	Index Back
Store recipient Details for HK The record is used for recipient country extension information. This record stores commission details for each pay entity. The recipient (probably in agreement with the pay entity) determines commission calculation rules. This information is used at the time of generating the bank transfer file. Also entered in this record is the unique group number assigned to a pay entity by recipient.

GPHK_RCP_PYNT_S

(SQL Table)

Store recipient Details for HK

The record is used for recipient country extension information. This record stores commission details for each pay entity. The recipient (probably in agreement with the pay entity) determines commission calculation rules. This information is used at the time of generating the bank transfer file. Also entered in this record is the unique group number assigned to a pay entity by recipient.

# 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
Prompt Table: GP_PYENT

3 GPHK_RCP_COMM_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies the method in which commission should be calculated.
10=Flat Amount
20=Percentage
30=None
Default Value: 30

4 GPHK_RCP_COMM_OPTN Character(1) VARCHAR2(1) NOT NULL Identifies whether commission amount should be deducted or whether it is for report purpose only.
1=Deduction Commission
2=Report Only
Default Value: 2

5 GPHK_RCP_COMM_AMT Number(9,2) DECIMAL(8,2) NOT NULL The Commission to be calculated. This could either be a percentage or an amount.

6 GPHK_RCP_GROUP_ID Character(20) VARCHAR2(20) NOT NULL Group number provided by the recipient

7 GPHK_MPF_PRTC_NO Character(20) VARCHAR2(20) NOT NULL This is the particatipation number allocated to the Pay Entity by the MPF Board.

8 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: PERSON_NAME

9 CONTACT_PHONE Character(12) VARCHAR2(12) NOT NULL Contact Phone

#	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 Prompt Table: GP_PYENT
3	GPHK_RCP_COMM_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies the method in which commission should be calculated. 10=Flat Amount 20=Percentage 30=None Default Value: 30
4	GPHK_RCP_COMM_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether commission amount should be deducted or whether it is for report purpose only. 1=Deduction Commission 2=Report Only Default Value: 2
5	GPHK_RCP_COMM_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	The Commission to be calculated. This could either be a percentage or an amount.
6	GPHK_RCP_GROUP_ID	Character(20)	VARCHAR2(20) NOT NULL	Group number provided by the recipient
7	GPHK_MPF_PRTC_NO	Character(20)	VARCHAR2(20) NOT NULL	This is the particatipation number allocated to the Pay Entity by the MPF Board.
8	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: PERSON_NAME
9	CONTACT_PHONE	Character(12)	VARCHAR2(12) NOT NULL	Contact Phone