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 |