| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_TRD_NONVW
|
| 2 |
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
|
| 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 |
FEE_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Represents the sequential numbering of detail fee transactions within a given facility.
|
| 5 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_EX_ACTIVE
|
| 6 |
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_ACTVE
|
| 7 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
BANK_ACCTCUR_VW
|
| 8 |
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_INSTR_VW
|
| 9 |
FA_FEE_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Fee code mapped to Bank Fee code used for Fee Analysis.
Prompt Table:
%EDITTABLE
Set Control Field: BUSINESS_UNIT
|
| 10 |
FEE_STRUCTURE |
Character(5) |
VARCHAR2(5) NOT NULL |
Structure Code for Fee Analysis
Prompt Table:
FA_FEE_STR_HDR
|
| 11 |
FEE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The transaction fee amount.
|
| 12 |
TRANSACTION_DT |
Date(10) |
DATE NOT NULL |
Transaction date (often used as trade date)
Default Value: %date
|
| 13 |
VALUE_DT |
Date(10) |
DATE NOT NULL |
Equivalent to a deal transaction's settlement date.
|
| 14 |
FEE_START |
Date(10) |
DATE |
The beginning accrual date for fee transactions.
|
| 15 |
FEE_END |
Date(10) |
DATE |
End of the fees accrual period
|
| 16 |
FEE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
The fee transaction status.
D=Denied
N=Not Selected
P=Processed
S=Selected
Default Value: N
|
| 17 |
INT_BASIS |
Character(2) |
VARCHAR2(2) NOT NULL |
Day Count Basis
30=30/360
3E=30E/360
A0=Actual/360
A5=Actual/365
AA=Actual/Actual
|
| 18 |
ACCTG_TMPL_ID_CF |
Character(15) |
VARCHAR2(15) NOT NULL |
The treasury accounting template associated with a treasury facility fee that is to be expensed.
Prompt Table:
%EDITTABLE2
|
| 19 |
ACCTG_TMPL_ID_POS |
Character(15) |
VARCHAR2(15) NOT NULL |
The treasury accounting template associated with a treasury facility fee that is to be amortized
Prompt Table:
%EDITTABLE2
|
| 20 |
SELLBUY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Represents Sell/Buyback Flag on the Fee Seq Row
Y/N Table Edit
Default Value: N
|
| 21 |
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:
FEE_PYMT_MTHD_V
|
| 22 |
FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
Prompt Table:
TR_FORMAT_VW
|
| 23 |
OPRID_ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered By
07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase.
03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!!
FYI - The alternatives to use a User ID as uppercase:
1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID
2) Use %Upper meta-SQL in SQL statements
3) Use Upper function in peoplecodes
|
| 24 |
DTTM_ENTERED |
DateTime(26) |
TIMESTAMP |
Date Time Stamp for Entry
|
| 25 |
CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Code
Prompt Table:
EXT_CODE_VW
|
| 26 |
PRTRY |
Character(30) |
VARCHAR2(30) NOT NULL |
Proprietary
|