CSH_FCST_T_VW(SQL View) |
Index Back |
|---|
| SELECT SETID , WORKSHEET_ID ,LINE_ITEM_TYPE ,LINE_NBR ,WRKSHEET_LINE_ITEM ,SOURCE_SET ,VALUE_DT ,POSITION_CURRENCY ,GROUP_BY_FIELD FROM PS_CSH_FCST_SUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: CSH_FCST_VW_SID |
| 2 | WORKSHEET_ID | Character(20) | VARCHAR2(20) NOT NULL |
Cash Flows Worksheet ID
Prompt Table: WRKSHT_DEFN_VW |
| 3 | 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 |
| 4 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | WRKSHEET_LINE_ITEM | Character(30) | VARCHAR2(30) NOT NULL | Cash Forecast Worksheet Line item |
| 6 | SOURCE_SET | Character(20) | VARCHAR2(20) NOT NULL |
A field name describing a group od position sources.
Prompt Table: CSH_FCST_VW_SS |
| 7 | VALUE_DT | Date(10) | DATE |
Equivalent to a deal transaction's settlement date.
Prompt Table: FCST_VAL_VW |
| 8 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
The transaction currency of a given position or exposure.
Prompt Table: CSH_FCST_VW_PC |
| 9 | GROUP_BY_FIELD | 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 CUR=Currency 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 WKS=Worksheet |