CSH_FCST_SUM_VW(SQL View) |
Index Back |
|---|---|
cash forecast sum tbl viewview on CSH_FCST_Sum on cash flow lines |
| SELECT S1.SETID , S1.WORKSHEET_ID , S1.SOURCE_SET , S1.WRKSHEET_LINE_ITEM , S1.LINE_NBR , S1.GROUP_BY_FIELD , S1.VALUE_DT , S1.POSITION_CURRENCY , S1.CURRENCY_CD , S1.DISPLAY_VALUES , S1.BUSINESS_UNIT_BANK , '' , S1.BANK_SETID , S1.BANK_CD , S1.BANK_ACCT_KEY , S1.BNK_ACCT_DFLT_CURR , S1.GRP_BY_FIELD_1 , S1.GRP_BY_FIELD_2 , S1.GRP_BY_FIELD_3 , S1.GRP_BY_FIELD_4 , S1.GRP_BY_FIELD_5 , S1.GRP_BY_FIELD_6 , S1.GRP_BY_FIELD_7 , MAX(S1.CALC_DT) , S1.LOCK_VALUE_FLAG , S1.POS_IMPCT_ORIG , S1.POS_IMPCT_WEIGHT FROM PS_CSH_FCST_SUM S1 WHERE S1.LINE_ITEM_TYPE='1' AND S1.POS_HIST_FLAG='N' AND S1.CALC_DT IN ( SELECT MAX(S2.CALC_DT) FROM PS_CSH_FCST_SUM S2 WHERE S1.SETID = S2.SETID AND S1.WORKSHEET_ID = S2.WORKSHEET_ID AND S1.SOURCE_SET = S2.SOURCE_SET AND S1.WRKSHEET_LINE_ITEM = S2.WRKSHEET_LINE_ITEM AND S1.LINE_NBR = S2.LINE_NBR AND S1.GROUP_BY_FIELD = S2.GROUP_BY_FIELD AND S1.VALUE_DT = S2.VALUE_DT AND S1.POSITION_CURRENCY = S2.POSITION_CURRENCY AND S1.CURRENCY_CD = S2.CURRENCY_CD AND S2.LINE_ITEM_TYPE='1' AND S2.POS_HIST_FLAG='N' ) GROUP BY S1.SETID , S1.WORKSHEET_ID, S1.SOURCE_SET, S1.WRKSHEET_LINE_ITEM, S1.LINE_NBR, S1.GROUP_BY_FIELD , S1.VALUE_DT ,S1.POSITION_CURRENCY ,S1.CURRENCY_CD ,S1.DISPLAY_VALUES ,S1.BUSINESS_UNIT_BANK , S1.BANK_SETID ,S1.BANK_CD ,S1.BANK_ACCT_KEY ,S1.BNK_ACCT_DFLT_CURR, S1.GRP_BY_FIELD_1 , S1.GRP_BY_FIELD_2 , S1.GRP_BY_FIELD_3 , S1.GRP_BY_FIELD_4 , S1.GRP_BY_FIELD_5 , S1.GRP_BY_FIELD_6 , S1.GRP_BY_FIELD_7, S1.LOCK_VALUE_FLAG , S1.POS_IMPCT_ORIG , S1.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 | 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.
Default Value: N |
| 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 |