GPHK_PYENT_SBNK (SQL Table)	Index Back
Pay Entity Source bank HKG This table stores the customer number given to each pay entity by the source bank.

GPHK_PYENT_SBNK

(SQL Table)

Pay Entity Source bank HKG

This table stores the customer number given to each pay entity by the source bank.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
Prompt Table: SRC_BANK

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

4 GPHK_CUST_NETID Character(20) VARCHAR2(20) NOT NULL This field holds the value of customer net ID required Ifile.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
2	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID Prompt Table: SRC_BANK
3	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.
4	GPHK_CUST_NETID	Character(20)	VARCHAR2(20) NOT NULL	This field holds the value of customer net ID required Ifile.