GPDE_PMT_FG_VW

(SQL View)
 Index Back

Payment Processing Results

Payment Processing Results

SELECT A.CAL_RUN_ID , A.EMPLID , A.EMPL_RCD ,A.GP_PAYGROUP ,A.CAL_ID ,A.ORIG_CAL_RUN_ID ,A.RSLT_SEG_NUM ,A.PIN_NUM ,A.INSTANCE ,A.RECIPIENT_TAG ,A.ACCOUNT_ID ,A.RECIPIENT_ID ,A.RECIPIENT_NAME ,A.EFF_STATUS ,A.PAY_ENTITY ,A.BUSINESS_UNIT ,A.PMT_TYPE ,A.GP_ADDENDA_VALUE , A.GP_PMT_AMT ,A.CURRENCY_CD ,A.PAYMENT_MTHD ,A.DEBIT_DT ,A.SRC_BANK_ID ,A.PMT_STATUS ,A.PYMT_ID ,A.PYMT_NBR ,A.FILE_ID ,A.PAYMENT_STATUS ,A.GP_PMT_GEN_ID ,A.GP_SRC_ACCT_NUM ,A.GP_SRC_BANK_ID ,A.GP_SRC_COUNTRY_CD ,A.GP_SRC_BANK_CD ,A.GP_SRC_BIC ,A.GP_SRC_BRANCH ,A.GP_SRC_ACCT_NAME ,A.GP_SRC_IBAN_ID ,A.GP_DEST_ACCT_NUM ,A.GP_DEST_BANK_ID ,A.GP_DEST_COUNTRY_CD ,A.GP_DEST_BANK_CD ,A.GP_DEST_BIC ,A.GP_DEST_BRANCH ,A.GP_DEST_ACCT_NAME ,A.GP_DEST_IBAN_ID ,A.ACCOUNT_TYPE_PYE ,A.KEY_CHAR_40_01 ,A.KEY_CHAR_40_02 ,A.LASTUPDDTTM ,A.LASTUPDOPRID FROM PS_GP_PAYMENT_FG A WHERE A.gp_dest_country_cd = 'DEU'

# 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
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 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID
12 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
13 RECIPIENT_NAME Character(30) VARCHAR2(30) NOT NULL Recipient Name
14 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
15 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
16 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
17 PMT_TYPE Character(2) VARCHAR2(2) NOT NULL Payment Type
01=Net Pay Distribution
02=General Recipient Deduction
03=Individual Recipient Deduction
18 GP_ADDENDA_VALUE Character(254) VARCHAR2(254) NOT NULL Addenda Value use for Bank Statement Accounting
19 GP_PMT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount field on GP PAYMENT table
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
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 DEBIT_DT Date(10) DATE Debit Date
23 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
24 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
25 PYMT_ID Character(6) VARCHAR2(6) NOT NULL Payment Identification
26 PYMT_NBR Number(18,0) DECIMAL(18) NOT NULL Payment Number
27 FILE_ID Character(30) VARCHAR2(30) NOT NULL File Identifier
28 PAYMENT_STATUS Character(1) VARCHAR2(1) NOT NULL A status flag in GP_PAYMENT_FG record to monitor the transaction between GP and FG (SEPA/Financial Gateway)
0=Pay Prep Run
1=Prepare Bank Advice Run
2=Payment Sent to FG
3=Processing
C=Cancelled
E=Error
L=Awaiting Dispatch
P=Paid
R=Received by Bank
S=Dispatched to Bank
29 GP_PMT_GEN_ID Character(20) VARCHAR2(20) NOT NULL Payment Generation ID
30 GP_SRC_ACCT_NUM Character(35) VARCHAR2(35) NOT NULL Source Account Number (SEPA/Financial Gateway)
31 GP_SRC_BANK_ID Character(11) VARCHAR2(11) NOT NULL Source Bank ID (SEPA/Financial Gateway)
32 GP_SRC_COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Financial Gateway (SEPA)
33 GP_SRC_BANK_CD Character(11) VARCHAR2(11) NOT NULL Financial Gateway (SEPA)
34 GP_SRC_BIC Character(11) VARCHAR2(11) NOT NULL Source Bank Identifier Code (SEPA/Financial Gateway)
35 GP_SRC_BRANCH Character(17) VARCHAR2(17) NOT NULL Financial Gateway (SEPA)
36 GP_SRC_ACCT_NAME Character(50) VARCHAR2(50) NOT NULL Financial Gateway (SEPA)
37 GP_SRC_IBAN_ID Character(34) VARCHAR2(34) NOT NULL Financial Gateway (SEPA)
38 GP_DEST_ACCT_NUM Character(35) VARCHAR2(35) NOT NULL Used to store the destination Account Number. (SEPA/Financial Gateway)
39 GP_DEST_BANK_ID Character(11) VARCHAR2(11) NOT NULL Used to store the destination Bank ID Number. (SEPA/Financial Gateway)
40 GP_DEST_COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Financial Gateway (SEPA)
41 GP_DEST_BANK_CD Character(11) VARCHAR2(11) NOT NULL Financial Gateway (SEPA)
42 GP_DEST_BIC Character(11) VARCHAR2(11) NOT NULL Used to store the destination Bank Identifier Code. (SEPA/Financial Gateway)
43 GP_DEST_BRANCH Character(17) VARCHAR2(17) NOT NULL Financial Gateway (SEPA)
44 GP_DEST_ACCT_NAME Character(50) VARCHAR2(50) NOT NULL Financial Gateway (SEPA)
45 GP_DEST_IBAN_ID Character(34) VARCHAR2(34) NOT NULL Financial Gateway (SEPA)
46 ACCOUNT_TYPE_PYE Character(1) VARCHAR2(1) NOT NULL Payee Bank Account Type
A=Current Account
B=Building Society Roll Number
C=Checking
G=Giro Account
R=Regular
S=Savings
T=Salary Account
47 KEY_CHAR_40_01 Character(40) VARCHAR2(40) NOT NULL Key Char 40/01
48 KEY_CHAR_40_02 Character(40) VARCHAR2(40) NOT NULL Key Char 40/02
49 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.
50 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.