GP_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 Rcd Nbr
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
9	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
10	RECIPIENT_TAG	Number(3,0)	SMALLINT NOT NULL	Used to identify recipients for E/D, PI
11	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
12	RECIPIENT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Recipient Name
13	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
14	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
15	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
16	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
17	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
18	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
19	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
20	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
21	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
22	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID
23	PMT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Payment Type 01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction
24	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
25	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
26	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
27	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
28	DEBIT_DT	Date(10)	DATE	Debit Date
29	REVERSAL_IND	Number(1,0)	SMALLINT NOT NULL	Reversal Indicator. Used in the GP BANKING process to identify transactions that are reversals. 0 means not reversal, 1 means reversal.
30	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
31	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
32	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
33	PYMT_ID	Character(6)	VARCHAR2(6) NOT NULL	Payment Identification
34	PYMT_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Payment Number
35	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
36	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.