| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 5 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Prompt Table:
BANK_CD_VW3
|
| 6 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
Prompt Table:
BANK_ACCT_VW2
|
| 7 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
Prompt Table:
BANK_STMT_VW
|
| 8 |
CYCLE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Cycle Status
C=Complete
E=Load Failed
F=Fatal Error
I=EDI Loaded
L=Loading
N=Ready
P=Selected
R=Ready
X=Reconciling
|
| 9 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 10 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
|
| 11 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
|
| 12 |
RECONCILE_DT |
Date(10) |
DATE |
The transaction reconciliation date.
|
| 13 |
RECON_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconciliation Level
A=All Business Units
B=Single Business Unit
|
| 14 |
BU_SECURITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Security
|
| 15 |
SECURITY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Security
C=Permission List Level Security
N=No Security
O=User ID Level Security
|
| 16 |
RECON_TRANS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
The PeopleSoft-specific bank transaction code
ACH=Automated Clearing House
B=Direct Debit
BA=Bank Adjustments
BOE=Bill of Exchange - Disburse
BOO=Bill of Order - Disburse
C=Trade Receipt
CHK=Check
D=Deposits
DD=Direct Debit - Disburse
EFT=Electronic Funds Transfer
F=Fee Expense
G=General Transaction
I=Interest Expense
M=Miscellaneous Transaction
MAN=Manual Check
P=Payment
R=Drafts
S=Stop Pay
TRW=Treasury Wire
U=Funding Receipt
V=Voided Payment
WIR=Wire - Disbursement
WRI=Wire - Incoming
|
| 17 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 18 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 19 |
BANK_CD_CPTY |
Character(5) |
VARCHAR2(5) NOT NULL |
An internal key field convention that facilitates the system distinction between banks and counterparties.
|
| 20 |
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
|
| 21 |
PRE_RECONCILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate whether the automated reconciliation process should apply a n
|
| 22 |
ENABLE_WF_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows a user to enable workflow worklist processing for automated reconciliation purposes. Th
F=Nofitication Framework
N=No Workflow
Y=Workflow
|
| 23 |
RECORD_SEQ_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
An internal work field utilized to enumerate database records in bank statement processing.
|
| 24 |
RECON_TYPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates which method has been utilized to reconcile a given source system transaction.
A=Automatic
M=Manual
N=None
S=Semi Manual
|
| 25 |
TRANSACTION_TBL |
Character(18) |
VARCHAR2(18) NOT NULL |
Represents the database table(s) that contain system source transaction data for reconciliation pu
|
| 26 |
TRANS_TBL |
Character(5) |
VARCHAR2(5) NOT NULL |
Transaction Table
|
| 27 |
PRE_DATE1 |
Date(10) |
DATE |
Pre Reconcile Date 1
|
| 28 |
PRE_DATE2 |
Date(10) |
DATE |
Pre Reconcile Date 2
|
| 29 |
RECON_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconciliation Flag
|
| 30 |
RECON_BANK_DT |
Date(10) |
DATE |
The bank statement date.
|
| 31 |
RECON_TRAN_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The bank statement transaction amount.
|
| 32 |
RECON_REF_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
The transaction reference identifier on the inbound bank statement.
|
| 33 |
OPRCLASS |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator Class
|
| 34 |
REC_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Record Name
|
| 35 |
RECON_RULE |
Character(8) |
VARCHAR2(8) NOT NULL |
Reconciliation Rule
|
| 36 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 37 |
BNK_ACTIVE_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field determines the type of tolerance on a transaction's amount
A=Amount
D=Date
N=None
P=Percent
|
| 38 |
BNK_ACTIVE_LIMIT_D |
Character(1) |
VARCHAR2(1) NOT NULL |
This field determines the type of tolerance on a transaction's amount
|
| 39 |
BNK_LIMIT_HIGH_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
This field contains the upper amount when added to a transaction amount that will still reconcile.
|
| 40 |
BNK_LIMIT_HIGH_DAY |
Number(3,0) |
SMALLINT NOT NULL |
Upper Day Limit
|
| 41 |
BNK_LIMIT_HIGH_PCT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
This field contains the high percent limit that when multiplied by the transaction amount and then added to the transaction amount will still allow the transaction to reconcile.
|
| 42 |
BNK_LIMIT_LOW_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
This field contains the lower amount when subtracted from a transaction amount that will still reconcile.
|
| 43 |
BNK_LIMIT_LOW_DAY |
Number(3,0) |
SMALLINT NOT NULL |
Lower Day Limit
|
| 44 |
BNK_LIMIT_LOW_PCT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
This field contains the low percent limit that when multiplied by the transaction amount and then subtracted to the transaction amount will still allow the transaction to reconcile.
|
| 45 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 46 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 47 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 48 |
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
|
| 49 |
STTLMNT_DT_ACTUAL |
Date(10) |
DATE |
Date in which a deal transaction is actually settled with a counterparty.
|
| 50 |
ABORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Abort Process Flag
|
| 51 |
RCN_SOURCE_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
This field contains the reconciliation source that reconcile with a bank statement line
|
| 52 |
RCN_EVENT_NAME |
Character(16) |
VARCHAR2(16) NOT NULL |
Reconciliation Event Name field
|
| 53 |
RCN_EVENT_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
Event Sequence Number
|
| 54 |
RCN_EVENT_TBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Event Record for Reconciliation
|
| 55 |
RCN_EVENT_ACT |
Character(3) |
VARCHAR2(3) NOT NULL |
Event Action for reconciliation
DEL=Delete
INS=Insert
TRC=Truncate
UPD=Update
|
| 56 |
RCN_LOOP |
Number(1,0) |
SMALLINT NOT NULL |
For reconciliation, this field indicates which loop that the event is executed in.
|
| 57 |
RCN_EVENT_ID |
Number(3,0) |
SMALLINT NOT NULL |
Reconciliation event id number
|
| 58 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 59 |
RCN_SOURCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Source Type
1=Pre-process (before Recon)
2=Recon Process
3=Post-process (after Recon)
|
| 60 |
RCN_ATTR_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow amount tolerances in performing reconciliation
|
| 61 |
RCN_ATTR_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Date tolerances in performing reconciliation
|
| 62 |
RCN_ATTR_COMPARE |
Character(1) |
VARCHAR2(1) NOT NULL |
Compare transactions and statement lines in reconciliation
0=One transaction/one line
1=Many transactions/one line
2=Many transactions/many lines
3=One transaction/many lines
|
| 63 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 64 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 65 |
RCN_CONDITION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Conditional or Unconditional
N=Unconditional
Y=Conditional
|
| 66 |
RCN_OPTION_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Option Code
|
| 67 |
ACCTG_TMPL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
|
| 68 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 69 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 70 |
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
|
| 71 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
N=No
Y=Yes
|
| 72 |
COUNTER3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 3
|
| 73 |
RECON_RUN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Recon Run ID
|
| 74 |
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.
|
| 75 |
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.
|
| 76 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 77 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 78 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 79 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 80 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 81 |
RECON_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Represents the source system table(s) for reconciling items.
00=Bank Statement
01=Receivables Deposits
02=Payables
03=Treasury
04=Receivables Drafts
05=External Transactions
06=Receivables Payments
07=Direct Debits
|
| 82 |
RULE_ID_RECON |
Character(20) |
VARCHAR2(20) NOT NULL |
Reconciliation Rules Id
|
| 83 |
RECON_RULE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconciliation Rule Type
1=One to One
2=One to Many
3=Many to One
4=Many to Many
|
| 84 |
SEQ_NUM2 |
Number(6,0) |
INTEGER NOT NULL |
Sequence Number
|
| 85 |
RECNAME_RECON1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Source 1 Record
|
| 86 |
FIELD_NAME1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Name
|
| 87 |
RECNAME_RECON2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Source 2 Record
|
| 88 |
FIELD_NAME2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Name
|
| 89 |
STRIP_LEAD_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Strip Lead Character
|
| 90 |
MSQL_STMT |
Long Character(8192) |
CLOB |
Matching SQL Text
|
| 91 |
FSQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 92 |
ASQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 93 |
DATE_TOLER |
Character(20) |
VARCHAR2(20) NOT NULL |
Date Tolerance
|
| 94 |
AMT_TOLER |
Character(20) |
VARCHAR2(20) NOT NULL |
Amount Tolerance
|
| 95 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 96 |
TO_DATE |
Date(10) |
DATE |
To Date
|
| 97 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
|
| 98 |
RATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Rate Table
N=No
Y=Yes
|
| 99 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 100 |
REF_REF_ID_OTHER |
Character(100) |
VARCHAR2(100) NOT NULL |
EDI 820 Trace Reference ID
|
| 101 |
ISQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 102 |
ISQL_TRAN |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 103 |
SSQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 104 |
SSQL_TRAN |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 105 |
MSQL_TRAN |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 106 |
ASQL_TRAN |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 107 |
FSQL_TRAN |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 108 |
PYMNT_RECONCILE_DT |
Date(10) |
DATE |
Date Reconciled
|
| 109 |
RECONCILE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The user ID that performed the reconciliation for a given transaction.
|