FA_BOOK_TRANSACTION_RATES_INT

FA_BOOK_TRANSACTION_RATES_INT contains conversion rate information that Oracle Assets uses during the processing of various transactions.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

FA_BOOK_TRX_RATES_INT_PK

BOOK_TRANSACTION_RATE_ID

Columns

Name Datatype Length Precision Not-null Comments
BOOK_TRANSACTION_RATE_ID NUMBER 18 Yes Oracle internal use only. Book transaction rate interface identifier.
TRANSACTION_INTERFACE_ID NUMBER 18 Yes Oracle internal use only. Parent table's interface identifier.
INTERFACE_TYPE_CODE VARCHAR2 30 Yes Oracle internal use only.The source interface this row is linked to.
BOOK_TYPE_CODE VARCHAR2 30 Yes Oracle internal use only. Name of the asset book.
SET_OF_BOOKS_ID NUMBER 18 Yes Oracle internal use only. Ledger identifier.
LINE_ID NUMBER 18 Oracle internal use only. Line identifier.
INTERFACE_LINE_NUMBER NUMBER 18 Oracle internal use only. Optional number used to link parent and child records when more than one transaction exists on an asset in a given load.
FIXED_ASSETS_COST NUMBER Oracle internal use only. Asset cost in the alternate currency indicated for this row.
EXCHANGE_RATE NUMBER Oracle internal use only. Conversion rate used to convert asset cost to the alternate currency.
CURRENCY_CODE VARCHAR2 15 Oracle internal use only. The currency code of the alternate ledger.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of 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.
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.

Indexes

Index Uniqueness Tablespace Columns
FA_BOOK_TRX_RATES_INT_U1 Unique FA_BOOK_TRX_RATES_INT_U2 BOOK_TRANSACTION_RATE_ID
FA_BOOK_TRX_RATES_INT_U2 Unique FA_BOOK_TRX_RATES_INT_U2 TRANSACTION_INTERFACE_ID, INTERFACE_TYPE_CODE, BOOK_TYPE_CODE, SET_OF_BOOKS_ID