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 |