CASH_FLW_WK_TBL

(SQL Table)
 Index Back

Cash Flow Work Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_TRD_NONVW

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 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
11 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

13 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

Prompt Table: BANK_SETID_VW

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 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
17 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
18 CPTY_REFERENCE Character(15) VARCHAR2(15) NOT NULL A reference identifier associated with a dealing counterparty transaction.
19 TRANSACTION_DTTM DateTime(26) TIMESTAMP Transaction Date-Time
20 PAY_ACTION_TR Character(8) VARCHAR2(8) NOT NULL "An internal work field in the settlements module that contains a summary of detail settlement transac
21 SETTLEMENT_ID Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc
22 BANK_CD_CUST Character(5) VARCHAR2(5) NOT NULL Represents the customer bank or counterparty in a relationship that pairs differing sets of b