eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.AR_MC_RATE_ADJUSTMENTS

Object Details

Object Name:	AR_MC_RATE_ADJUSTMENTS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_MC_RATE_ADJUSTMENTS
Subobject Name:
Status:	VALID

The AR_MC_RATE_ADJUSTMENTS table is a Multiple Reporting Currencies (MRC) subtable of the AR_RATE_ADJUSTMENTS_ALL table. The AR_MC_RATE_ADJUSTMENTS table stores currency-related information about exchange rate adjustments for each reporting set of books that is associated with the parent record in the AR_RATE_ADJUSTMENTS_ALL table. Oracle Receivables lets you make adjustments to the rate, rate type, or rate date after posting to General Ledger.
.
The primary keys for this table are SET_OF_BOOKS_ID and RATE_ADJUSTMENT_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_MC_RATE_ADJUSTMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RATE_ADJUSTMENT_ID SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
RATE_ADJUSTMENT_ID	NUMBER	(15)	Yes	Rate adjustment identifier
NEW_EXCHANGE_RATE	NUMBER		Yes	Current exchange rate used to convert foreign currency amounts into functional currency
OLD_EXCHANGE_RATE	NUMBER		Yes	Previous exchange rate used to convert foreign currency amounts into functional currency
NEW_EXCHANGE_RATE_TYPE	VARCHAR2	(30)	Yes	Current conversion type used to convert foreign currency transactions
OLD_EXCHANGE_RATE_TYPE	VARCHAR2	(30)	Yes	Previous conversion type used to convert foreign currency transactions
NEW_EXCHANGE_DATE	DATE		Yes	Current currency conversion rate used to convert the transactional currency amount to reporting currency amount
OLD_EXCHANGE_DATE	DATE		Yes	Previous currency conversion rate used to convert the transactional currency amount to reporting currency amount
GAIN_LOSS	NUMBER		Yes	Gain or loss associated with rate adjustment

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SET_OF_BOOKS_ID
,      RATE_ADJUSTMENT_ID
,      NEW_EXCHANGE_RATE
,      OLD_EXCHANGE_RATE
,      NEW_EXCHANGE_RATE_TYPE
,      OLD_EXCHANGE_RATE_TYPE
,      NEW_EXCHANGE_DATE
,      OLD_EXCHANGE_DATE
,      GAIN_LOSS
FROM AR.AR_MC_RATE_ADJUSTMENTS;

Dependencies

[top of page]

AR.AR_MC_RATE_ADJUSTMENTS does not reference any database object

AR.AR_MC_RATE_ADJUSTMENTS is referenced by following:

APPS: AR_MC_RATE_ADJUSTMENTS