GPFR_PMT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
9	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
10	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
11	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
12	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
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	PMT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Payment Type 01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction
21	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
23	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
24	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
25	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID
26	DEBIT_DT	Date(10)	DATE	Debit Date
27	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.
28	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
29	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
30	GPFR_BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	GPFR: Bank ID
31	GPFR_BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	GPFR: Bank Branch ID
32	GPFR_ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	GPFR: Account #
33	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID Prompt Table: BANK_EC_TBL
34	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID Prompt Table: BANK_BRANCH_TBL
35	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
36	BANK_TRANSFER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bank Transfer ID
37	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
38	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
39	ORG_LINK_UNIT	Character(12)	VARCHAR2(12) NOT NULL	Contains ID of an org unit to which a source bank is assigned. can be Company, Dept, Location, Pay Group or Pay Entity ID
40	GPFR_BANK_NAME	Character(24)	VARCHAR2(24) NOT NULL	GPFR: Receiver's Bank Name
41	GPFR_BANK_DELETE	Character(1)	VARCHAR2(1) NOT NULL	GPFR: Cancel Data
42	GPFR_BANK_TOT_AMT	Number(17,2)	DECIMAL(16,2) NOT NULL	GPFR: Total Amount
43	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
44	RECIPIENT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Recipient Name