CSH_FCST_DTL(SQL Table) |
Index Back |
|---|---|
Cash Forecast Detail |
| # | 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 | VALUE_DT |
Date(10) | DATE NOT NULL | Equivalent to a deal transaction's settlement date. |
| 8 | CALC_DT |
Date(10) | DATE NOT NULL | The calculation date for a given data set within the Position tools. |
| 9 | REFERENCE |
Character(30) | VARCHAR2(30) NOT NULL | Field to show when a variable is a reference variable. |
| 10 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 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 Y/N Table Edit Default Value: N |
| 12 | CALC_TM | Time(15) | TIMESTAMP | The calculation time for a given data set within the Position tools. |
| 13 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 14 | OVERRIDE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Override amount |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 17 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 18 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 19 | 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 |
| 20 | POS_IMPCT_WEIGHT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pos Impact Weight Amt Value |
| 21 | POS_IMPCT_WEIGHT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pos Impact Weight Amt Value |
| 22 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
| 23 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |
| 24 | 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 |
| 25 | BUSINESS_UNIT_BANK | Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty. |
| 26 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 27 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 28 | 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 |
| 29 | GRP_BY_FIELD_1 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 30 | GRP_BY_FIELD_2 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 31 | GRP_BY_FIELD_3 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 32 | GRP_BY_FIELD_4 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 33 | GRP_BY_FIELD_5 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 34 | GRP_BY_FIELD_6 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 35 | GRP_BY_FIELD_7 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 36 | KEY_CHAR_40_01 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/01 |
| 37 | KEY_CHAR_40_02 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/02 |
| 38 | KEY_CHAR_40_03 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/03 |
| 39 | KEY_CHAR_40_04 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/04 |
| 40 | KEY_CHAR_40_05 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/05 |
| 41 | KEY_CHAR_40_06 | Character(40) | VARCHAR2(40) NOT NULL | Key_Char 40/06 |
| 42 | KEY_CHAR_40_07 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/07 |
| 43 | KEY_CHAR_40_08 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/08 |
| 44 | KEY_CHAR_40_09 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/09 |
| 45 | KEY_CHAR_40_10 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/10 |
| 46 | KEY_DATE_01 | Date(10) | DATE | Key Date 01 |
| 47 | KEY_DATE_02 | Date(10) | DATE | Key Date 02 |
| 48 | KEY_DATE_03 | Date(10) | DATE | Key Date 03 |
| 49 | KEY_DTTM_01 | DateTime(26) | TIMESTAMP | Key Date Time 01 |
| 50 | KEY_DTTM_02 | DateTime(26) | TIMESTAMP | Key Date Time 02 |
| 51 | KEY_NBR_01 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 52 | KEY_NBR_02 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 53 | KEY_NBR_03 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 54 | KEY_NBR_04 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |
| 55 | KEY_NBR_05 | Number(20,0) | DECIMAL(20) NOT NULL | Generic field for storing source detail key value. |