RT_RATE_INDEXPrompt Table: RT_INDEX_TBL
Y/N Table Edit
Default Value: N
RT_EXCEL_IMPORT(SQL Table) |
Index Back |
|---|---|
Record to import market ratesThis record is used to import market rates. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RT_RATE_INDEX |
Character(10) | VARCHAR2(10) NOT NULL |
Market Rate Index
Prompt Table: RT_INDEX_TBL |
| 2 | EXCEL_RT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Rate type column in Excel spreadsheet. |
| 3 | EXCEL_TERM | Character(3) | VARCHAR2(3) NOT NULL | Term column in Excel spreadsheet. |
| 4 | EXCEL_FROM_CUR | Character(3) | VARCHAR2(3) NOT NULL | From currency column in Excel spreadsheet. |
| 5 | EXCEL_TO_CUR | Character(3) | VARCHAR2(3) NOT NULL | To currency column in Excel spreadsheet. |
| 6 | EXCEL_EFFDT | Character(3) | VARCHAR2(3) NOT NULL | Excel column for the effdt value. |
| 7 | EXCEL_BEG_ROW | Number(6,0) | INTEGER NOT NULL | Start row number of Excel spreadsheet |
| 8 | EXCEL_END_ROW | Number(6,0) | INTEGER NOT NULL | End row number of Excel spreadsheet |
| 9 | EXCEL_RT_RATE | Character(3) | VARCHAR2(3) NOT NULL | Rate column in Excel spreadsheet. |
| 10 | EXCEL_IMPORT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag used to determine if excel data should be imported into Peoplesoft.
Y/N Table Edit Default Value: N |
| 11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 12 | DATETIME_MODIFIED | DateTime(26) | TIMESTAMP | Datetime Modified |
| 13 | EXCEL_MACRO_TXT | Character(254) | VARCHAR2(254) NOT NULL | Macro Call |