FROM_CURTO_CURRT_TYPEEFFDTEOER_MSG_EFF_VW(SQL View) |
Index Back |
|---|---|
Exchange Rate ABM DS - EffDTExchange Rate Application Business Message Data Shape |
| SELECT FROM_CUR , TO_CUR , RT_TYPE , EFFDT , REF_CUR , RATE_MULT , RATE_DIV FROM PS_EOER_MSG_VW A WHERE %EffdtCheck(EOER_MSG_VW A1, A, %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 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | REF_CUR | Character(3) | VARCHAR2(3) NOT NULL | Reference Currency |
| 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 |