FROM_CURRENCYCUR_RT_TYPEAS_OF_DATECUR_RT_TYPE_SVW(SQL View) |
Index Back |
|---|---|
Currency Rate Type Search |
| SELECT DISTINCT from_cur ,cur_rt_type ,effdt FROM PS_CUR_RT_TBL WHERE eff_status = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FROM_CURRENCY |
Character(3) | VARCHAR2(3) NOT NULL | From Currency |
| 2 | CUR_RT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 3 | AS_OF_DATE |
Date(10) | DATE | As of Date |