| # |
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 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Default Value: OPR_BANK_VW_AP.BANK_SETID
|
| 4 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_VW2
|
| 5 |
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
Prompt Table:
BANK_ACCT_VW
|
| 6 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 7 |
PYMNT_ID_REF |
Character(20) |
VARCHAR2(20) NOT NULL |
Payment Reference
|
| 8 |
SCHEDULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
|
| 9 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 10 |
BRANCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The local branch office identifier associated with a given bank/counterparty.
|
| 11 |
CHECK_DIGIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Check Digit
|
| 12 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 13 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 14 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 15 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 16 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
Default Value: VENDOR_ADDR.NAME1
|
| 17 |
NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2
|
| 18 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 19 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 20 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 21 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 22 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 23 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 24 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 25 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 26 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 27 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 28 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 29 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 30 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 31 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 32 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 33 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 34 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 35 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
Default Value: %date
|
| 36 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 37 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 38 |
PYMNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount
|
| 39 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
Prompt Table:
CURR_PYMNT_VW
|
| 40 |
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
|
| 41 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 42 |
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
|
| 43 |
PYMNT_RECONCILE_DT |
Date(10) |
DATE |
Date Reconciled
|
| 44 |
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
|
| 45 |
CANCEL_DT |
Date(10) |
DATE |
Date Cancelled
|
| 46 |
DFT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Payment Status
A=Approved
C=Created
D=Due
N=Non-Draft Payment
R=Reconciled
W=Write Off
X=Write Off Posted
|
| 47 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 48 |
POST_STATUS_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied
P=Posted
U=Unposted
Default Value: U
|
| 49 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 50 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 51 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 52 |
RECON_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
A=Automatically Reconciled
B=Balance System(s) to BankTran
F=Forced to Reconcile
M=Manually Reconciled
S=Semi Manual
U=Unreconciled
Default Value: U
|
| 53 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
| 54 |
RECONCILE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The user ID that performed the reconciliation for a given transaction.
|
| 55 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 56 |
RECON_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Reconciliation Status
ALG=Alignment Check
AMB=Ambiguous Match
AMT=Amounts Not Equal
CUR=Currency not Defined
DAT=Tran Date <> Value Date
DPI=Duplicate Input Transactions
DUP=Duplicate Transaction
MSC=Miscellaneous Transaction
NAM=Payee Names Not Equal
NTB=Not Found in Statement
NTF=Not Found In System
NTP=Not Found in POS Data
NUL=Null Transaction ID Ref
OVR=Overflow
PND=Pending Reconciliation
REC=Reconciled
RPR=Reprinted Check
RR=Requires Review - BSAC
STP=Stop Payment
TYP=Wrong Transaction Type
UNR=Unreconciled
VOI=Voided Check
|
| 57 |
DFI_ID_NUM |
Character(12) |
VARCHAR2(12) NOT NULL |
A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
|
| 58 |
DFI_ID_QUAL |
Character(2) |
VARCHAR2(2) NOT NULL |
A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined
|
| 59 |
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
Prompt Table:
PYMNT_FMT_TBL
|
| 60 |
STTLMNT_DT_EST |
Date(10) |
DATE |
Date in which a deal transaction is estimated to be settled with a counterparty.
|
| 61 |
STTLMNT_DT_ACTUAL |
Date(10) |
DATE |
Date in which a deal transaction is actually settled with a counterparty.
|
| 62 |
EFT_TRANS_HANDLING |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Handling
D=Payment Only
P=Prenotification
X=Payment and Advice
|
| 63 |
REMIT_BANK_ACCOUNT |
Character(35) |
VARCHAR2(35) NOT NULL |
Bank Account Number
|
| 64 |
REMIT_BRANCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Branch ID
|
| 65 |
REMIT_CHECK_DIGIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Check Digit
|
| 66 |
REP_RTNG_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Routing Code
|
| 67 |
FORM_NBR_CONFIRMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Number Confirmed
Y/N Table Edit
Default Value: Y
|
| 68 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
Y/N Table Edit
Default Value: N
|
| 69 |
POSITIVE_PAY_DT |
Date(10) |
DATE |
Positive Payment Date
|
| 70 |
POSITIVE_PAY_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Positive Payment Status
C=Sent to bank
N=Not Sent to bank
S=Selected for transmission
Z=Zero Payment
Default Value: N
|
| 71 |
MICR_LINE |
Character(50) |
VARCHAR2(50) NOT NULL |
MICR Line
|
| 72 |
CASH_CLEARED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash Cleared Flag
Y/N Table Edit
Default Value: N
|
| 73 |
CASH_CLEARED_DT |
Date(10) |
DATE |
Cash Cleared Date
|
| 74 |
REPLACED_DT |
Date(10) |
DATE |
Replacement Date
|
| 75 |
PYMNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Type
E=Express Payment
M=Manual Payment
R=Regular payment
W=Withholding Payment
Z=Zero Payment Check
|
| 76 |
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
|
| 77 |
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.
|
| 78 |
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.
|
| 79 |
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.
|
| 80 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 81 |
SOURCE_TXN |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Transaction
|
| 82 |
BRANCH_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Branch Name
|
| 83 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 84 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 85 |
DFT_MASTER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft Master ID
|
| 86 |
DFT_CONTROL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Draft Control ID
|
| 87 |
DFT_STMP_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Draft StampTax Amount
|
| 88 |
DFT_DRAWEE |
Character(40) |
VARCHAR2(40) NOT NULL |
Draft Drawee
|
| 89 |
DFT_APPROVAL_DT |
Date(10) |
DATE |
Draft Approval Date
|
| 90 |
DFT_MAT_DT |
Date(10) |
DATE |
Draft Maturity Date
|
| 91 |
DFT_WO_ACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Draft writeOff Account
|
| 92 |
DFT_WO_DT |
Date(10) |
DATE |
Draft Write-Off Date
|
| 93 |
DFT_OPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Optimization
D=Use Pay Cycle Default
N=Do Not Use
S=Specify
|
| 94 |
DFT_APPROVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Issue Approval Required
Y/N Table Edit
Default Value: N
|
| 95 |
ACHIEVE_DT |
Date(10) |
DATE |
Achieve Date
|
| 96 |
DFT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Type
A=Automatic
M=Manual
|
| 97 |
ESCHEATED_DT |
Date(10) |
DATE |
Stale Date
|
| 98 |
USER_PYMNT_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Character Field
|
| 99 |
USER_PYMNT_CHAR2 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Character Field
|
| 100 |
USER_PYMNT_DATE |
Date(10) |
DATE |
User Date
Default Value: %DATE
|
| 101 |
USER_PYMNT_DEC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amount Field
Default Value: 0
|
| 102 |
USER_PYMNT_NUM |
Number(3,0) |
SMALLINT NOT NULL |
User Number field
Default Value: 1
|
| 103 |
VALUE_DT |
Date(10) |
DATE |
Equivalent to a deal transaction's settlement date.
|
| 104 |
DFT_WO_ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Write-off Alt Acct
|
| 105 |
CANCEL_POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine the post status of cancelled payment. If posting has not been run it will be set to W Pending. If the payment action is not V Void, S Stopped, W Escheated Check then the value is N. If the payment has not be posted but has been cancel the value = W. After the cancellation has been posted it the value is P posted.
N=Not Applicable
P=Posted
W=Pending
|
| 106 |
TREASURY_PMT_NBR |
Number(11,0) |
DECIMAL(11) NOT NULL |
Payment Confirm Number
|
| 107 |
SINGLE_PYMNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Payment
Y/N Table Edit
Default Value: N
|
| 108 |
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
|
| 109 |
BANK_ACCT_RVL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field used to store the amount on a transaction revalued in the base currency of the transactions bank account.
|
| 110 |
RECON_RUN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Recon Run ID
|
| 111 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 112 |
PMT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment id
|
| 113 |
BANK_REF_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
A reference identifier associated with a given bank/counterparty transaction.
|
| 114 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
Default Value: 02
|
| 115 |
PMT_PYMNT_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Settlement Status
C=Canceled
CM=Cancelled with Message
E=Error
H=Hold
L=Loaded
N=None
P=Paid
PC=Pending Cancellation
R=Received by Bank
S=Send to Bank
SC=In Process
Default Value: N
|
| 116 |
BATCH_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Batch ID
|
| 117 |
RECORD_SEQ_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
An internal work field utilized to enumerate database records in bank statement processing.
|
| 118 |
PYMNT_HOLD_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Hold Reason
ACC=Accounting in Dispute
ACV=Federal Supplier Inactive
ALC=Agency Location Code Required
AMT=Amount in Dispute
CCR=CCR Expired
CRT=Contract Retention
EFT=EFT incomplete or not Prenoted
FNS=Financial Sanctions
GDS=Goods in Dispute
GNV=G-Invoicing Hold
IPC=Inbound IPAC Required
OTH=Other
QTY=Quantity in Dispute
SAM=SAM Expired
WTH=Withholding Hold
|
| 119 |
INTERUNIT_PYMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit Payment
|
| 120 |
AR_STG_LOADED |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Staging Table Populated
|
| 121 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 122 |
PYMNT_REASON_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Reason Code
Prompt Table:
REASON_CANC_VW
|
| 123 |
LAST_UPDATE_DTTM |
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.
Default Value: %datetime
|
| 124 |
SES_LAST_DTTM |
DateTime(26) |
TIMESTAMP |
PTSF Last Modified DateTimestamp
Default Value: %datetime
|
| 125 |
ACH_RRC |
Character(3) |
VARCHAR2(3) NOT NULL |
ACH Return Reason Code
|