GPNL_PYENT_BANK (SQL Table)	Index Back
Pay Entity - Netherland Ext This table will be used to record the pay entity information that is required for\The Netherlands These information are in addition to the details that ca be entered through the core pages.

GPNL_PYENT_BANK

(SQL Table)

Pay Entity - Netherland Ext

This table will be used to record the pay entity information that is required for\The Netherlands These information are in addition to the details that ca be entered through the core pages.

Parent record: GPNL_PYENT_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Default Value: GP_PYENT_DTL.PAY_ENTITY

2 EFFDT Date(10) DATE Effective Date
Default Value: GP_PYENT_DTL.EFFDT

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

4 GPNL_SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Alternative Source Bank, used to enter Postbank accounts
Prompt Table: SRC_BANK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Default Value: GP_PYENT_DTL.PAY_ENTITY
2	EFFDT	Date(10)	DATE	Effective Date Default Value: GP_PYENT_DTL.EFFDT
3	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID Prompt Table: SRC_BANK
4	GPNL_SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Alternative Source Bank, used to enter Postbank accounts Prompt Table: SRC_BANK