OI_CURR_QUOT_VW(SQL View) |
Index Back |
|---|---|
Currency Quotation tableCurrency Quotation table |
| SELECT A.FROM_CUR , A.TO_CUR , A.RATE_DECIMALS , A.QUOTE_UNITS , A.RATE_DIRECT , A.AUTO_RECIPROCATE , A.RATE_TRIANGULATE , A.REF_CUR , A.PRIMARY_VISUAL , A.XRATE_OVERRIDE , A.XRATE_RECALC FROM %Table(CURR_QUOTE_TBL) A WHERE ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM %Table(CURR_QUOTE_TBL) A_ED WHERE A.FROM_CUR = A_ED.FROM_CUR AND A.TO_CUR = A_ED.TO_CUR AND A_ED.EFFDT <= %CurrentDateIn)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FROM_CUR |
Character(3) | VARCHAR2(3) NOT NULL |
From Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 2 | TO_CUR |
Character(3) | VARCHAR2(3) NOT NULL |
To Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 3 | RATE_DECIMALS | Number(1,0) | SMALLINT NOT NULL |
Rate Decimal Positions
Default Value: 4 |
| 4 | QUOTE_UNITS | Number(4,0) | SMALLINT NOT NULL |
Quote Units
Default Value: 1 |
| 5 | RATE_DIRECT | Character(1) | VARCHAR2(1) NOT NULL |
Rate Quotation Basis
D=Direct I=Indirect Default Value: D |
| 6 | AUTO_RECIPROCATE | Character(1) | VARCHAR2(1) NOT NULL |
Auto Reciprocate
Y/N Table Edit Default Value: Y |
| 7 | RATE_TRIANGULATE | Character(1) | VARCHAR2(1) NOT NULL |
Rate Triangulate
Y/N Table Edit Default Value: N |
| 8 | REF_CUR | Character(3) | VARCHAR2(3) NOT NULL |
Reference Currency
Prompt Table: CURRENCY_CD_TBL |
| 9 | PRIMARY_VISUAL | Character(2) | VARCHAR2(2) NOT NULL |
Primary Visual Rate
FR=From Currency --> Ref Currency FT=From Currency --> To Currency RT=Ref Currency --> To Currency Default Value: FT |
| 10 | XRATE_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Cross-Rate Override
Y/N Table Edit Default Value: N |
| 11 | XRATE_RECALC | Character(2) | VARCHAR2(2) NOT NULL |
Cross-Rate Recalculate Option
FR=From Currency --> Ref Currency RT=Ref Currency --> To Currency Default Value: FR |