FND Design Data [Home] [Help]

Table: FA_METHODS

Product: OFA - Assets
Description: Depreciation method information
Implementation/DBA Data: TableFA.FA_METHODS
Primary Key: FA_METHODS_PK
  1. ColumnMETHOD_ID
Primary Key: FA_METHODS_UK1
  1. ColumnMETHOD_CODE
  2. ColumnLIFE_IN_MONTHS
Foreign Keys
Table
Foreign Table Foreign Key Column
TableFA_ACE_BOOKS FK Joins to FA_METHODS FA_ACE_BOOKS.DEPRN_METHOD_CODE
FA_ACE_BOOKS.LIFE_IN_MONTHS
TableFA_BOOKS FK Joins to FA_METHODS FA_BOOKS.DEPRN_METHOD_CODE
FA_BOOKS.LIFE_IN_MONTHS
TableFA_CATEGORY_BOOK_DEFAULTS FK Joins to FA_METHODS FA_CATEGORY_BOOK_DEFAULTS.DEPRN_METHOD
FA_CATEGORY_BOOK_DEFAULTS.LIFE_IN_MONTHS
TableFA_CATEGORY_BOOK_DEFAULTS FK Joins to FA_METHODS FA_CATEGORY_BOOK_DEFAULTS.STL_METHOD_CODE
FA_CATEGORY_BOOK_DEFAULTS.STL_LIFE_IN_MONTHS
TableFA_FLAT_RATES FK Joins to FA_METHODS FA_FLAT_RATES.METHOD_ID
TableFA_FORMULAS FK Joins to FA_METHODS FA_FORMULAS.METHOD_ID
TableFA_MASS_CHANGES FK Joins to FA_METHODS FA_MASS_CHANGES.FROM_METHOD_CODE
FA_MASS_CHANGES.FROM_LIFE_IN_MONTHS
TableFA_MASS_CHANGES FK Joins to FA_METHODS FA_MASS_CHANGES.TO_METHOD_CODE
FA_MASS_CHANGES.TO_LIFE_IN_MONTHS
TableFA_MASS_RECLASS_ITF FK Joins to FA_METHODS FA_MASS_RECLASS_ITF.METHOD
TableFA_MC_BOOKS FK Joins to FA_METHODS FA_MC_BOOKS.DEPRN_METHOD_CODE
FA_MC_BOOKS.LIFE_IN_MONTHS
TableFA_MC_RETIREMENTS FK Joins to FA_METHODS FA_MC_RETIREMENTS.STL_METHOD_CODE
FA_MC_RETIREMENTS.STL_LIFE_IN_MONTHS
TableFA_RATES FK Joins to FA_METHODS FA_RATES.METHOD_ID
TableFA_RESERVE_LEDGER FK Joins to FA_METHODS FA_RESERVE_LEDGER.METHOD_CODE
FA_RESERVE_LEDGER.LIFE
TableFA_RETIREMENTS FK Joins to FA_METHODS FA_RETIREMENTS.STL_METHOD_CODE
FA_RETIREMENTS.STL_LIFE_IN_MONTHS
TableFA_TAX_INTERFACE FK Joins to FA_METHODS FA_TAX_INTERFACE.DEPRN_METHOD_CODE
FA_TAX_INTERFACE.LIFE_IN_MONTHS