SETIDPrompt Table: CSH_FCST_VW_SID
WORKSHEET_IDPrompt Table: CSH_FCST_VW_WID
SOURCE_SETPrompt Table: CSH_FCST_VW_SS
POSITION_CURRENCYCSH_FCST_VW_PC(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.SETID ,A.WORKSHEET_ID ,A.SOURCE_SET ,A.POSITION_CURRENCY FROM PS_CSH_FCST_SUM A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: CSH_FCST_VW_SID |
| 2 | WORKSHEET_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Cash Flows Worksheet ID
Prompt Table: CSH_FCST_VW_WID |
| 3 | SOURCE_SET |
Character(20) | VARCHAR2(20) NOT NULL |
A field name describing a group od position sources.
Prompt Table: CSH_FCST_VW_SS |
| 4 | POSITION_CURRENCY |
Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |