FCST_MAN_ENT_VW(SQL View) |
Index Back |
|---|---|
Manual Position EntryManual Position Entry |
| SELECT SETID , POS_CATEGORY , VALUE_DT , REFERENCE , SEQ_NBR , CURRENCY_CD , AMOUNT , BUSINESS_UNIT , BANK_SETID , BANK_CD , BANK_ACCT_KEY , GRP_BY_FIELD_1 , GRP_BY_FIELD_2 , GRP_BY_FIELD_3 , GRP_BY_FIELD_4 , GRP_BY_FIELD_5 , GRP_BY_FIELD_6 , GRP_BY_FIELD_7 , WORKSHEET_ID , SOURCE_SET , D.CALENDAR_DATE FROM PS_MANUAL_POSN_ENT , PS_POS_DAYS_TBL D WHERE D.CALENDAR_DATE = %CurrentDateIn |
| # | 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 | POS_CATEGORY |
Character(30) | VARCHAR2(30) NOT NULL |
Position Category
Prompt Table: WRKSHT_LINES_VW |
| 3 | VALUE_DT |
Date(10) | DATE NOT NULL | Equivalent to a deal transaction's settlement date. |
| 4 | REFERENCE |
Character(30) | VARCHAR2(30) NOT NULL | Field to show when a variable is a reference variable. |
| 5 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 9 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table: SP_SETID_NONVW |
| 10 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_VW14 |
| 11 | 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
Prompt Table: BANK_ACCT_VW11 |
| 12 | GRP_BY_FIELD_1 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 13 | GRP_BY_FIELD_2 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 14 | GRP_BY_FIELD_3 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 15 | GRP_BY_FIELD_4 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 16 | GRP_BY_FIELD_5 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 17 | GRP_BY_FIELD_6 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 18 | GRP_BY_FIELD_7 | Character(40) | VARCHAR2(40) NOT NULL | Generic Group By Field for Cash Forecast summary totals. |
| 19 | WORKSHEET_ID | Character(20) | VARCHAR2(20) NOT NULL |
Cash Flows Worksheet ID
Prompt Table: WORKSHEET_DEFN |
| 20 | SOURCE_SET | Character(20) | VARCHAR2(20) NOT NULL |
A field name describing a group od position sources.
Prompt Table: POS_SOURCE_SET |
| 21 | CALENDAR_DATE | Date(10) | DATE | An internal work field utilized to store calendar dates for a given calendar year. The dates are displa |