GP_PMT_FG_VW

(SQL View)
 Index Back

Payment Processing Results

SEPA/Financial Gateway Results table for Prepare Payment Process.

SELECT CAL_RUN_ID , EMPLID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , PIN_NUM , INSTANCE , RECIPIENT_TAG , RUN_TYPE , ACCOUNT_ID , RECIPIENT_ID , RECIPIENT_NAME , EFF_STATUS , PAY_ENTITY , PYMT_KEY1 , PYMT_KEY2 , PYMT_KEY3 , PYMT_KEY4 , BUSINESS_UNIT , PMT_TYPE , GP_ADDENDA_VALUE , GP_PMT_AMT , CURRENCY_CD , CURRENCY_CD2 , PAYMENT_MTHD , DEBIT_DT , SRC_BANK_ID , PMT_STATUS , PYMT_ID , PYMT_NBR , FILE_ID , PAYMENT_STATUS , GP_PMT_GEN_ID , PROCESS_INSTANCE , PMT_MSG_ID , PMT_SEQ_NUM , PMT_SOURCE , SRC_REF_ID , AMOUNT , AMOUNT_CURRENCY_CD , PYMNT_DT , VALUE_DT , ESTIMATED_DUE_DATE , BANK_SETID , BANK_CD , BANK_ACCT_KEY , GP_SRC_ACCT_NUM , GP_SRC_BANK_ID , GP_SRC_COUNTRY_CD , GP_SRC_BANK_CD , GP_SRC_BIC , GP_SRC_BRANCH , GP_SRC_CHK_DIGIT , GP_SRC_IBANCHKDGT , GP_SRC_ACCT_NAME , GP_SRC_IBAN_ID , PYMNT_METHOD , FORMAT_ID , PRENOTE_FLAG , PAY_IMMEDIATELY , GP_DEST_ACCT_NUM , GP_DEST_BANK_ID , GP_DEST_COUNTRY_CD , GP_DEST_BANK_CD , GP_DEST_BIC , GP_DEST_BRANCH , GP_DEST_CHK_DIGIT , GP_DEST_IBANCHKDGT , GP_DEST_ACCT_NAME , GP_DEST_IBAN_ID , ACCOUNT_TYPE_PYE , PARTY_ID_TYPE , PARTY_SETID , PARTY_ID , NAME1 , NAME1_AC , NAME2 , STD_ID_NUM , STD_ID_NUM_QUAL , EFT_PYMNT_FMT_CD , EFT_RTNG_FLG , EFT_RTNG_STATUS , EFT_TRANS_HANDLING , EFT_DOM_COSTS_CD , EFT_CORR_COSTS_CD , EFT_CROSSED_CHECK , EFT_CHECK_FWRD_CD , EFT_CHECK_DRAW_CD , EFT_PAY_INST_CD1 , EFT_PAY_INST_CD2 , EFT_PAY_INST_CD3 , EFT_PAY_INST_CD4 , EFT_PAY_INST_REF1 , EFT_PAY_INST_REF2 , PMT_FIELD1 , PMT_FIELD2 , PMT_FIELD3 , REPETITVE_TRNFR_CD , DRAWDOWN_FLG , CREATED_BY_USER , PAY_CYCLE , PAY_CYCLE_SEQ_NUM , BATCH_NAME , IN_PROCESS_FLG , MANDATE_BU , PMT_MANDATE_ID , SEQ_NUM , CAN_LAYOUT , PMT_REASON , CAN_REASON , ORG_PMT_ID , RVL_LAYOUT , RVL_REASON , SEQUENCE_TYPE , CD , PRTRY , KEY_CHAR_40_01 , KEY_CHAR_40_02 , KEY_CHAR_40_03 , KEY_CHAR_40_04 , KEY_CHAR_40_05 , KEY_CHAR_40_06 , KEY_CHAR_40_07 , KEY_CHAR_40_08 , KEY_CHAR_40_09 , KEY_CHAR_40_10 , KEY_CHAR_40_11 , KEY_CHAR_40_12 , KEY_CHAR_40_13 , KEY_CHAR_40_14 , KEY_CHAR_40_15 , KEY_CHAR_40_16 , KEY_CHAR_40_17 , KEY_CHAR_40_18 , KEY_CHAR_40_19 , KEY_CHAR_40_20 , KEY_DATE_01 , KEY_DATE_02 , KEY_DATE_03 , KEY_DATE_04 , KEY_DATE_05 , KEY_DTTM_01 , KEY_DTTM_02 , KEY_DTTM_03 , KEY_DTTM_04 , KEY_DTTM_05 , KEY_SIGN_NUM_01 , KEY_SIGN_NUM_02 , KEY_SIGN_NUM_03 , KEY_SIGN_NUM_04 , KEY_SIGN_NUM_05 , KEY_SIGN_NUM_06 , KEY_SIGN_NUM_07 , KEY_SIGN_NUM_08 , KEY_SIGN_NUM_09 , KEY_SIGN_NUM_10 , KEY_SIGN_NUM_11 , KEY_SIGN_NUM_12 , KEY_SIGN_NUM_13 , KEY_SIGN_NUM_14 , KEY_SIGN_NUM_15 , KEY_LONG_01 , LASTUPDDTTM , LASTUPDOPRID FROM PS_GP_PAYMENT_FG WHERE PMT_TYPE = '02'

