GPDE_BK_XFER_EE

(SQL Table)
 Index Back

Payment Processing Results

Results table for Prepare Payment Process. Related Processing Setting of the GP_PAYMENT_STAT 1. After Prepare Payment set flag corresponding GP_PYE_PRC_STAT.GP_PAYMENT_STAT to 50 2. After Validate Payment set flag corresponding GP_PYE_PRC_STAT.GP_PAYMENT_STAT to 52

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
2 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
4 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
7 GPDE_BK_CNTRY_RCVR Character(3) VARCHAR2(3) NOT NULL Country Transit Receiver
8 GPDE_BK_TRNST_RCVR Character(11) VARCHAR2(11) NOT NULL Transit Employee Bank
9 GPDE_BK_ACCT_RCVR Character(35) VARCHAR2(35) NOT NULL Employee Bank Account
10 GPDE_BK_SEQ_NBR Number(8,0) INTEGER NOT NULL Sequence Number
11 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
12 GPDE_BK_CNTRY_ISSR Character(3) VARCHAR2(3) NOT NULL Country Transit Issuer
13 GPDE_BK_TRNST_ISSR Character(11) VARCHAR2(11) NOT NULL Transit Source Bank
14 GPDE_BK_ACCT_ISSR Character(35) VARCHAR2(35) NOT NULL Source Bank Account
15 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

16 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
17 DEBIT_DT Date(10) DATE Debit Date
18 GPDE_BK_XFER_NBR Number(3,0) SMALLINT NOT NULL Transfer Sequence
19 GPDE_BK_XFER_BASIS Character(1) VARCHAR2(1) NOT NULL Transfer Basis
C=Clearing bank
H=Source Bank
20 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
21 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
22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
23 GP_PMT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount field on GP PAYMENT table
24 GPDE_BK_ACCT_NM_RC Character(50) VARCHAR2(50) NOT NULL Receiver Name
25 GPDE_BK_ACCT_NM_IS Character(50) VARCHAR2(50) NOT NULL Issuer Name
26 GPDE_BK_PUR_TRNFER Character(35) VARCHAR2(35) NOT NULL Bank Transfer Purpose
27 GPDE_BK_EXT_COUNT Number(2,0) SMALLINT NOT NULL Number Of Extension
28 GPDE_BK_EXT_FLG1 Character(2) VARCHAR2(2) NOT NULL Extension Flag 1
29 GPDE_BK_MULTI_FLD1 Character(35) VARCHAR2(35) NOT NULL Multi Purpose Field 1
30 GPDE_BK_EXT_FLG2 Character(2) VARCHAR2(2) NOT NULL Extension Flag 2
31 GPDE_BK_MULTI_FLD2 Character(35) VARCHAR2(35) NOT NULL Multi Purpose Field 2
32 GPDE_BK_XFER_FLG Character(1) VARCHAR2(1) NOT NULL Transfer Flag