| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 4 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 5 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 6 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 7 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 8 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 9 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 10 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 11 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 12 |
DSCNT_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Discount Amount
|
| 13 |
PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
|
| 14 |
PYMNT_MESSAGE |
Character(70) |
VARCHAR2(70) NOT NULL |
Payment Message
|
| 15 |
PYMNT_SEPARATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Payment
|
| 16 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 17 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 18 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 19 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 20 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 21 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 22 |
PYMNT_SELCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed
D=Negative Voucher Sum
E=Externally Paid
F=Federal Sanctions Error
I=In Process - EFT
N=Not Selected for Payment
O=Financial Sanctions Review
P=Paid
R=Requested for Payment
S=Settlement Payment
V=Convert Error
X=Canceled
Y=Prepaid
|
| 23 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 24 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 25 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 26 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 27 |
NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2
|
| 28 |
ALT_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Alternate Name 1
|
| 29 |
ALT_NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Alternate Name 2
|
| 30 |
PYMNT_GROUP_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Group Code
|
| 31 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 32 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 33 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 34 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 35 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 36 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 37 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 38 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 39 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 40 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 41 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 42 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 43 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 44 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 45 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 46 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 47 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 48 |
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
|
| 49 |
EFT_RTNG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Complex Routing
D=Use DFI ID
N=None
R=Use Complex Routing
Default Value: D
|
| 50 |
EFT_RTNG_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Routing Status
C=Complete
I=Incomplete
Default Value: I
|
| 51 |
EFT_TRANS_HANDLING |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Handling
D=Payment Only
P=Prenotification
X=Payment and Advice
Default Value: X
|
| 52 |
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
|
| 53 |
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
|
| 54 |
EFT_CROSSED_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Crossed Check
Y/N Table Edit
Default Value: N
|
| 55 |
EFT_CHECK_FWRD_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Forwarding
1=Payer's Bank
2=Payer
3=Payee
4=Payee's Bank
|
| 56 |
EFT_CHECK_DRAW_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Bank Check Drawn On
1=Payer's Bank
2=Payee's Bank
|
| 57 |
EFT_PAY_INST_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Instruction 1
ACC=/ACC/
BEN=/BENONLY/
CHK=/CHECK/
COR=/CORPTRAD/
HLD=/HOLD/
INT=/INT/
IRR=PAYMENT IRREVOCABLE
PHB=/PHONEBEN/
PHI=/PHONIBK/
PHN=/PHON/
RC1=ADV BEN W/CHARGES
RC2=ADV BEN W/O CHARGES
RCB=/RCB/
REC=/REC/
REJ=/REJT/
RET=BEN UNKNOWN RETURN
TEB=/TELEBEN/
TEI=/TELEIBK/
TEL=/TELE/
XFR=INTERCOMPANY TRANSFER
Prompt Table:
EFT_PAY_INST_VW
|
| 58 |
EFT_PAY_INST_CD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Instruction 2
Prompt Table:
EFT_PAY_INST_VW
|
| 59 |
EFT_PAY_INST_CD3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Instruction 3
Prompt Table:
EFT_PAY_INST_VW
|
| 60 |
EFT_PAY_INST_CD4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Instruction 4
Prompt Table:
EFT_PAY_INST_VW
|
| 61 |
EFT_PAY_INST_REF1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Payment Instruction Ref 1
|
| 62 |
EFT_PAY_INST_REF2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Payment Instruction Ref 2
|
| 63 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 64 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 65 |
PAID_AMT_GROSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Paid Amount
|
| 66 |
PAID_AMT_DSCNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount on Paid Amount
|
| 67 |
PAID_AMT_GROSS_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Payment Amount
|
| 68 |
PAID_AMT_DSCNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Paid Amount
|
| 69 |
PAID_AMT_BNK_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount - Base Bank Unit
|
| 70 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 71 |
CUR_RT_TYPE_PYMNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Currency Rate Type
|
| 72 |
PYMNT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is stored
|
| 73 |
PYMNT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is store
|
| 74 |
BASE_CURRENCY_BNK |
Character(3) |
VARCHAR2(3) NOT NULL |
The base currency of the subject bank general ledger business unit.
|
| 75 |
CUR_RT_TYPE_BNK |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 76 |
BNK_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange spot rate is stored either as
|
| 77 |
BNK_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange spot rate is store
|
| 78 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 79 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 80 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 81 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 82 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 83 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
|
| 84 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 85 |
VENDOR_NAME_SHORT |
Character(14) |
VARCHAR2(14) NOT NULL |
Short Vendor Name
|
| 86 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 87 |
GRP_AP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Control Group ID
|
| 88 |
SOURCE_TXN |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Transaction
|
| 89 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 90 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 91 |
PREFERRED_LANGUAGE |
Character(3) |
VARCHAR2(3) NOT NULL |
Preferred Language
ARA=Arabic
CFR=Canadian French
CZE=Czech
DAN=Danish
DUT=Dutch
E=English
ENG=English
ESP=Spanish
F=French
FIN=Finnish
FRA=French
GER=German
HUN=Hungarian
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
NOR=Norwegian
POL=Polish
POR=Portuguese
RUS=Russian
SVE=Swedish
THA=Thai
UKE=UK English
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 92 |
REMIT_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Bank Setid
|
| 93 |
REMIT_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Bank Code
|
| 94 |
REMIT_BNK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
Remit Bank Account
|
| 95 |
PRENOTE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Status
C=Confirmed
N=New
P=Pending
R=Rejected
S=Submitted
|
| 96 |
DSCNT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Amount
|
| 97 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
|
| 98 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 99 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
|
| 100 |
GRP_PYMNT_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Group by Payment Date
|
| 101 |
WTHD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
|
| 102 |
CUR_RT_TYPE_PAID |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Rate Type
|
| 103 |
PAID_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored either as
|
| 104 |
PAID_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is store
|
| 105 |
SPEC_PYMNT_EX_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Specify Pymnt Ex Rate
|
| 106 |
EFT_KEY_FIELD1 |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 107 |
EFT_KEY_FIELD2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Supplier ID
|
| 108 |
EFT_KEY_FIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier Location
|
| 109 |
EFT_KEY_FIELD4 |
Date(10) |
DATE |
Effective Date
|
| 110 |
EFT_KEY_FIELD5 |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Seq Number
|
| 111 |
EFT_KEY_FIELD6 |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Seq Number
|
| 112 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 113 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 114 |
DFT_SIGHT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Sight Code
Prompt Table:
APD_SIGHTCD_TBL
|
| 115 |
DFT_MAT_DT |
Date(10) |
DATE |
Draft Maturity Date
|
| 116 |
DFT_SCHED_MAT_DT |
Date(10) |
DATE |
Draft Scheduled Maturity Date
|
| 117 |
DFT_GROUP_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Group Code
|
| 118 |
DFT_MASTER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Master ID
|
| 119 |
DFT_CREATE_KEY |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Create Key
|
| 120 |
PYMNT_REASON_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Reason Code
|
| 121 |
SCHEDULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
|
| 122 |
LATE_CHRG_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Late Charge Code
|
| 123 |
LATE_CHRG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Charge Option
C=Compute Charges
N=Not Applicable
|
| 124 |
LATE_CHRG_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Amount
|
| 125 |
LATE_CHRG_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Amount Base
|
| 126 |
LATE_CHRG_DNIE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Denied
|
| 127 |
LATE_CHRG_DNIE_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid Base
|
| 128 |
LATE_CHRG_PAID |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid
|
| 129 |
LATE_CHRG_PAID_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Paid Base
|
| 130 |
ECN_DSCNT_DNIE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Denied
|
| 131 |
VOUCHER_ID_RELATED |
Character(8) |
VARCHAR2(8) NOT NULL |
Related Voucher
|
| 132 |
BUS_UNIT_RELATED |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 133 |
PYMNT_CNT_RELATED |
Number(5,0) |
INTEGER NOT NULL |
Payment
|
| 134 |
APPL_CREDIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Credit Status
A=Applied
N=Not Applicable
P=Pending
|
| 135 |
SINGLE_PYMNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Payment
Y/N Table Edit
Default Value: N
|
| 136 |
BANK_RPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Replacement Status
B=Invalid electronic bank setup
C=Bank currency not supported
L=Invalid bank layout
N=Not Replaced
P=Payment method not supported
R=Missing currency convert rates
S=Invalid Set ID
Y=Bank Replaced
|
| 137 |
IPAC_PYMNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
IPAC Payment flag - will indicate that a payment is for IPAC
Y/N Table Edit
Default Value: N
|
| 138 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 139 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|
| 140 |
PAY_SCHEDULE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Schedule Type
MAN=Manual
OTH=Other Non Transportation
TRN=Transportation
|