# 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 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
12 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID
13 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
14 RECIPIENT_NAME Character(30) VARCHAR2(30) NOT NULL Recipient Name
15 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
16 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
17 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
18 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
19 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
20 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
21 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
22 PMT_TYPE Character(2) VARCHAR2(2) NOT NULL Payment Type
01=Net Pay Distribution
02=General Recipient Deduction
03=Individual Recipient Deduction
23 GP_ADDENDA_VALUE Character(254) VARCHAR2(254) NOT NULL Addenda Value use for Bank Statement Accounting
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 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
30 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
31 PYMT_ID Character(6) VARCHAR2(6) NOT NULL Payment Identification
32 PYMT_NBR Number(18,0) DECIMAL(18) NOT NULL Payment Number
33 FILE_ID Character(30) VARCHAR2(30) NOT NULL File Identifier
34 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=Canceled
E=Error
L=Awaiting Dispatch
P=Paid
R=Received by Bank
S=Dispatched to Bank
35 GP_PMT_GEN_ID Character(20) VARCHAR2(20) NOT NULL Paymentt Generation Id
36 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
37 PMT_MSG_ID Character(15) VARCHAR2(15) NOT NULL Identification for the instance of a PAYMENT_REQUEST message (SEPA/Financial Gateway)
38 PMT_SEQ_NUM Number(7,0) INTEGER NOT NULL Sequence number which must be unique for the PMT_MSG_ID (SEPA/Financial Gateway)
39 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source system this transaction is originating from (SEPA/Financial Gateway)
40 SRC_REF_ID Character(20) VARCHAR2(20) NOT NULL Identifier of payment in source system, searchable field on payment inquiry
41 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
42 AMOUNT_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Amount Currency (SEPA/Financial Gateway)
43 PYMNT_DT Date(10) DATE Date the payment should be sent to the bank for execution
44 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
45 ESTIMATED_DUE_DATE Date(10) DATE Estimated due date
46 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
47 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
48 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL Bank account.
49 GP_SRC_ACCT_NUM Character(35) VARCHAR2(35) NOT NULL Source Account Number (SEPA/Financial Gateway)
50 GP_SRC_BANK_ID Character(11) VARCHAR2(11) NOT NULL Source Bank ID (SEPA/Financial Gateway)
51 GP_SRC_COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Financial Gateway (SEPA)
52 GP_SRC_BANK_CD Character(11) VARCHAR2(11) NOT NULL Financial Gateway (SEPA)
53 GP_SRC_BIC Character(11) VARCHAR2(11) NOT NULL Source Bank Identifier Code (SEPA/Financial Gateway)
54 GP_SRC_BRANCH Character(17) VARCHAR2(17) NOT NULL Financial Gateway (SEPA)
55 GP_SRC_CHK_DIGIT Character(2) VARCHAR2(2) NOT NULL Financial Gateway (SEPA)
56 GP_SRC_IBANCHKDGT Character(2) VARCHAR2(2) NOT NULL Financial Gateway (SEPA)
57 GP_SRC_ACCT_NAME Character(50) VARCHAR2(50) NOT NULL Financial Gateway (SEPA)
58 GP_SRC_IBAN_ID Character(34) VARCHAR2(34) NOT NULL Financial Gateway (SEPA)
59 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Type or Method of payment. Indicator as to how the payment should be handled
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Customer Initiated Draft
CHK=System Check
DD=Direct Debit
DFT=Vendor Initiated Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire Flat File
WIR=Wire Report

