GPHK_PYENT_TAO (SQL Table)	Index Back
Temporary Table for EFT HKG This is a temporary table used by the EFT processing for GP Hong Kong

GPHK_PYENT_TAO

(SQL Table)

Temporary Table for EFT HKG

This is a temporary table used by the EFT processing for GP Hong Kong

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

4 BANK_TRANSFER_ID Character(15) VARCHAR2(15) NOT NULL Bank Transfer ID

5 GPHK_BNK_REFNO Character(20) VARCHAR2(20) NOT NULL This field holds the value of a number provided by HSBC bank to the customer. This number is used for creating EFT file.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
3	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
4	BANK_TRANSFER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bank Transfer ID
5	GPHK_BNK_REFNO	Character(20)	VARCHAR2(20) NOT NULL	This field holds the value of a number provided by HSBC bank to the customer. This number is used for creating EFT file.