GPDE_BK_XFR_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	GPDE_BK_CNTRY_RCVR	Character(3)	VARCHAR2(3) NOT NULL	Country Transit Receiver
10	GPDE_BK_TRNST_RCVR	Character(11)	VARCHAR2(11) NOT NULL	Transit Employee Bank
11	GPDE_BK_ACCT_RCVR	Character(35)	VARCHAR2(35) NOT NULL	Employee Bank Account
12	GPDE_BK_SEQ_NBR	Number(8,0)	INTEGER NOT NULL	Sequence Number
13	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
14	GPDE_BK_CNTRY_ISSR	Character(3)	VARCHAR2(3) NOT NULL	Country Transit Issuer
15	GPDE_BK_TRNST_ISSR	Character(11)	VARCHAR2(11) NOT NULL	Transit Source Bank
16	GPDE_BK_ACCT_ISSR	Character(35)	VARCHAR2(35) NOT NULL	Source Bank Account
17	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
18	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
19	DEBIT_DT	Date(10)	DATE	Debit Date
20	GPDE_BK_XFER_NBR	Number(3,0)	SMALLINT NOT NULL	Transfer Sequence
21	GPDE_BK_XFER_BASIS	Character(1)	VARCHAR2(1) NOT NULL	Transfer Basis C=Clearing bank H=Source Bank
22	GPDE_AL_PAYMT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payment Type 1=Wages and Salaries 3=Taxes 4=Social Insurance 6=Capital Accumulation 7=Direct Life Insurance 8=Garnishments 9=External Transfer B=BVV L=U1/Sick Leave M=U2/Maternity Leave V=Advance Payments
23	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
24	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
25	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
26	GPDE_BK_ACCT_NM_RC	Character(50)	VARCHAR2(50) NOT NULL	Receiver Name
27	GPDE_BK_ACCT_NM_IS	Character(50)	VARCHAR2(50) NOT NULL	Issuer Name
28	GPDE_BK_PUR_TRNFER	Character(35)	VARCHAR2(35) NOT NULL	Bank Transfer Purpose
29	GPDE_BK_EXT_COUNT	Number(2,0)	SMALLINT NOT NULL	Number Of Extension
30	GPDE_BK_EXT_FLG1	Character(2)	VARCHAR2(2) NOT NULL	Extension Flag 1
31	GPDE_BK_MULTI_FLD1	Character(35)	VARCHAR2(35) NOT NULL	Multi Purpose Field 1
32	GPDE_BK_EXT_FLG2	Character(2)	VARCHAR2(2) NOT NULL	Extension Flag 2
33	GPDE_BK_MULTI_FLD2	Character(35)	VARCHAR2(35) NOT NULL	Multi Purpose Field 2
34	GPDE_BK_XFER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Transfer Flag