Default Value: EFT

60 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format payment name. (SEPA/Financial Gateway)
61 PRENOTE_FLAG Character(1) VARCHAR2(1) NOT NULL Prenotification flag for Payments to the Financial Gateway
62 PAY_IMMEDIATELY Character(1) VARCHAR2(1) NOT NULL Pay Immediately flag for Payments to the Financial Gateway
63 GP_DEST_ACCT_NUM Character(35) VARCHAR2(35) NOT NULL Used to store the destination Account Number. (SEPA/Financial Gateway)
64 GP_DEST_BANK_ID Character(11) VARCHAR2(11) NOT NULL Used to store the destination Bank ID Number. (SEPA/Financial Gateway)
65 GP_DEST_COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Financial Gateway (SEPA)
66 GP_DEST_BANK_CD Character(11) VARCHAR2(11) NOT NULL Financial Gateway (SEPA)
67 GP_DEST_BIC Character(11) VARCHAR2(11) NOT NULL Used to store the destination Bank Identifier Code. (SEPA/Financial Gateway)
68 GP_DEST_BRANCH Character(17) VARCHAR2(17) NOT NULL Financial Gateway (SEPA)
69 GP_DEST_CHK_DIGIT Character(2) VARCHAR2(2) NOT NULL Financial Gateway (SEPA)
70 GP_DEST_IBANCHKDGT Character(2) VARCHAR2(2) NOT NULL Financial Gateway (SEPA)
71 GP_DEST_ACCT_NAME Character(50) VARCHAR2(50) NOT NULL Financial Gateway (SEPA)
72 GP_DEST_IBAN_ID Character(34) VARCHAR2(34) NOT NULL Financial Gateway (SEPA)
73 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
74 PARTY_ID_TYPE Character(4) VARCHAR2(4) NOT NULL An identifier indicating the type of Payee Party (SEPA/Financial Gateway)
75 PARTY_SETID Character(5) VARCHAR2(5) NOT NULL SetID
76 PARTY_ID Character(30) VARCHAR2(30) NOT NULL Payee Id for Payments to the Financial Gateway
77 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
78 NAME1_AC Character(40) VARCHAR2(40) NOT NULL Name 1 Alternate Char Set
79 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
80 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL Standard Number Id
81 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard Number Id Qualifier
82 EFT_PYMNT_FMT_CD Character(3) VARCHAR2(3) NOT NULL Payment Format
00=Standard SWIFT transfer
10=Urgent SWIFT
15=Euro-Transfer
21=Check, w/ receipt confirmation
22=Check, Urgent
23=Check, urgent w/ receipt
40=Postal Order
CTX=Corp Trade Exchange
PBC=Check, standard
PPD=Prearranged Pay & Deposit
WRT=Wire Transfer
83 EFT_RTNG_FLG Character(1) VARCHAR2(1) NOT NULL Complex Routing
D=Use DFI ID
N=None
R=Use Complex Routing
84 EFT_RTNG_STATUS Character(1) VARCHAR2(1) NOT NULL Routing Status
C=Complete
I=Incomplete
85 EFT_TRANS_HANDLING Character(1) VARCHAR2(1) NOT NULL Transaction Handling
D=Payment Only
P=Prenotification
X=Payment and Advice
86 EFT_DOM_COSTS_CD Character(1) VARCHAR2(1) NOT NULL Domestic Costs
1=Payer's Domestic Account
2=Payer's Foreign Account
3=Payee's Account
4=Trans Exp to Pyr, other to Pye
87 EFT_CORR_COSTS_CD Character(1) VARCHAR2(1) NOT NULL Correspondent's Costs
1=Payer's Domestic Account
2=Payer's Foreign Account
3=Payee's Account
88 EFT_CROSSED_CHECK Character(1) VARCHAR2(1) NOT NULL Crossed Check
89 EFT_CHECK_FWRD_CD Character(1) VARCHAR2(1) NOT NULL Check Forwarding
1=Payer's Bank
2=Payer
3=Payee
4=Payee's Bank
90 EFT_CHECK_DRAW_CD Character(1) VARCHAR2(1) NOT NULL Bank Check Drawn On
1=Payer's Bank
2=Payee's Bank
91 EFT_PAY_INST_CD1 Character(3) VARCHAR2(3) NOT NULL Payment Instruction 1
92 EFT_PAY_INST_CD2 Character(3) VARCHAR2(3) NOT NULL Payment Instruction 2
93 EFT_PAY_INST_CD3 Character(3) VARCHAR2(3) NOT NULL Payment Instruction 3
94 EFT_PAY_INST_CD4 Character(3) VARCHAR2(3) NOT NULL Payment Instruction 4
95 EFT_PAY_INST_REF1 Character(40) VARCHAR2(40) NOT NULL Payment Instruction Ref 1
96 EFT_PAY_INST_REF2 Character(40) VARCHAR2(40) NOT NULL Payment Instruction Ref 2
97 PMT_FIELD1 Character(30) VARCHAR2(30) NOT NULL Payment field
98 PMT_FIELD2 Character(30) VARCHAR2(30) NOT NULL Payment field
99 PMT_FIELD3 Character(30) VARCHAR2(30) NOT NULL Payment field
100 REPETITVE_TRNFR_CD Character(15) VARCHAR2(15) NOT NULL Repetitive Transfer Code assigned by customers Bank
101 DRAWDOWN_FLG Character(1) VARCHAR2(1) NOT NULL Drawdown Transfer Flag, either yes or no.
102 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
103 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
104 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
105 BATCH_NAME Character(30) VARCHAR2(30) NOT NULL Batch Name for Payments to the Financial Gateway
106 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In Process
107 MANDATE_BU Character(5) VARCHAR2(5) NOT NULL Mandate Business Unit for Payments to the Financial Gateway
108 PMT_MANDATE_ID Character(15) VARCHAR2(15) NOT NULL Mandate direct debit
109 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
110 CAN_LAYOUT Character(10) VARCHAR2(10) NOT NULL Format ID
111 PMT_REASON Character(34) VARCHAR2(34) NOT NULL Reversal Reason - used when payments are reversed. Will store Reversal Reason Code. Reason Codes: AC04 - ClosedAccountNumber AG02 - InvalidBankOperationCode AM05 - Duplication MD01 - NoMandate MD05 - CollectionNotDue
112 CAN_REASON Character(34) VARCHAR2(34) NOT NULL Cancellation Reason - used when payments are cancelled. Will store Cancellation Reason Code. Reason Codes: AGNT - IncorrectAgent CURR - IncorrectCurrency CUST - RequestedByCustomer DUPL - DuplicatePayment SUSP - SuspiciousPayment UPAY - UnduePayment
113 ORG_PMT_ID Character(15) VARCHAR2(15) NOT NULL Original Transaction / Payment ID - used for reversal process.
114 RVL_LAYOUT Character(10) VARCHAR2(10) NOT NULL Format ID
115 RVL_REASON Character(34) VARCHAR2(34) NOT NULL Reversal Reason - used when payments are reversed. Will store Reversal Reason Code. Reason Codes: AC04 - ClosedAccountNumber AG02 - InvalidBankOperationCode AM05 - Duplication MD01 - NoMandate MD05 - CollectionNotDue
116 SEQUENCE_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies the direct debit sequence, eg, first, recurrent, final or one-off.
117 CD Character(30) VARCHAR2(30) NOT NULL Field Information to be sent to FG
118 PRTRY Character(30) VARCHAR2(30) NOT NULL Field Information to be sent to FG
119 KEY_CHAR_40_01 Character(40) VARCHAR2(40) NOT NULL Key Char 40/01
120 KEY_CHAR_40_02 Character(40) VARCHAR2(40) NOT NULL Key Char 40/02
121 KEY_CHAR_40_03 Character(40) VARCHAR2(40) NOT NULL Key Char 40/03
122 KEY_CHAR_40_04 Character(40) VARCHAR2(40) NOT NULL Key Char 40/04
123 KEY_CHAR_40_05 Character(40) VARCHAR2(40) NOT NULL Key Char 40/05
124 KEY_CHAR_40_06 Character(40) VARCHAR2(40) NOT NULL Key_Char 40/06
125 KEY_CHAR_40_07 Character(40) VARCHAR2(40) NOT NULL Key Char 40/07
126 KEY_CHAR_40_08 Character(40) VARCHAR2(40) NOT NULL Key Char 40/08
127 KEY_CHAR_40_09 Character(40) VARCHAR2(40) NOT NULL Key Char 40/09
128 KEY_CHAR_40_10 Character(40) VARCHAR2(40) NOT NULL Key Char 40/10
129 KEY_CHAR_40_11 Character(40) VARCHAR2(40) NOT NULL This is used as a flexible / configurable character field (SEPA/Financial Gateway)
130 KEY_CHAR_40_12 Character(40) VARCHAR2(40) NOT NULL This is used as a flexible / configurable character field (SEPA/Financial Gateway)
131 KEY_CHAR_40_13 Character(40) VARCHAR2(40) NOT NULL This is used as a flexible / configurable character field (SEPA/Financial Gateway)
132 KEY_CHAR_40_14 Character(40) VARCHAR2(40) NOT NULL This is used as a flexible / configurable character field (SEPA/Financial Gateway)
133 KEY_CHAR_40_15 Character(40) VARCHAR2(40) NOT NULL This is used as a flexible / configurable character field (SEPA/Financial Gateway)
134 KEY_CHAR_40_16 Character(40) VARCHAR2(40) NOT NULL This is used as a flexible / configurable character field (SEPA/Financial Gateway)
135 KEY_CHAR_40_17 Character(40) VARCHAR2(40) NOT NULL This is used as a flexible / configurable character field (SEPA/Financial Gateway)
136 KEY_CHAR_40_18 Character(40) VARCHAR2(40) NOT NULL This is used as a flexible / configurable character field (SEPA/Financial Gateway)
137 KEY_CHAR_40_19 Character(40) VARCHAR2(40) NOT NULL This is used as a flexible / configurable character field (SEPA/Financial Gateway)
138 KEY_CHAR_40_20 Character(40) VARCHAR2(40) NOT NULL This is used as a flexible / configurable character field (SEPA/Financial Gateway)
139 KEY_DATE_01 Date(10) DATE This is used as a flexible / configurable date field (SEPA/Financial Gateway)
140 KEY_DATE_02 Date(10) DATE This is used as a flexible / configurable date field (SEPA/Financial Gateway)
141 KEY_DATE_03 Date(10) DATE This is used as a flexible / configurable date field (SEPA/Financial Gateway)
142 KEY_DATE_04 Date(10) DATE This is used as a flexible / configurable date field (SEPA/Financial Gateway)
143 KEY_DATE_05 Date(10) DATE This is used as a flexible / configurable date field (SEPA/Financial Gateway)
144 KEY_DTTM_01 DateTime(26) TIMESTAMP This is used as a flexible / configurable datetime field (SEPA/Financial Gateway)
145 KEY_DTTM_02 DateTime(26) TIMESTAMP This is used as a flexible / configurable datetime field (SEPA/Financial Gateway)
146 KEY_DTTM_03 DateTime(26) TIMESTAMP This is used as a flexible / configurable datetime field (SEPA/Financial Gateway)
147 KEY_DTTM_04 DateTime(26) TIMESTAMP This is used as a flexible / configurable datetime field (SEPA/Financial Gateway)
148 KEY_DTTM_05 DateTime(26) TIMESTAMP This is used as a flexible / configurable datetime field (SEPA/Financial Gateway)
149 KEY_SIGN_NUM_01 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
150 KEY_SIGN_NUM_02 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
151 KEY_SIGN_NUM_03 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
152 KEY_SIGN_NUM_04 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
153 KEY_SIGN_NUM_05 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
154 KEY_SIGN_NUM_06 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
155 KEY_SIGN_NUM_07 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
156 KEY_SIGN_NUM_08 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
157 KEY_SIGN_NUM_09 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
158 KEY_SIGN_NUM_10 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
159 KEY_SIGN_NUM_11 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
160 KEY_SIGN_NUM_12 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
161 KEY_SIGN_NUM_13 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
162 KEY_SIGN_NUM_14 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
163 KEY_SIGN_NUM_15 Signed Number(20,6) DECIMAL(18,6) NOT NULL This is used as a flexible / configurable signed number field (SEPA/Financial Gateway)
164 KEY_LONG_01 Long Character CLOB This is used as a flexible / configurable long character field (SEPA/Financial Gateway)
165 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.
166 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.