FCST_NONCASH_VW(SQL View) |
Index Back |
|---|
| SELECT SETID , WORKSHEET_ID , SOURCE_SET ,WRKSHEET_LINE_ITEM ,LINE_NBR ,GROUP_BY_FIELD ,VALUE_DT ,POSITION_CURRENCY ,CURRENCY_CD ,DISPLAY_VALUES , BUSINESS_UNIT_BANK ,'' ,BANK_SETID ,BANK_CD ,BANK_ACCT_KEY ,BNK_ACCT_DFLT_CURR , GRP_BY_FIELD_1 , GRP_BY_FIELD_2 , GRP_BY_FIELD_3 , GRP_BY_FIELD_4 , GRP_BY_FIELD_5 , GRP_BY_FIELD_6 , GRP_BY_FIELD_7 , MAX(CALC_DT) ,LOCK_VALUE_FLAG , POS_IMPCT_ORIG , POS_IMPCT_WEIGHT FROM PS_CSH_FCST_SUM WHERE LINE_ITEM_TYPE='2' AND POS_HIST_FLAG='N' GROUP BY SETID , WORKSHEET_ID , SOURCE_SET ,WRKSHEET_LINE_ITEM ,LINE_NBR, GROUP_BY_FIELD ,VALUE_DT ,POSITION_CURRENCY ,CURRENCY_CD,DISPLAY_VALUES ,BUSINESS_UNIT_BANK , BANK_SETID ,BANK_CD ,BANK_ACCT_KEY ,BNK_ACCT_DFLT_CURR, GRP_BY_FIELD_1 , GRP_BY_FIELD_2 , GRP_BY_FIELD_3 , GRP_BY_FIELD_4 , GRP_BY_FIELD_5 , GRP_BY_FIELD_6 , GRP_BY_FIELD_7, LOCK_VALUE_FLAG , POS_IMPCT_ORIG , POS_IMPCT_WEIGHT |
| # | 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 | WRKSHEET_LINE_ITEM |
Character(30) | VARCHAR2(30) NOT NULL | Cash Forecast Worksheet Line item |
| 5 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 6 | 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 |
| 7 | VALUE_DT |
Date(10) | DATE NOT NULL | Equivalent to a deal transaction's settlement date. |
| 8 | POSITION_CURRENCY |
Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
| 9 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | DISPLAY_VALUES | Character(30) | VARCHAR2(30) NOT NULL | The concatenated values for the Cash Forecast Summary group by field records 'BAC' and 'BNK'. BANK_SETID, BANK_CD and BANK_ACCT_KEY when the translate value for group by field is �BAC� . BANK_SETID and BANK_CD when the translate value for group by field is �BNK�. |
| 11 | BUSINESS_UNIT_BANK | Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty. |
| 12 | GRP_ID | Character(30) | VARCHAR2(30) NOT NULL | Group id |
| 13 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 14 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 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 |
| 16 | BNK_ACCT_DFLT_CURR | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) the position currency specified on the Cash Forecast summary data is the bank account default currency. This only applies to bank account summary rows - GROUP_BY_FIELD of 'BAC'. |
| 17 | GRP_BY_FIELD_1 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 18 | GRP_BY_FIELD_2 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 19 | GRP_BY_FIELD_3 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 20 | GRP_BY_FIELD_4 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 21 | GRP_BY_FIELD_5 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 22 | GRP_BY_FIELD_6 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 23 | GRP_BY_FIELD_7 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 24 | CALC_DT | Date(10) | DATE | The calculation date for a given data set within the Position tools. |
| 25 | LOCK_VALUE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | A field which will Lock/Unlock a value on the CPW. |
| 26 | 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 |
| 27 | POS_IMPCT_WEIGHT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pos Impact Weight Amt Value |