CSH_FCST_DTL_VW(SQL View) |
Index Back |
|---|---|
Cash Forecast Detail ViewCash Forecast Detail View |
| SELECT S1.SETID , S1.WORKSHEET_ID , S1.LINE_ITEM_TYPE , S1.WRKSHEET_LINE_ITEM , S1.SOURCE_SET , S1.POS_SOURCE_ID , P.DESCR , S1.VALUE_DT , S1.CALC_DT , S1.REFERENCE , S1.SEQ_NBR , S1.POS_HIST_FLAG , S1.CALC_TM , S1.AMOUNT , S1.OVERRIDE_AMOUNT , S1.CURRENCY_CD , S1.RATE_MULT , S1.RATE_DIV , S1.DECIMAL_POSITIONS , S1.POS_IMPCT_ORIG , S1.POS_IMPCT_WEIGHT , S1.POS_IMPCT_WEIGHT2 , S1.POSITION_CURRENCY , S1.WEIGHTING , S1.DTL_LINE_SOURCE , S1.BUSINESS_UNIT_BANK , S1.BANK_SETID , S1.BANK_CD , S1.BANK_ACCT_KEY , ( SELECT A1.BANK_ACCOUNT_NUM FROM PS_BANK_ACCT_DEFN A1 WHERE S1.BANK_SETID=A1.SETID AND S1.BANK_CD = A1.BANK_CD AND S1.BANK_ACCT_KEY=A1.BANK_ACCT_KEY) BANK_ACCOUNT_NUM , 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.KEY_CHAR_40_01 , S1.KEY_CHAR_40_02 , S1.KEY_CHAR_40_03 , S1.KEY_CHAR_40_04 , S1.KEY_CHAR_40_05 , S1.KEY_CHAR_40_06 , S1.KEY_CHAR_40_07 , S1.KEY_CHAR_40_08 , S1.KEY_CHAR_40_09 , S1.KEY_CHAR_40_10 , S1.KEY_DATE_01 , S1.KEY_DATE_02 , S1.KEY_DATE_03 , S1.KEY_DTTM_01 , S1.KEY_DTTM_02 , S1.KEY_NBR_01 , S1.KEY_NBR_02 , S1.KEY_NBR_03 , S1.KEY_NBR_04 , S1.KEY_NBR_05 FROM PS_CSH_FCST_DTL S1 , PS_POS_SOURCE_TBL P WHERE S1.SETID=P.SETID AND S1.POS_SOURCE_ID=P.POS_SOURCE_ID AND 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_DTL 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.POS_SOURCE_ID=S2.POS_SOURCE_ID AND S1.VALUE_DT = S2.VALUE_DT AND S1.REFERENCE = S2.REFERENCE AND S1.SEQ_NBR=S2.SEQ_NBR AND S2.LINE_ITEM_TYPE='1' AND S2.POS_HIST_FLAG='N') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | WORKSHEET_ID |
Character(20) | VARCHAR2(20) NOT NULL | Cash Flows Worksheet ID |
| 3 | 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 |
| 4 | WRKSHEET_LINE_ITEM |
Character(30) | VARCHAR2(30) NOT NULL | Cash Forecast Worksheet Line item |
| 5 | SOURCE_SET |
Character(20) | VARCHAR2(20) NOT NULL | A field name describing a group od position sources. |
| 6 | POS_SOURCE_ID |
Character(18) | VARCHAR2(18) NOT NULL | "A unique key identifier that represents a position source dataset |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | VALUE_DT |
Date(10) | DATE NOT NULL | Equivalent to a deal transaction's settlement date. |
| 9 | CALC_DT |
Date(10) | DATE NOT NULL | The calculation date for a given data set within the Position tools. |
| 10 | REFERENCE |
Character(30) | VARCHAR2(30) NOT NULL | Field to show when a variable is a reference variable. |
| 11 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 12 | 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 Y/N Table Edit Default Value: N |
| 13 | CALC_TM | Time(15) | TIMESTAMP | The calculation time for a given data set within the Position tools. |
| 14 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 15 | OVERRIDE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Override amount |
| 16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 17 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 18 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 19 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 20 | 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 |
| 21 | POS_IMPCT_WEIGHT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pos Impact Weight Amt Value |
| 22 | POS_IMPCT_WEIGHT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pos Impact Weight Amt Value |
| 23 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
| 24 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |
| 25 | DTL_LINE_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the origin of a cash forecast detail line. The detail line source provides a means of distinguishing between lines generated by the Cash Forecast engine and manually entered override detail lines.
O=Manual Override Detail S=Source Detail |
| 26 | BUSINESS_UNIT_BANK | Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty. |
| 27 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 28 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 29 | 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 |
| 30 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 31 | GRP_BY_FIELD_1 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 32 | GRP_BY_FIELD_2 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 33 | GRP_BY_FIELD_3 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 34 | GRP_BY_FIELD_4 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 35 | GRP_BY_FIELD_5 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 36 | GRP_BY_FIELD_6 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 37 | GRP_BY_FIELD_7 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 38 | KEY_CHAR_40_01 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/01 |
| 39 | KEY_CHAR_40_02 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/02 |
| 40 | KEY_CHAR_40_03 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/03 |
| 41 | KEY_CHAR_40_04 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/04 |
| 42 | KEY_CHAR_40_05 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/05 |
| 43 | KEY_CHAR_40_06 | Character(40) | VARCHAR2(40) NOT NULL | Key_Char 40/06 |
| 44 | KEY_CHAR_40_07 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/07 |
| 45 | KEY_CHAR_40_08 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/08 |
| 46 | KEY_CHAR_40_09 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/09 |
| 47 | KEY_CHAR_40_10 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/10 |
| 48 | KEY_DATE_01 | Date(10) | DATE | Key Date 01 |
| 49 | KEY_DATE_02 | Date(10) | DATE | Key Date 02 |
| 50 | KEY_DATE_03 | Date(10) | DATE | Key Date 03 |
| 51 | KEY_DTTM_01 | DateTime(26) | TIMESTAMP | Key Date Time 01 |
| 52 | KEY_DTTM_02 | DateTime(26) | TIMESTAMP | Key Date Time 02 |
| 53 | KEY_NBR_01 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 54 | KEY_NBR_02 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 55 | KEY_NBR_03 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 56 | KEY_NBR_04 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 57 | KEY_NBR_05 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |