[Home] [Help] [Dependency Information]
Object Name: | MSC_CURRENCY_CONVERSIONS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
This table holds currency conversion data.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_CURRENCY_CONVERSIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TO_CURRENCY
CONV_TYPE FROM_CURRENCY CONV_DATE CONV_RATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FROM_CURRENCY | VARCHAR2 | (30) | Yes | From Currency |
TO_CURRENCY | VARCHAR2 | (30) | Yes | Reporting Currency |
CONV_DATE | DATE | Yes | Conversion Date | |
CONV_TYPE | VARCHAR2 | (30) | Yes | Conversion Type |
CONV_RATE | NUMBER | Yes | This is the ratio between the to_currency and from_currency | |
LAST_UPDATE_DATE | DATE | Standard WHO column | ||
LAST_UPDATED_BY | NUMBER | Standard WHO column | ||
CREATION_DATE | DATE | Standard WHO column | ||
CREATED_BY | NUMBER | Standard WHO column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
LAST_COLL_INSTANCE_ID | NUMBER | Yes | Instance from which this row was collected last. | |
RN | NUMBER | RN of last collections run that inserted/updated this row. |
Cut, paste (and edit) the following text to query this object:
SELECT FROM_CURRENCY
, TO_CURRENCY
, CONV_DATE
, CONV_TYPE
, CONV_RATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_COLL_INSTANCE_ID
, RN
FROM MSC.MSC_CURRENCY_CONVERSIONS;
MSC.MSC_CURRENCY_CONVERSIONS does not reference any database object
MSC.MSC_CURRENCY_CONVERSIONS is referenced by following:
|
|
|