AP_PMTS_CURR_VW(SQL View) |
Index Back |
|---|---|
Reporting Currencies View |
| SELECT ( SELECT RT_RATE_INDEX FROM PS_RT_INDEX_TBL WHERE DEFAULT_INDEX = 'Y' ) RT_RATE_INDEX, 0, R.RPTG_CURRENCY_CD, R.RT_TYPE, C.DECIMAL_POSITIONS, C.DESCR %Concat ' (' %Concat C.CURRENCY_CD %Concat ')' FROM PS_CURRENCIES_AP R, PS_CURRENCY_CD_TBL C WHERE C.CURRENCY_CD = R.RPTG_CURRENCY_CD AND EFFDT = ( SELECT MAX(EFFDT) FROM PS_CURRENCY_CD_TBL WHERE EFFDT <= %CurrentDateIn AND CURRENCY_CD = C.CURRENCY_CD ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RT_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Market Rate Index |
| 2 | TERM | Number(5,0) | INTEGER NOT NULL | Term |
| 3 | RPTG_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Reporting Currency |
| 4 | 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. |
| 5 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 6 | RPTG_CURRENCY_DESC | Character(30) | VARCHAR2(30) NOT NULL | Reporting Currency Description |