GPAU_EFT_CLRMAP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
2	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
3	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
4	RECIPIENT_TAG	Number(3,0)	SMALLINT NOT NULL	Used to identify recipients for E/D, PI
5	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	GPAU_LODGEMENT_REF	Character(50)	VARCHAR2(50) NOT NULL	This field is used in the AE program GPAU_EFT_CMX.
8	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
9	GPAU_BANK_DB_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field distinguishes debit types and is used in the AE program GPAU_EFT_CMX. 10=Group Tax 20=Net Payment 30=Recipient
10	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID
11	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
12	ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name
13	GPAU_PARTY_ID	Character(30)	VARCHAR2(30) NOT NULL	Third Party ID
14	GPAU_TR_BRANCH_CD	Character(17)	VARCHAR2(17) NOT NULL	The Trace Branch Code supersedes any Branch Code tracked on the Source Bank Table.
15	GPAU_TR_ACCOUNT_CD	Character(35)	VARCHAR2(35) NOT NULL	The Trace Account Code supersedes any account code tracked on the Source Bank Table.
16	GPAU_ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name
17	GPAU_CLRHOUSE_LRN	Character(50)	VARCHAR2(50) NOT NULL	This field is used to hold the static Lodgement reference number of the Clearing House