OPRIDPrompt Table: SP_BU_GL_NONVW
Prompt Table: BANK_CD_TBL
Prompt Table: BANK_CURR_VW
Default Value: %date
01=Today
02=Last 7 Days
03=Last 30 days
04=Next 7 Days
05=Next 30 Days
Default Value: 01
STL_MGR_PREF(SQL Table) |
Index Back |
|---|---|
Settlement Selection User PrefSettlement Manager User Preferences |
| # | 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 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 4 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_TBL |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: BANK_CURR_VW |
| 6 | CUTOFF_DAYS | Number(3,0) | SMALLINT NOT NULL | Cutoff Days |
| 7 | SETTLEMENT_DT | Date(10) | DATE |
The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.
Default Value: %date |
| 8 | BUSINESS_DATE | Date(10) | DATE | Represents a date upon which business is conducted within a given company in a given country. |
| 9 | TR_STL_MGR_PERIOD | Character(2) | VARCHAR2(2) NOT NULL |
Settlement Manager Peiods
01=Today 02=Last 7 Days 03=Last 30 days 04=Next 7 Days 05=Next 30 Days Default Value: 01 |