FA_MC_MASS_RATES
FA_MC_MASS _RATES contains exchange rate information that Oracle Fusion Assets uses during the mass additions posting process.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
FA_MC_MASS_RATES_PK |
SET_OF_BOOKS_ID, MASS_ADDITION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Ledger identifier. Use the Manage Primary Ledgers task to identify valid values. | |
| MASS_ADDITION_ID | NUMBER | 18 | Yes | Oracle internal use only. Unique identification number of the mass addition. | |
| PARENT_MASS_ADDITION_ID | NUMBER | 18 | Oracle internal use only. Mass addition identifier. | ||
| FIXED_ASSETS_COST | NUMBER | Asset cost. Enter without thousands separator. Use either comma or period as decimal separator. | |||
| EXCHANGE_RATE | NUMBER | Exchange rate to convert asset cost to reporting ledger currency. | |||
| LOAD_REQUEST_ID | NUMBER | 18 | Oracle Fusion Enterprise Resource Planning: request ID of the process that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. Incremented every time the row is updated. Compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CURRENCY_CODE | VARCHAR2 | 15 | The currency code of the reporting ledger. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FA_MC_MASS_RATES | gl_ledgers | SET_OF_BOOKS_ID |
| FA_MC_MASS_RATES | fa_mass_additions | MASS_ADDITION_ID |
| FA_MC_MASS_RATES | fa_mass_additions | PARENT_MASS_ADDITION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_MC_MASS_RATES_U1 | Unique | Default | SET_OF_BOOKS_ID, MASS_ADDITION_ID |