FND Design Data [Home] [Help]

Table: FA_ASSET_HISTORY

Product: OFA - Assets
Description: Historical information about asset reclassifications and unit adjustments
Implementation/DBA Data: TableFA.FA_ASSET_HISTORY
Primary Key: FA_ASSET_HISTORY_PK
  1. ColumnASSET_ID
  2. ColumnDATE_EFFECTIVE
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_ASSET_HISTORY FK Joins to TableFA_ADDITIONS_B FA_ASSET_HISTORY.ASSET_ID
FA_ASSET_HISTORY FK Joins to TableFA_CATEGORIES_B FA_ASSET_HISTORY.CATEGORY_ID
FA_ASSET_HISTORY FK Joins to TableFA_TRANSACTION_HEADERS FA_ASSET_HISTORY.TRANSACTION_HEADER_ID_IN
FA_ASSET_HISTORY FK Joins to TableFA_TRANSACTION_HEADERS FA_ASSET_HISTORY.TRANSACTION_HEADER_ID_OUT