STL_SELECT_PREF(SQL Table) |
Index Back |
|---|---|
Settlement Selection User PrefSettlement Selection 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 | 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 |
| 7 | STL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The current processing status for a given settlement transaction.
S=Selected U=Unselected X=Denied Default Value: U |
| 8 | PMT_DISPLAY_MSG | Character(1) | VARCHAR2(1) NOT NULL |
Show Financial Gateway Message
Y/N Table Edit Default Value: Y |
| 9 | STL_GRID_SORT | Character(1) | VARCHAR2(1) NOT NULL |
Controls the Selection Grid sort
1=Source ID 3=Bank 4=Account 6=Method 7=Amount Default Value: 1 |
| 10 | STL_GRID_FILTER_BY | Character(1) | VARCHAR2(1) NOT NULL |
Source Code
A=(All) B=Bank Fees D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest Calculated R=Wire Fees T=Letter of Credit Fees W=EFT Requests X=Bank Transfers Default Value: A |