TRDASH_CPCUR_VW (SQL View)	Index Back
Cash Position Currency View Cash Position Currency View

TRDASH_CPCUR_VW

(SQL View)

Cash Position Currency View

SELECT SETID , WORKSHEET_ID , SOURCE_SET ,GROUP_BY_FIELD , VALUE_DT , SUM(POS_IMPCT_ORIG) , MAX(CALC_DT) , LINE_ITEM_TYPE , POS_HIST_FLAG , POS_DEF_SRC_SET , CURRENCY_CD FROM PS_CSH_FCST_SUM GROUP BY SETID , WORKSHEET_ID , SOURCE_SET ,GROUP_BY_FIELD , VALUE_DT , LINE_ITEM_TYPE , POS_HIST_FLAG , POS_DEF_SRC_SET , CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 WORKSHEET_ID Character(20) VARCHAR2(20) NOT NULL Cash Flows Worksheet ID

3 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.

4 GROUP_BY_FIELD_SRC Character(3) VARCHAR2(3) NOT NULL Group By Field categorizes worksheet summary lines into various views. Example you can view the results by Business Unit, Bank Account and Currency (as delivered). We also provide generic fields for user defined values.
BAC=Bank Account
BNK=Bank
BU=Business Unit
GP1=Group By Field 1
GP2=Group By Field 2
GP3=Group By Field 3
GP4=Group By Field 4
GP5=Group By Field 5
GP6=Group By Field 6
GP7=Group By Field 7
POS=Position Currency
SRC=Source Set
TIM=Time set
TRC=Transaction Currency

5 VALUE_DATE Date(10) DATE VALUE DATE

6 POS_IMPCT_ORIG Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the calculated monetary value for a specific position tree node; the result

7 CALC_DT Date(10) DATE The calculation date for a given data set within the Position tools.

8 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

9 POS_HIST_FLAG Character(1) VARCHAR2(1) NOT NULL An internal field utilized in order to determine whether the subject cash position worksheet is based up
Y=History-based

10 POS_DEF_SRC_SET Character(1) VARCHAR2(1) NOT NULL a checkbox that identifies the default position source set.

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	WORKSHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flows Worksheet ID
3	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources.
4	GROUP_BY_FIELD_SRC	Character(3)	VARCHAR2(3) NOT NULL	Group By Field categorizes worksheet summary lines into various views. Example you can view the results by Business Unit, Bank Account and Currency (as delivered). We also provide generic fields for user defined values. BAC=Bank Account BNK=Bank BU=Business Unit GP1=Group By Field 1 GP2=Group By Field 2 GP3=Group By Field 3 GP4=Group By Field 4 GP5=Group By Field 5 GP6=Group By Field 6 GP7=Group By Field 7 POS=Position Currency SRC=Source Set TIM=Time set TRC=Transaction Currency
5	VALUE_DATE	Date(10)	DATE	VALUE DATE
6	POS_IMPCT_ORIG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the calculated monetary value for a specific position tree node; the result
7	CALC_DT	Date(10)	DATE	The calculation date for a given data set within the Position tools.
8	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
9	POS_HIST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	An internal field utilized in order to determine whether the subject cash position worksheet is based up Y=History-based
10	POS_DEF_SRC_SET	Character(1)	VARCHAR2(1) NOT NULL	a checkbox that identifies the default position source set.
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code