GP_SRCBNK_SGPAU (SQL Table)	Index Back
Payee source bank additn info This table is used to store source bank account types and trace information. Used for DDP Cemtex file generation process.

GP_SRCBNK_SGPAU

(SQL Table)

Payee source bank additn info

This table is used to store source bank account types and trace information. Used for DDP Cemtex file generation process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GPAU_EFT_USER_NO Character(6) VARCHAR2(6) NOT NULL EFT User Number used in the AE program GPAU_EFT_CMX.

3 GPAU_EFT_USER_NAME Character(26) VARCHAR2(26) NOT NULL This is the User Name used for CEMTEX reporting.

4 GPAU_TRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL This field is used to identify the bank id of the trace account.
Prompt Table: SRC_BANK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
2	GPAU_EFT_USER_NO	Character(6)	VARCHAR2(6) NOT NULL	EFT User Number used in the AE program GPAU_EFT_CMX.
3	GPAU_EFT_USER_NAME	Character(26)	VARCHAR2(26) NOT NULL	This is the User Name used for CEMTEX reporting.
4	GPAU_TRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	This field is used to identify the bank id of the trace account. Prompt Table: SRC_BANK