TR_CASH_POS_FL (SQL Table)	Index Back
Fluid saved searches This record will hold the fluid saved searches

TR_CASH_POS_FL

(SQL Table)

Fluid saved searches

This record will hold the fluid saved searches

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PMT_SRCH_NAME Character(30) VARCHAR2(30) NOT NULL Use Saved Searches
Prompt Table: CSH_FCST_SR_DTL

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

3 WORKSHEET_ID Character(20) VARCHAR2(20) NOT NULL Cash Flows Worksheet ID
Prompt Table: WORKSHEET_DEFN

4 LINE_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Line Item Type categorizes worksheet line items into cash flow items, non-cash flow items and totals.
1=Cash
2=Non-Cash

5 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.
Prompt Table: SOURCE_SET_DEFN

6 POSITION_CURRENCY Character(3) VARCHAR2(3) NOT NULL The transaction currency of a given position or exposure.
Prompt Table: POS_CURR_VW

7 TR_AMOUNT_TYPE Character(3) VARCHAR2(3) NOT NULL Amount Type
O=Original Amount
W=Weighted Amount
Default Value: O

8 TIME_SET Character(10) VARCHAR2(10) NOT NULL A unique key identifier that represents a time horizon definition dataset.
Prompt Table: POS_T_SPAN_TBL

9 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

10 SELECT_DT_OPTN Character(1) VARCHAR2(1) NOT NULL Date Type
1=Specific Dates
2=Relative Dates

11 FROMDATE Date(10) DATE From Date

12 TO_DATE Date(10) DATE To Date

13 TR_TERM Signed Number(6,0) DECIMAL(5) NOT NULL "Negotiated length of a deal transaction; also

14 TR_ROUND_TYPE Character(2) VARCHAR2(2) NOT NULL Rounding Type
BN=Billions
K=Thousands
MN=Millions

15 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL

16 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index
Prompt Table: RT_INDEX_FX_VW

17 CREATED_BY Character(30) VARCHAR2(30) NOT NULL Created By

18 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PMT_SRCH_NAME	Character(30)	VARCHAR2(30) NOT NULL	Use Saved Searches Prompt Table: CSH_FCST_SR_DTL
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
3	WORKSHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flows Worksheet ID Prompt Table: WORKSHEET_DEFN
4	LINE_ITEM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Line Item Type categorizes worksheet line items into cash flow items, non-cash flow items and totals. 1=Cash 2=Non-Cash
5	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources. Prompt Table: SOURCE_SET_DEFN
6	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure. Prompt Table: POS_CURR_VW
7	TR_AMOUNT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Amount Type O=Original Amount W=Weighted Amount Default Value: O
8	TIME_SET	Character(10)	VARCHAR2(10) NOT NULL	A unique key identifier that represents a time horizon definition dataset. Prompt Table: POS_T_SPAN_TBL
9	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
10	SELECT_DT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Date Type 1=Specific Dates 2=Relative Dates
11	FROMDATE	Date(10)	DATE	From Date
12	TO_DATE	Date(10)	DATE	To Date
13	TR_TERM	Signed Number(6,0)	DECIMAL(5) NOT NULL	"Negotiated length of a deal transaction; also
14	TR_ROUND_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Rounding Type BN=Billions K=Thousands MN=Millions
15	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL
16	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index Prompt Table: RT_INDEX_FX_VW
17	CREATED_BY	Character(30)	VARCHAR2(30) NOT NULL	Created By
18	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.