FA_MC_CONVERSION_RATES

FA_MC_CONVERSION_RATES contains exchange rate information to convert assets from primary to reporting books during MRC Asset Transactions Upgrade. When you run Phase 1 of the MRC Asset Transactions Upgrade, this table will store all the assets that will be converted. Once Phase 1 is complete you can provide a CONVERSION_BASIS of either R or C to convert each asset. If you provide R as the basis, you will have to provide an exchange rate to use for conversion or use the default rate as defined in the GL conversion options. If you provide a conversion basis of C, you will have to provide the COST of the asset in the reporting currency. PRIMARY_CUR_COST reflects the COST of the asset in the primary book and you should not update this column. STATUS column is used during Phase 2 of the upgrade and will reflect CF or CL once Phase 2 is complete.

Details

• Schema: FUSION

• Object owner: FA

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
FA_MC_CONVERSION_RATES_PK	SET_OF_BOOKS_ID, BOOK_TYPE_CODE, ASSET_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SET_OF_BOOKS_ID	NUMBER		18	Yes	Identifier of the accounting ledger.
BOOK_TYPE_CODE	VARCHAR2	30		Yes	Unique book identification name.
ASSET_ID	NUMBER		18	Yes	Identifier of the asset number.
STATUS	VARCHAR2	2		Yes	Status of currency conversion for transactions.
COST	NUMBER				Total recorded cost of the asset.
PRIMARY_CUR_COST	NUMBER			Yes	Cost of an asset in the primary currency.
EXCHANGE_RATE	NUMBER				Rate used for converting amounts between primary currency and reporting currency.
CONVERSION_BASIS	VARCHAR2	1			Basis for converting transaction amounts from primary ledger currency to the reporting currency.
LAST_PERIOD_COUNTER	NUMBER		18	Yes	Last period asset depreciated in primary book at time of reporting conversion.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LEASE_ID	NUMBER		18		Identifier of the capital or operating lease.

Foreign Keys

Table	Foreign Table	Foreign Key Column
FA_MC_CONVERSION_RATES	fa_additions_b	ASSET_ID
FA_MC_CONVERSION_RATES	fa_book_controls	BOOK_TYPE_CODE
FA_MC_CONVERSION_RATES	gl_ledgers	SET_OF_BOOKS_ID
FA_MC_CONVERSION_RATES	fa_mc_book_controls	SET_OF_BOOKS_ID, BOOK_TYPE_CODE
FA_MC_CONVERSION_RATES	fa_deprn_periods	BOOK_TYPE_CODE, LAST_PERIOD_COUNTER

Indexes

Index	Uniqueness	Tablespace	Columns
FA_MC_CONVERSION_RATES_U1	Unique	Default	SET_OF_BOOKS_ID, BOOK_TYPE_CODE, ASSET_ID