TR_DASH_BNK_SUM(SQL View) |
Index Back |
|---|---|
Treasury Dashboard Bank Sum |
| SELECT SETID , WORKSHEET_ID , SOURCE_SET ,GROUP_BY_FIELD ,POSITION_CURRENCY , VALUE_DT , DISPLAY_VALUES , SUM(POS_IMPCT_ORIG) , MAX(CALC_DT) , LINE_ITEM_TYPE , POS_HIST_FLAG , POS_DEF_SRC_SET ,BANK_CD ,BUSINESS_UNIT_BANK , CURRENCY_CD FROM PS_CSH_FCST_SUM GROUP BY SETID , WORKSHEET_ID , SOURCE_SET ,GROUP_BY_FIELD ,POSITION_CURRENCY , VALUE_DT , DISPLAY_VALUES , LINE_ITEM_TYPE , POS_HIST_FLAG , POS_DEF_SRC_SET , BANK_CD , BUSINESS_UNIT_BANK , 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 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
| 6 | VALUE_DATE | Date(10) | DATE | VALUE DATE |
| 7 | 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�. |
| 8 | 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 |
| 9 | CALC_DT | Date(10) | DATE | The calculation date for a given data set within the Position tools. |
| 10 | 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 |
| 11 | 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 |
| 12 | POS_DEF_SRC_SET | Character(1) | VARCHAR2(1) NOT NULL | a checkbox that identifies the default position source set. |
| 13 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 14 | BUSINESS_UNIT_BANK | Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty. |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |