CSH_FCST_U_PREF(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | POS_ZERODAY_CB | Character(1) | VARCHAR2(1) NOT NULL |
A checkbox that is used to determine if the user would like to view zero day columns on the CPW.
Y/N Table Edit |
| 3 | LOCK_REMINDER | Character(1) | VARCHAR2(1) NOT NULL |
Reminder to Lock field for Position Manager
Y/N Table Edit |
| 4 | TR_TRANSFER_BAX | Character(2) | VARCHAR2(2) NOT NULL |
Transfer Type
01=EFT Transfer 02=Bank Transfer 03=Deal Entry |
| 5 | TR_WR_TEMPLATE_ID | Character(12) | VARCHAR2(12) NOT NULL |
Treasury Wires / Treasury Wire Templates
This uniquely identifies templates within a Business Unit.
Prompt Table: TR_WR_TMPL_VW |
| 6 | BAX_TEMPLATE_ID | Character(12) | VARCHAR2(12) NOT NULL |
An unique key identifier that represents a bank transfer transaction template.
Prompt Table: BAX_TEMPLATE_V2 |
| 7 | INSTRUMENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Instrument type
Prompt Table: INSTR_XFR_VW |
| 8 | FCST_SHOW_DIM | Number(1,0) | SMALLINT NOT NULL |
This field is used to allow user to specify the top dimensions they would like to see on the Trend Analysis Chart on Cash Forecast. Takes a value upto 9
Default Value: 5 |
| 9 | FCST_TREND_DAYS | Number(2,0) | SMALLINT NOT NULL |
This field is used to allow user to specify the days they would like to chart on the Trend Analysis Chart on Cash Forecast. Takes a value upto 99
Default Value: 7 |
| 10 | PMT_SRCH_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Use Saved Searches
Prompt Table: CSH_FCST_SR_DTL |
| 11 | NON_CASH_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a position source is a non-cash flow source.
Y/N Table Edit Default Value: N |
| 12 | POS_RUN_REPORT | Character(1) | VARCHAR2(1) NOT NULL |
Generate Report
Y/N Table Edit |
| 13 | PT_FORMAT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Format Type
HTM=HTML PDF=PDF RTF=RTF TXT=TXT XLS=XLS |