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_DEPRN_PERIODS

Product:	OFA - Assets
Description:	Information about each depreciation period
Implementation/DBA Data:	FA.FA_DEPRN_PERIODS

Primary Key: FA_DEPRN_PERIODS_PK

BOOK_TYPE_CODE
PERIOD_COUNTER

Primary Key: FA_DEPRN_PERIODS_UK1

BOOK_TYPE_CODE
FISCAL_YEAR
PERIOD_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
FA_DEPRN_PERIODS	FA_BOOK_CONTROLS	FA_DEPRN_PERIODS.BOOK_TYPE_CODE
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.CIP_ADDITION_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.CIP_ADJUSTMENT_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.CIP_RECLASS_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.CIP_RETIREMENT_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.CIP_REVAL_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.CIP_TRANSFER_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.REVAL_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.DEPRN_ADJUSTMENT_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.DEPRECIATION_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.RETIREMENT_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.RECLASS_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.TRANSFER_BATCH_ID
FA_DEPRN_PERIODS	FA_DEPRN_PERIODS	FA_DEPRN_PERIODS.BOOK_TYPE_CODE FA_DEPRN_PERIODS.PERIOD_COUNTER
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.ADDITION_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.ADJUSTMENT_BATCH_ID
FA_DEPRN_PERIODS	GL_JE_BATCHES	FA_DEPRN_PERIODS.DEFERRED_DEPRN_BATCH_ID
FA_ADJUSTMENTS	FA_DEPRN_PERIODS	FA_ADJUSTMENTS.BOOK_TYPE_CODE FA_ADJUSTMENTS.PERIOD_COUNTER_ADJUSTED
FA_ADJUSTMENTS	FA_DEPRN_PERIODS	FA_ADJUSTMENTS.BOOK_TYPE_CODE FA_ADJUSTMENTS.PERIOD_COUNTER_CREATED
FA_BOOKS	FA_DEPRN_PERIODS	FA_BOOKS.BOOK_TYPE_CODE FA_BOOKS.PERIOD_COUNTER_FULLY_RESERVED
FA_BOOKS	FA_DEPRN_PERIODS	FA_BOOKS.BOOK_TYPE_CODE FA_BOOKS.PERIOD_COUNTER_FULLY_RETIRED
FA_BOOKS	FA_DEPRN_PERIODS	FA_BOOKS.BOOK_TYPE_CODE FA_BOOKS.PERIOD_COUNTER_CAPITALIZED
FA_BOOKS	FA_DEPRN_PERIODS	FA_BOOKS.BOOK_TYPE_CODE FA_BOOKS.PERIOD_COUNTER_LIFE_COMPLETE
FA_BOOK_CONTROLS	FA_DEPRN_PERIODS	FA_BOOK_CONTROLS.BOOK_TYPE_CODE FA_BOOK_CONTROLS.LAST_PURGE_PERIOD_COUNTER
FA_BOOK_CONTROLS	FA_DEPRN_PERIODS	FA_BOOK_CONTROLS.BOOK_TYPE_CODE FA_BOOK_CONTROLS.INITIAL_PERIOD_COUNTER
FA_BOOK_CONTROLS	FA_DEPRN_PERIODS	FA_BOOK_CONTROLS.BOOK_TYPE_CODE FA_BOOK_CONTROLS.LAST_PERIOD_COUNTER
FA_BOOK_CONTROLS	FA_DEPRN_PERIODS	FA_BOOK_CONTROLS.BOOK_TYPE_CODE FA_BOOK_CONTROLS.LAST_MASS_COPY_PERIOD_COUNTER
FA_DEFERRED_DEPRN	FA_DEPRN_PERIODS	FA_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE FA_DEFERRED_DEPRN.CORP_PERIOD_COUNTER
FA_DEFERRED_DEPRN	FA_DEPRN_PERIODS	FA_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE FA_DEFERRED_DEPRN.TAX_PERIOD_COUNTER
FA_DEPRN_DETAIL	FA_DEPRN_PERIODS	FA_DEPRN_DETAIL.BOOK_TYPE_CODE FA_DEPRN_DETAIL.PERIOD_COUNTER
FA_DEPRN_PERIODS	FA_DEPRN_PERIODS	FA_DEPRN_PERIODS.BOOK_TYPE_CODE FA_DEPRN_PERIODS.PERIOD_COUNTER
FA_DEPRN_SUMMARY	FA_DEPRN_PERIODS	FA_DEPRN_SUMMARY.BOOK_TYPE_CODE FA_DEPRN_SUMMARY.PERIOD_COUNTER
FA_JOURNAL_ENTRIES	FA_DEPRN_PERIODS	FA_JOURNAL_ENTRIES.BOOK_TYPE_CODE FA_JOURNAL_ENTRIES.PERIOD_COUNTER
FA_MC_ADJUSTMENTS	FA_DEPRN_PERIODS	FA_MC_ADJUSTMENTS.BOOK_TYPE_CODE FA_MC_ADJUSTMENTS.PERIOD_COUNTER_CREATED
FA_MC_ADJUSTMENTS	FA_DEPRN_PERIODS	FA_MC_ADJUSTMENTS.BOOK_TYPE_CODE FA_MC_ADJUSTMENTS.PERIOD_COUNTER_ADJUSTED
FA_MC_CONVERSION_HISTORY	FA_DEPRN_PERIODS	FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE FA_MC_CONVERSION_HISTORY.PERIOD_COUNTER_CONVERTED
FA_MC_CONVERSION_HISTORY	FA_DEPRN_PERIODS	FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE FA_MC_CONVERSION_HISTORY.PERIOD_COUNTER_SELECTED
FA_MC_CONVERSION_HISTORY	FA_DEPRN_PERIODS	FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE FA_MC_CONVERSION_HISTORY.PERIOD_COUNTER_START
FA_MC_CONVERSION_RATES	FA_DEPRN_PERIODS	FA_MC_CONVERSION_RATES.BOOK_TYPE_CODE FA_MC_CONVERSION_RATES.LAST_PERIOD_COUNTER
FA_MC_DEPRN_DETAIL	FA_DEPRN_PERIODS	FA_MC_DEPRN_DETAIL.BOOK_TYPE_CODE FA_MC_DEPRN_DETAIL.PERIOD_COUNTER