GP_NRP_FG_H_AD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
3	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
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 Record
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	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
10	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
11	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
12	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
13	RECIPIENT_TAG	Number(3,0)	SMALLINT NOT NULL	Used to identify recipients for E/D, PI
14	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
15	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID
16	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
17	RECIPIENT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Recipient Name
18	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
19	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
20	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
21	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
22	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
23	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
24	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
25	PMT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Payment Type 01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction
26	GP_ADDENDA_VALUE	Character(254)	VARCHAR2(254) NOT NULL	Addenda Value use for Bank Statement Accounting
27	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
28	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
29	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
30	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
31	DEBIT_DT	Date(10)	DATE	Debit Date
32	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
33	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
34	PYMT_ID	Character(6)	VARCHAR2(6) NOT NULL	Payment Identification
35	PYMT_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Payment Number
36	FILE_ID	Character(30)	VARCHAR2(30) NOT NULL	File Identifier
37	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
38	GP_PMT_GEN_ID	Character(20)	VARCHAR2(20) NOT NULL	Payment Generation ID
39	PRCS_STATUS	Number(10,0)	DECIMAL(10) NOT NULL	Processing Status of SEPA
40	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
41	PMT_MSG_ID	Character(15)	VARCHAR2(15) NOT NULL	Identification for the instance of a PAYMENT_REQUEST message (SEPA/Financial Gateway)
42	PMT_SEQ_NUM	Number(7,0)	INTEGER NOT NULL	Sequence number which must be unique for the PMT_MSG_ID (SEPA/Financial Gateway)
43	PMT_SOURCE	Character(10)	VARCHAR2(10) NOT NULL	Source system this transaction is originating from (SEPA/Financial Gateway)
44	SRC_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Identifier of payment in source system, searchable field on payment inquiry
45	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
46	AMOUNT_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Amount Currency (SEPA/Financial Gateway)
47	PYMNT_DT	Date(10)	DATE	Date the payment should be sent to the bank for execution
48	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
49	ESTIMATED_DUE_DATE	Date(10)	DATE	Estimated due date
50	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
51	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
52	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	Bank account.
53	GP_SRC_ACCT_NUM	Character(35)	VARCHAR2(35) NOT NULL	Source Account Number (SEPA/Financial Gateway)
54	GP_SRC_BANK_ID	Character(11)	VARCHAR2(11) NOT NULL	Source Bank ID (SEPA/Financial Gateway)
55	GP_SRC_COUNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Financial Gateway (SEPA)
56	GP_SRC_BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Financial Gateway (SEPA)
57	GP_SRC_BIC	Character(11)	VARCHAR2(11) NOT NULL	Source Bank Identifier Code (SEPA/Financial Gateway)
58	GP_SRC_BRANCH	Character(17)	VARCHAR2(17) NOT NULL	Financial Gateway (SEPA)
59	GP_SRC_CHK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Financial Gateway (SEPA)
60	GP_SRC_IBANCHKDGT	Character(2)	VARCHAR2(2) NOT NULL	Financial Gateway (SEPA)
61	GP_SRC_ACCT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Financial Gateway (SEPA)
62	GP_SRC_IBAN_ID	Character(34)	VARCHAR2(34) NOT NULL	Financial Gateway (SEPA)
63	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
64	FORMAT_ID	Character(10)	VARCHAR2(10) NOT NULL	Format payment name. (SEPA/Financial Gateway)
65	PRENOTE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Prenotification flag for Payments to the Financial Gateway
66	PAY_IMMEDIATELY	Character(1)	VARCHAR2(1) NOT NULL	Pay Immediately flag for Payments to the Financial Gateway
67	GP_DEST_ACCT_NUM	Character(35)	VARCHAR2(35) NOT NULL	Used to store the destination Account Number. (SEPA/Financial Gateway)
68	GP_DEST_BANK_ID	Character(11)	VARCHAR2(11) NOT NULL	Used to store the destination Bank ID Number. (SEPA/Financial Gateway)
69	GP_DEST_COUNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Financial Gateway (SEPA)
70	GP_DEST_BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Financial Gateway (SEPA)
71	GP_DEST_BIC	Character(11)	VARCHAR2(11) NOT NULL	Used to store the destination Bank Identifier Code. (SEPA/Financial Gateway)
72	GP_DEST_BRANCH	Character(17)	VARCHAR2(17) NOT NULL	Financial Gateway (SEPA)
73	GP_DEST_CHK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Financial Gateway (SEPA)
74	GP_DEST_IBANCHKDGT	Character(2)	VARCHAR2(2) NOT NULL	Financial Gateway (SEPA)
75	GP_DEST_ACCT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Financial Gateway (SEPA)
76	GP_DEST_IBAN_ID	Character(34)	VARCHAR2(34) NOT NULL	Financial Gateway (SEPA)
77	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
78	PARTY_ID_TYPE	Character(4)	VARCHAR2(4) NOT NULL	An identifier indicating the type of Payee Party (SEPA/Financial Gateway)
79	PARTY_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
80	PARTY_ID	Character(30)	VARCHAR2(30) NOT NULL	Payee Id for Payments to the Financial Gateway
81	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
82	NAME1_AC	Character(40)	VARCHAR2(40) NOT NULL	Name 1 Alternate Char Set
83	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
84	STD_ID_NUM	Character(35)	VARCHAR2(35) NOT NULL	Standard Number Id
85	STD_ID_NUM_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Standard Number Id Qualifier ACN=Company Number - Australia BEI=BEI Identifier CCM=Municipal Reg Number - Brazil CGC=Comp Tax Reg Number - Brazil CID=Company Identification Number CPF=Ind Tax Reg Number - Brazil CRI=Creditor Identification DB=DUNS Number (With Edit) DNS=DUNS Number (No Edit) DP4=DUNS+4 Suffix EIN=Employer ID Number FIC=Fiscal ID - Company - Italy FII=Fiscal ID - Indiv - Italy GLN=Global Location Number IE=State Reg Number - Brazil LER=Legal Entity Registration Num NIC=NIC Number - France NIF=Fiscal ID Number - Spain SRN=SIREN Number - France SRT=SIRET Number - France TIN=Tax Identification Number W2=W2 Identification Number
86	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
87	EFT_RTNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Complex Routing D=Use DFI ID N=None R=Use Complex Routing
88	EFT_RTNG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Routing Status C=Complete I=Incomplete
89	EFT_TRANS_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Transaction Handling D=Payment Only P=Prenotification X=Payment and Advice
90	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
91	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
92	EFT_CROSSED_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Crossed Check
93	EFT_CHECK_FWRD_CD	Character(1)	VARCHAR2(1) NOT NULL	Check Forwarding 1=Payer's Bank 2=Payer 3=Payee 4=Payee's Bank
94	EFT_CHECK_DRAW_CD	Character(1)	VARCHAR2(1) NOT NULL	Bank Check Drawn On 1=Payer's Bank 2=Payee's Bank
95	EFT_PAY_INST_CD1	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 1
96	EFT_PAY_INST_CD2	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 2
97	EFT_PAY_INST_CD3	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 3
98	EFT_PAY_INST_CD4	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 4
99	EFT_PAY_INST_REF1	Character(40)	VARCHAR2(40) NOT NULL	Payment Instruction Ref 1
100	EFT_PAY_INST_REF2	Character(40)	VARCHAR2(40) NOT NULL	Payment Instruction Ref 2
101	PMT_FIELD1	Character(30)	VARCHAR2(30) NOT NULL	Payment field
102	PMT_FIELD2	Character(30)	VARCHAR2(30) NOT NULL	Payment field
103	PMT_FIELD3	Character(30)	VARCHAR2(30) NOT NULL	Payment field
104	REPETITVE_TRNFR_CD	Character(15)	VARCHAR2(15) NOT NULL	Repetitive Transfer Code assigned by customers Bank
105	DRAWDOWN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Drawdown Transfer Flag, either yes or no. N=No Y=Yes
106	CREATED_BY_USER	Character(30)	VARCHAR2(30) NOT NULL	Created By
107	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
108	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
109	BATCH_NAME	Character(30)	VARCHAR2(30) NOT NULL	Batch Name for Payments to the Financial Gateway
110	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In Process
111	MANDATE_BU	Character(5)	VARCHAR2(5) NOT NULL	Mandate Business Unit for Payments to the Financial Gateway
112	PMT_MANDATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Mandate direct debit
113	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
114	CAN_LAYOUT	Character(10)	VARCHAR2(10) NOT NULL	Format ID
115	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
116	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
117	ORG_PMT_ID	Character(15)	VARCHAR2(15) NOT NULL	Original Transaction / Payment ID - used for reversal process.
118	RVL_LAYOUT	Character(10)	VARCHAR2(10) NOT NULL	Format ID
119	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
120	SEQUENCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies the direct debit sequence, eg, first, recurrent, final or one-off. F=First Payment N=Final Payment O=OneOff Payment R=Recurring Payment
121	CD	Character(30)	VARCHAR2(30) NOT NULL	Field Information to be sent to FG
122	PRTRY	Character(30)	VARCHAR2(30) NOT NULL	Field Information to be sent to FG
123	KEY_CHAR_40_01	Character(40)	VARCHAR2(40) NOT NULL	Key Char 40/01
124	KEY_CHAR_40_02	Character(40)	VARCHAR2(40) NOT NULL	Key Char 40/02
125	KEY_CHAR_40_03	Character(40)	VARCHAR2(40) NOT NULL	Key Char 40/03
126	KEY_CHAR_40_04	Character(40)	VARCHAR2(40) NOT NULL	Key Char 40/04
127	KEY_CHAR_40_05	Character(40)	VARCHAR2(40) NOT NULL	Key Char 40/05
128	KEY_CHAR_40_06	Character(40)	VARCHAR2(40) NOT NULL	Key_Char 40/06
129	KEY_CHAR_40_07	Character(40)	VARCHAR2(40) NOT NULL	Key Char 40/07
130	KEY_CHAR_40_08	Character(40)	VARCHAR2(40) NOT NULL	Key Char 40/08
131	KEY_CHAR_40_09	Character(40)	VARCHAR2(40) NOT NULL	Key Char 40/09
132	KEY_CHAR_40_10	Character(40)	VARCHAR2(40) NOT NULL	Key Char 40/10
133	KEY_CHAR_40_11	Character(40)	VARCHAR2(40) NOT NULL	This is used as a flexible / configurable character field (SEPA/Financial Gateway)
134	KEY_CHAR_40_12	Character(40)	VARCHAR2(40) NOT NULL	This is used as a flexible / configurable character field (SEPA/Financial Gateway)
135	KEY_CHAR_40_13	Character(40)	VARCHAR2(40) NOT NULL	This is used as a flexible / configurable character field (SEPA/Financial Gateway)
136	KEY_CHAR_40_14	Character(40)	VARCHAR2(40) NOT NULL	This is used as a flexible / configurable character field (SEPA/Financial Gateway)
137	KEY_CHAR_40_15	Character(40)	VARCHAR2(40) NOT NULL	This is used as a flexible / configurable character field (SEPA/Financial Gateway)
138	KEY_CHAR_40_16	Character(40)	VARCHAR2(40) NOT NULL	This is used as a flexible / configurable character field (SEPA/Financial Gateway)
139	KEY_CHAR_40_17	Character(40)	VARCHAR2(40) NOT NULL	This is used as a flexible / configurable character field (SEPA/Financial Gateway)
140	KEY_CHAR_40_18	Character(40)	VARCHAR2(40) NOT NULL	This is used as a flexible / configurable character field (SEPA/Financial Gateway)
141	KEY_CHAR_40_19	Character(40)	VARCHAR2(40) NOT NULL	This is used as a flexible / configurable character field (SEPA/Financial Gateway)
142	KEY_CHAR_40_20	Character(40)	VARCHAR2(40) NOT NULL	This is used as a flexible / configurable character field (SEPA/Financial Gateway)
143	KEY_DATE_01	Date(10)	DATE	This is used as a flexible / configurable date field (SEPA/Financial Gateway)
144	KEY_DATE_02	Date(10)	DATE	This is used as a flexible / configurable date field (SEPA/Financial Gateway)
145	KEY_DATE_03	Date(10)	DATE	This is used as a flexible / configurable date field (SEPA/Financial Gateway)
146	KEY_DATE_04	Date(10)	DATE	This is used as a flexible / configurable date field (SEPA/Financial Gateway)
147	KEY_DATE_05	Date(10)	DATE	This is used as a flexible / configurable date field (SEPA/Financial Gateway)
148	KEY_DTTM_01	DateTime(26)	TIMESTAMP	This is used as a flexible / configurable datetime field (SEPA/Financial Gateway)
149	KEY_DTTM_02	DateTime(26)	TIMESTAMP	This is used as a flexible / configurable datetime field (SEPA/Financial Gateway)
150	KEY_DTTM_03	DateTime(26)	TIMESTAMP	This is used as a flexible / configurable datetime field (SEPA/Financial Gateway)
151	KEY_DTTM_04	DateTime(26)	TIMESTAMP	This is used as a flexible / configurable datetime field (SEPA/Financial Gateway)
152	KEY_DTTM_05	DateTime(26)	TIMESTAMP	This is used as a flexible / configurable datetime field (SEPA/Financial Gateway)
153	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)
154	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)
155	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)
156	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)
157	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)
158	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)
159	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)
160	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)
161	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)
162	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)
163	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)
164	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)
165	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)
166	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)
167	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)
168	KEY_LONG_01	Long Character	CLOB	This is used as a flexible / configurable long character field (SEPA/Financial Gateway)
169	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.
170	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.