SHEET_IDLINE_NBRFROM_CURTO_CURRT_TYPEEX_CURR_RATE_VW(SQL View) |
Index Back |
|---|---|
Rate ViewThe currency conversion rates. |
| SELECT A.SHEET_ID ,A.LINE_NBR ,RT.FROM_CUR ,RT.TO_CUR ,RT.RT_TYPE ,RT.RATE_MULT ,RT.RATE_DIV ,CUR.DECIMAL_POSITIONS FROM PS_EX_SHEET_LINE A , PS_RT_RATE_TBL RT , PS_CURRENCY_CD_TBL CUR , PS_INSTALLATION_EX INST 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, A.TRANS_DT) AND CUR.CURRENCY_CD = RT.TO_CUR AND CUR.EFF_STATUS = 'A' AND %EffdtCheck(CURRENCY_CD_TBL CUR1, CUR, A.TRANS_DT) AND INST.RT_TYPE = RT.RT_TYPE AND INST.CURRENCY_CD = RT.TO_CUR AND A.CURRENCY_CD = RT.FROM_CUR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 3 | FROM_CUR |
Character(3) | VARCHAR2(3) NOT NULL | From Currency Code |
| 4 | TO_CUR |
Character(3) | VARCHAR2(3) NOT NULL | To Currency Code |
| 5 | 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. |
| 6 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 7 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 8 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |