| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|
| 4 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 5 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 6 |
EX_PYMNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses Payment Type
A=Advance Distribution
E=Employee Payment
V=Supplier Payment
|
| 7 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 8 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All
S=Only purge items with at least
|
| 9 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 10 |
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
Default Value: N
|
| 11 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 12 |
PYMNT_ID_REF |
Character(20) |
VARCHAR2(20) NOT NULL |
Payment Reference
|
| 13 |
PYMNT_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Payment
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 14 |
PYMNT_NOTIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Notification
|
| 15 |
POST_STATUS_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied
P=Posted
U=Unposted
|
| 16 |
PYMNT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Status
A=Alignment
E=ACH/EFT Prenote
L=Stale Dated Payment
N=Reprinted with same ref number
O=Overflow
P=Paid
R=Replaced
S=Stopped
T=Undo Escheatment
U=Undo Cancel
V=Void
W=Escheated Check
X=Deleted
|
| 17 |
CANCEL_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Action
C=Do Not Reissue/Close Liability
H=Re-Open Voucher(s)/Put on Hold
N=No Cancel Action
P=Processed
R=Re-Open Voucher(s)/Re-Issue
S=Stale Dated Check
W=Escheated
|
| 18 |
CANCEL_DT |
Date(10) |
DATE |
Date Cancelled
|
| 19 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 20 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 21 |
APPROVAL_DT |
Date(10) |
DATE |
Date of Approval
Default Value: %date
|
| 22 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 23 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 24 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 25 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 26 |
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.
|
| 27 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 28 |
STTLMNT_DT_EST |
Date(10) |
DATE |
Date in which a deal transaction is estimated to be settled with a counterparty.
|
| 29 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 30 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 31 |
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
|
| 32 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 33 |
BUSINESS_UNIT_BANK |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit associated with a given bank/counterparty.
|
| 34 |
SOURCE_TXN |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Transaction
|
| 35 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 36 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 37 |
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
|
| 38 |
REMIT_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Bank Setid
|
| 39 |
REMIT_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Bank Code
|
| 40 |
REMIT_BNK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
Remit Bank Account
|
| 41 |
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
|
| 42 |
EFT_RTNG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Complex Routing
D=Use DFI ID
N=None
R=Use Complex Routing
Default Value: D
|
| 43 |
EFT_RTNG_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Routing Status
C=Complete
I=Incomplete
Default Value: I
|
| 44 |
EFT_TRANS_HANDLING |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Handling
D=Payment Only
P=Prenotification
X=Payment and Advice
Default Value: X
|
| 45 |
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
|
| 46 |
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
|
| 47 |
EFT_CROSSED_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Crossed Check
Y/N Table Edit
Default Value: N
|
| 48 |
EFT_CHECK_FWRD_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Forwarding
1=Payer's Bank
2=Payer
3=Payee
4=Payee's Bank
|
| 49 |
EFT_CHECK_DRAW_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Bank Check Drawn On
1=Payer's Bank
2=Payee's Bank
|
| 50 |
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
|
| 51 |
EFT_PAY_INST_CD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Instruction 2
Prompt Table:
EFT_PAY_INST_VW
|
| 52 |
EFT_PAY_INST_CD3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Instruction 3
Prompt Table:
EFT_PAY_INST_VW
|
| 53 |
EFT_PAY_INST_CD4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Instruction 4
Prompt Table:
EFT_PAY_INST_VW
|
| 54 |
EFT_PAY_INST_REF1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Payment Instruction Ref 1
|
| 55 |
EFT_PAY_INST_REF2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Payment Instruction Ref 2
|
| 56 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 57 |
NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2
|
| 58 |
NAME1_AC |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1 Alternate Char Set
|
| 59 |
NAME2_AC |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2 Alternate Char Set
|
| 60 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 61 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 62 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 63 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 64 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 65 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 66 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 67 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 68 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 69 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 70 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 71 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 72 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 73 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 74 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 75 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 76 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 77 |
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
|
| 78 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 79 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 80 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 81 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 82 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 83 |
VENDOR_NAME_SHORT |
Character(14) |
VARCHAR2(14) NOT NULL |
Short Vendor Name
|
| 84 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 85 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 86 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 87 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 88 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 89 |
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. "
|
| 90 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 91 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 92 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 93 |
BASE_CURRENCY_BNK |
Character(3) |
VARCHAR2(3) NOT NULL |
The base currency of the subject bank general ledger business unit.
|
| 94 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 95 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 96 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 97 |
PYMNT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is stored
|
| 98 |
PYMNT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is store
|
| 99 |
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
|
| 100 |
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
|
| 101 |
CUR_RT_TYPE_PYMNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Currency Rate Type
|
| 102 |
EXCHNG_RT_BNK |
Number(16,7) |
DECIMAL(15,7) NOT NULL |
Exchange Rate
|
| 103 |
RT_TYPE_BNK |
Character(5) |
VARCHAR2(5) NOT NULL |
Rate Type
|
| 104 |
CUR_EXCHNG_RT_PYMT |
Number(16,7) |
DECIMAL(15,7) NOT NULL |
Payment Exchange Rate
|
| 105 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 106 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 107 |
PAID_AMT_BNK_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount - Base Bank Unit
|
| 108 |
GROSSUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross Up Indicator
|
| 109 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 110 |
EX_PYRL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Expense Payroll Status
F=Confirmed by Payroll
N=None
P=Published to Payroll
R=Rejected by Payroll
T=In Process
V=Reversal
|
| 111 |
EX_PYMNT_DEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether employee expenses reimbursement will be processed by Payroll or Accounts Payables.
A=Accounts Payable
P=Payroll
|
| 112 |
REJECTED_REASON |
Character(2) |
VARCHAR2(2) NOT NULL |
Rejected Reason
01=Invalid Earnings Code
02=Invalid Empl. ID or Empl. Rec#
03=Invalid Currency Code
04=Problem Loading Transaction
05=Transaction Already Exist
06=Other line(s) rejected.
|
| 113 |
DATE_ACKNOWLEDGE |
DateTime(26) |
TIMESTAMP |
Acknowledgment Datetime stamp
|
| 114 |
PAYCHECK_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Paycheck Number
|
| 115 |
FORM_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Form Identification
|
| 116 |
RECEIPT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receipt ID
|
| 117 |
REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Reference ID
|
| 118 |
PYMNT_MESSAGE |
Character(70) |
VARCHAR2(70) NOT NULL |
Payment Message
|
| 119 |
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.
|