CURRENCY_CDCUR_RT_TYPEAR_SS_RTYPE_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT a.to_cur , a.rt_type , c.descr FROM ps_rt_rate_tbl a , ps_rt_index_tbl b , PS_RT_TYPE_TBL c WHERE a.rt_rate_index = b.rt_rate_index AND a.term = 0 AND b.default_index = 'Y' AND a.rt_type = c.rt_type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 2 | CUR_RT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |