GPGB_PAYMENT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: 0
4	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
5	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
6	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
7	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
8	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
9	PYMT_KEY1	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
10	PYMT_KEY2	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
11	PYMT_KEY3	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
12	PYMT_KEY4	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
13	PMT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Payment Type 01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction
14	DEBIT_DT	Date(10)	DATE	Debit Date
15	PAYMENT_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Payment Method A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer
16	PMT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status field for a generated payment transaction F=Finalized M=Manually Paid N=No Active Allocations P=Prepared T=Payment Transferred V=Hold W=Void
17	GPGB_DEST_SORTCODE	Character(11)	VARCHAR2(11) NOT NULL	UK Destination Sorting Code for EFT
18	GPGB_DEST_ACCT_NBR	Character(35)	VARCHAR2(35) NOT NULL	UK Destination Account Number for EFT
19	GPGB_ORIG_SORTCODE	Character(11)	VARCHAR2(11) NOT NULL	UK Originating Sorting Code for EFT
20	GPGB_ORIG_ACCT_NBR	Character(35)	VARCHAR2(35) NOT NULL	UK Originating Account Number for EFT
21	GPGB_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	UK Payment Amount for EFT
22	GPGB_ORIG_ACCTNAME	Character(50)	VARCHAR2(50) NOT NULL	UK Originating Account Name for EFT
23	GPGB_DEST_ACCTNAME	Character(50)	VARCHAR2(50) NOT NULL	UK Destination Account Name for EFT
24	ROLL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Roll Name
25	ROLL_NUMBER	Character(20)	VARCHAR2(20) NOT NULL	Roll Number
26	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
27	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description