eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: FA_RETIREMENTS

Product:	OFA - Assets
Description:	Information about asset retirements and reinstatements
Implementation/DBA Data:	FA.FA_RETIREMENTS

Primary Key: FA_RETIREMENTS_PK

RETIREMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
FA_RETIREMENTS	FA_BOOK_CONTROLS	FA_RETIREMENTS.BOOK_TYPE_CODE
FA_RETIREMENTS	FA_ADDITIONS_B	FA_RETIREMENTS.ASSET_ID
FA_RETIREMENTS	FA_TRANSACTION_HEADERS	FA_RETIREMENTS.TRANSACTION_HEADER_ID_IN
FA_RETIREMENTS	FA_TRANSACTION_HEADERS	FA_RETIREMENTS.TRANSACTION_HEADER_ID_OUT
FA_RETIREMENTS	FA_ITC_RECAPTURE_RATES	FA_RETIREMENTS.ITC_RECAPTURE_ID
FA_RETIREMENTS	FA_CONVENTION_TYPES	FA_RETIREMENTS.RETIREMENT_PRORATE_CONVENTION
FA_RETIREMENTS	FA_ADDITIONS_B	FA_RETIREMENTS.TRADE_IN_ASSET_ID
FA_RETIREMENTS	FA_METHODS	FA_RETIREMENTS.STL_METHOD_CODE FA_RETIREMENTS.STL_LIFE_IN_MONTHS
FA_BOOKS	FA_RETIREMENTS	FA_BOOKS.RETIREMENT_ID
FA_DISTRIBUTION_HISTORY	FA_RETIREMENTS	FA_DISTRIBUTION_HISTORY.RETIREMENT_ID
JA_AU_BAL_CHG_SOURCE	FA_RETIREMENTS	JA_AU_BAL_CHG_SOURCE.RETIREMENT_ID
JL_ZZ_FA_RETIREMNT_ADJS	FA_RETIREMENTS	JL_ZZ_FA_RETIREMNT_ADJS.RETIREMENT_ID