| # |
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.
|
| 6 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 7 |
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
|
| 8 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 9 |
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
|
| 10 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
|
| 11 |
RECON_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconciliation Level
A=All Business Units
B=Single Business Unit
|
| 12 |
BU_SECURITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Security
|
| 13 |
SECURITY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Security
C=Permission List Level Security
N=No Security
O=User ID Level Security
|
| 14 |
PRE_RECONCILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate whether the automated reconciliation process should apply a n
|
| 15 |
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
|
| 16 |
TR_SOURCE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync.
Values that are inactive are for use in TR Accounting only
B=BSP
D=Deals
E=Deal Fees
F=Facility Fees
H=Hedges
I=Interest
M=Deal: Estimated Maturity Accr
N=Netted Deal
O=Other
P=Investment Pools
R=EFT Fees
S=Securities
T=LC Fees
W=EFT Requests
X=Bank Transfers
|
| 17 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 18 |
TR_SOURCE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
An internal work field that represents a unique identifier for records depicting a given treasury po
|
| 19 |
BUSINESS_DATE |
Date(10) |
DATE |
Represents a date upon which business is conducted within a given company in a given country.
|
| 20 |
CASH_FLOW_LINE |
Number(15,0) |
DECIMAL(15) NOT NULL |
A sequential number that indicates the time order sequence of a given deal transaction's cash flows.
|
| 21 |
CASH_FLOW_LEG |
Number(1,0) |
SMALLINT NOT NULL |
A sequential number that indicates the relationship between a cash flow and its corresponding deal transaction leg
|
| 22 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 23 |
RECON_REF_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
The transaction reference identifier on the inbound bank statement.
|
| 24 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 25 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 26 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 27 |
BANK_CD_CUST |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the customer bank or counterparty in a relationship that pairs differing sets of b
|
| 28 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 29 |
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
|
| 30 |
ACCT_BUS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit associated with a given bank/counterparty account.
|
| 31 |
RECONCILE_DT |
Date(10) |
DATE |
The transaction reconciliation date.
|
| 32 |
RECONCILE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The user ID that performed the reconciliation for a given transaction.
|
| 33 |
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
|
| 34 |
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
|
| 35 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
| 36 |
RECORD_SEQ_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
An internal work field utilized to enumerate database records in bank statement processing.
|
| 37 |
STTLMNT_DT_ACTUAL |
Date(10) |
DATE |
Date in which a deal transaction is actually settled with a counterparty.
|
| 38 |
CPTY_REFERENCE |
Character(15) |
VARCHAR2(15) NOT NULL |
A reference identifier associated with a dealing counterparty transaction.
|
| 39 |
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
|
| 40 |
SETTLEMENT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc
|
| 41 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 42 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 43 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 44 |
BANK_STMT_DT |
Date(10) |
DATE |
"The bank statement date
|
| 45 |
RECON_RUN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Recon Run ID
|
| 46 |
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.
|
| 47 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|
| 48 |
PMT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment id
|
| 49 |
FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
|
| 50 |
PARTY_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Payee ID
|
| 51 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 52 |
ADDENDA_VALUE |
Character(254) |
VARCHAR2(254) NOT NULL |
Addend Value use for Bank Statement Accounting
|
| 53 |
PMT_FIELD1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Payment field
|
| 54 |
PMT_FIELD2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Payment field
|
| 55 |
PMT_FIELD3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Payment field
|
| 56 |
BANK_REF_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
A reference identifier associated with a given bank/counterparty transaction.
|
| 57 |
PMT_FILE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Payment File ID
|
| 58 |
SUM_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 59 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 60 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 61 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 62 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 63 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 64 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 65 |
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
|
| 66 |
RULE_ID_RECON |
Character(20) |
VARCHAR2(20) NOT NULL |
Reconciliation Rules Id
|
| 67 |
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
|
| 68 |
SEQ_NUM2 |
Number(6,0) |
INTEGER NOT NULL |
Sequence Number
|
| 69 |
RECNAME_RECON1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Source 1 Record
|
| 70 |
FIELD_NAME1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Name
|
| 71 |
RECNAME_RECON2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Source 2 Record
|
| 72 |
FIELD_NAME2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Name
|
| 73 |
STRIP_LEAD_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Strip Lead Character
|
| 74 |
MSQL_STMT |
Long Character(8192) |
CLOB |
Matching SQL Text
|
| 75 |
FSQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 76 |
ASQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 77 |
DATE_TOLER |
Character(20) |
VARCHAR2(20) NOT NULL |
Date Tolerance
|
| 78 |
AMT_TOLER |
Character(20) |
VARCHAR2(20) NOT NULL |
Amount Tolerance
|
| 79 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 80 |
TO_DATE |
Date(10) |
DATE |
To Date
|
| 81 |
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.
|
| 82 |
RATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Rate Table
N=No
Y=Yes
|
| 83 |
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.
|
| 84 |
RCN_SOURCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Source Type
1=Pre-process (before Recon)
2=Recon Process
3=Post-process (after Recon)
|
| 85 |
ISQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 86 |
SSQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 87 |
REF_REF_ID_OTHER |
Character(100) |
VARCHAR2(100) NOT NULL |
EDI 820 Trace Reference ID
|
| 88 |
ISQL_TRAN |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 89 |
SSQL_TRAN |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 90 |
MSQL_TRAN |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 91 |
FED_WIRE_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
This field will hold the Federal Wire ID # that is given upon confirmation of a successful wire transfer.
|