PO_CURR_RATE_VW(SQL View) |
Index Back |
|---|---|
Purchasing Rate View |
| SELECT RT.FROM_CUR ,RT.TO_CUR ,RT.RT_TYPE ,RT.RATE_MULT ,RT.RATE_DIV ,CUR.DECIMAL_POSITIONS FROM PS_RT_RATE_TBL RT , PS_CURRENCY_CD_TBL CUR WHERE RT.RT_RATE_INDEX = ( SELECT RT_RATE_INDEX FROM PS_RT_INDEX_TBL WHERE DEFAULT_INDEX = 'Y') AND RT.TERM = 0 AND %EffdtCheck(RT_RATE_TBL RT1, RT, %CurrentDateIn) AND CUR.CURRENCY_CD = RT.TO_CUR AND CUR.EFF_STATUS = 'A' AND %EffdtCheck(CURRENCY_CD_TBL CUR1, CUR, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FROM_CUR | Character(3) | VARCHAR2(3) NOT NULL | From Currency Code |
| 2 | TO_CUR | Character(3) | VARCHAR2(3) NOT NULL | To Currency Code |
| 3 | 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. |
| 4 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 5 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 6 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |