| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 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
|
| 2 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 3 |
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
|
| 4 |
BUSINESS_DATE |
Date(10) |
DATE |
Represents a date upon which business is conducted within a given company in a given country.
|
| 5 |
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.
|
| 6 |
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
|
| 7 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 8 |
PAY_DOC_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Advice Sequence
|
| 9 |
CASH_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Represents the type of cash flow stored in the Treasury database.
01=Actual
02=Provisional
03=Sample
04=Deactivated
|
| 10 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 11 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 12 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table:
SP_SIACT_NONVW
|
| 13 |
BANK_CD_CUST |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the customer bank or counterparty in a relationship that pairs differing sets of b
|
| 14 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_TBL
|
| 15 |
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_DEFN
|
| 16 |
ACCT_BUS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit associated with a given bank/counterparty account.
Prompt Table:
SP_BU_GL_NONVW
|
| 17 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Prompt Table:
BANK_ID_VW
|
| 18 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
Prompt Table:
BANK_ACCTKEY_VW
|
| 19 |
TRANSACTION_LINE |
Number(3,0) |
SMALLINT NOT NULL |
The separate and distinct base instrument type components of a given deal transaction.
|
| 20 |
RECONCILE_DT |
Date(10) |
DATE |
The transaction reconciliation date.
|
| 21 |
RECONCILE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The user ID that performed the reconciliation for a given transaction.
|
| 22 |
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
|
| 23 |
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
Default Value: UNR
|
| 24 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
| 25 |
RECORD_SEQ_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
An internal work field utilized to enumerate database records in bank statement processing.
|
| 26 |
STTLMNT_DT_ACTUAL |
Date(10) |
DATE |
Date in which a deal transaction is actually settled with a counterparty.
|
| 27 |
NET_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates the counterparty netting status of a given settlement transaction.
D=Netted
N=Net
O=Not Netted
Default Value: O
|
| 28 |
SELECTED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Selected Operator
|
| 29 |
SELECTED_DTTM |
DateTime(26) |
TIMESTAMP |
Selected Date
|
| 30 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
|
| 31 |
APPROVAL_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a given transaction is approved by an oper
|
| 32 |
CPTY_REFERENCE |
Character(15) |
VARCHAR2(15) NOT NULL |
A reference identifier associated with a dealing counterparty transaction.
|
| 33 |
NET_REF_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
A reference identifier associated with a cash transaction subject to netting with a given bank/count
|
| 34 |
CF_SOURCE_REF_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Reference identifier for a treasury system cash flow.
|
| 35 |
CP_NETTOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Allows the user to indicate whether a given dealing counterparty permits netting of inbound and outbou
|
| 36 |
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
Prompt Table:
STL_PYMT_MTHD_V
|
| 37 |
SETTLEMENT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc
Prompt Table:
STL_INSTRUC_VW3
|
| 38 |
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: X
|
| 39 |
APPROVAL_FLG_TR |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that indicates that a given treasury transaction has been approved by
A=Approved
D=Denied
N=None Required
P=Pending Approval
Default Value: N
|
| 40 |
APPROV_SUBMITTED |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a treasury deal review and/or confirmation transac
Y/N Table Edit
Default Value: N
|
| 41 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 42 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 43 |
BASE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents a transaction amount calculated and stored in the base currency of its associated General Ledger bus
|
| 44 |
BASE_CURRENCY_BNK |
Character(3) |
VARCHAR2(3) NOT NULL |
The base currency of the subject bank general ledger business unit.
|
| 45 |
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
|
| 46 |
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
|
| 47 |
CUR_RT_TYPE_BNK |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 48 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 49 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 50 |
PAID_AMT_BNK_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount - Base Bank Unit
|
| 51 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 52 |
PYMNT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is store
|
| 53 |
PYMNT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is stored
|
| 54 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 55 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 56 |
BANK_STMT_DT |
Date(10) |
DATE |
"The bank statement date
|
| 57 |
RECON_RUN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Recon Run ID
|
| 58 |
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.
|
| 59 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|
| 60 |
EVENT_TRACKING_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
|
| 61 |
REPETITVE_TRNFR_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Repetitive Transfer Code assigned by customers Bank
|
| 62 |
DRAWDOWN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Drawdown Transfer Flag, either yes or no.
N=No
Y=Yes
|
| 63 |
PMT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment id
|
| 64 |
PMT_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment status
C=Canceled
CM=Cancelled with Message
E=Error
H=Flagged for Hold
L=Awaiting Dispatch
N=Not Processed
P=Paid
PC=Pending Cancellation
PR=Pending Reversal
R=Received by Bank
RM=Reversed with Message
S=Dispatched to Bank
SC=In Process
|
| 65 |
FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
|
| 66 |
TRP_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Pool Business Unit
|
| 67 |
POOL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pool ID field.
|
| 68 |
CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Code
|
| 69 |
PRTRY |
Character(30) |
VARCHAR2(30) NOT NULL |
Proprietary
|
| 70 |
BSE_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Base Rate Divisor for Exchange Rates
|
| 71 |
BSE_RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Base Rate Multiplier for Exchange Rates
|
| 72 |
COUNTERPARTY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given dealing counterparty.
|
| 73 |
COUNTERPARTY |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents a treasury dealing counterpart.
|
| 74 |
INSTRUMENT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Instrument type
|
| 75 |
TRANSACTION_DTTM |
DateTime(26) |
TIMESTAMP |
Transaction Date-Time
|