POR_CUR_CONV_FACTOR_SESSION_GT
POR_CUR_CONV_FACTOR_SESSION_GT stores the conversion factor which will be used to convert the item price from transactional currency to functional currency.
Details
-
Schema: FUSION
-
Object owner: POR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | 20 | Yes | User's Functional Currency Code |
| TXN_CURRENCY_CODE | VARCHAR2 | 20 | Yes | Transactional Currency Code in ctx header table |
| CONVERSION_FACTOR | NUMBER | Conversion factor used to convert transactional currency into functional currency |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| POR_CUR_CONV_FACTOR_GT_U1 | Unique | TXN_CURRENCY_CODE |