TRDASH_BU_VW(SQL View) |
Index Back |
|---|---|
TR Dash BU ViewTR Dash BU View |
| SELECT SETID , WORKSHEET_ID , SOURCE_SET ,GROUP_BY_FIELD , POSITION_CURRENCY , VALUE_DT , SUM(POS_IMPCT_ORIG) , MAX(CALC_DT) , LINE_ITEM_TYPE , POS_HIST_FLAG , POS_DEF_SRC_SET , BUSINESS_UNIT_BANK FROM PS_CSH_FCST_SUM GROUP BY SETID , WORKSHEET_ID , SOURCE_SET ,GROUP_BY_FIELD , POSITION_CURRENCY , VALUE_DT , LINE_ITEM_TYPE , POS_HIST_FLAG , POS_DEF_SRC_SET , BUSINESS_UNIT_BANK |
| # | 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 | 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 |
| 8 | CALC_DT | Date(10) | DATE | The calculation date for a given data set within the Position tools. |
| 9 | 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 |
| 10 | 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 |
| 11 | POS_DEF_SRC_SET | Character(1) | VARCHAR2(1) NOT NULL | a checkbox that identifies the default position source set. |
| 12 | BUSINESS_UNIT_BANK | Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty. |