| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ACCT_BUS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit associated with a given bank/counterparty account.
|
| 2 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 3 |
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
|
| 4 |
BUSINESS_DATE |
Date(10) |
DATE |
Represents a date upon which business is conducted within a given company in a given country.
|
| 5 |
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
|
| 6 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 7 |
CF_SOURCE_REF_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Reference identifier for a treasury system cash flow.
|
| 8 |
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.
|
| 9 |
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
|
| 10 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 11 |
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
|
| 12 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 13 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 14 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table:
BANK_SETID_VW
|
| 15 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_TBL
|
| 16 |
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
|
| 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 |
TOTAL_RCV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
An internal work field in the settlements module that contains a summary of all inbound transacti
|
| 20 |
TOTAL_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
An internal work field in the settlements module that contains a summary of all outbound transact
|
| 21 |
TOTAL_FLOWS |
Number(5,0) |
INTEGER NOT NULL |
Number of associated cash flows for a deal transaction.
|
| 22 |
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:
%EDITTABLE
|
| 23 |
BANK_CD_CUST |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the customer bank or counterparty in a relationship that pairs differing sets of b
|