RT_RATE_INDEXRT_TYPELANGUAGE_CDRT_FX_V_LANG(SQL View) |
Index Back |
|---|---|
View For FX Rt Index and Type |
| SELECT DISTINCT r.rt_rate_index , r.rt_type , i.language_cd , i.descr FROM ps_rt_rate_tbl r , ps_rt_index_lang i WHERE i.RT_rate_index =( SELECT s.rt_rate_index FROM ps_rt_index_tbl s WHERE s.rt_category = '10' AND s.rt_rate_index = i.rt_rate_index ) AND r.RT_RATE_INDEX = i.RT_RATE_INDEX AND term = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RT_RATE_INDEX |
Character(10) | VARCHAR2(10) NOT NULL | Market Rate Index |
| 2 | RT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |