FND Design Data [Home] [Help]

Table: FA_MC_DEPRN_PERIODS

Product: OFA - Assets
Description: Information about each depreciation period
Implementation/DBA Data: TableFA.FA_MC_DEPRN_PERIODS
Primary Key: FA_MC_DEPRN_PERIODS_PK
  1. ColumnBOOK_TYPE_CODE
  2. ColumnPERIOD_COUNTER
  3. ColumnSET_OF_BOOKS_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_MC_DEPRN_PERIODS FK Joins to TableFA_BOOK_CONTROLS FA_MC_DEPRN_PERIODS.BOOK_TYPE_CODE
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.CIP_REVAL_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.CIP_TRANSFER_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.DEFERRED_DEPRN_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.DEPRECIATION_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.DEPRN_ADJUSTMENT_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.RECLASS_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.RETIREMENT_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.REVAL_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.TRANSFER_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.ADDITION_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.ADJUSTMENT_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.CIP_ADDITION_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.CIP_ADJUSTMENT_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.CIP_RECLASS_BATCH_ID
FA_MC_DEPRN_PERIODS FK Joins to TableGL_JE_BATCHES FA_MC_DEPRN_PERIODS.CIP_RETIREMENT_BATCH_ID
TableFA_MC_BOOKS FK Joins to FA_MC_DEPRN_PERIODS FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_CAPITALIZED
FA_MC_BOOKS.SET_OF_BOOKS_ID
TableFA_MC_BOOKS FK Joins to FA_MC_DEPRN_PERIODS FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_FULLY_RETIRED
FA_MC_BOOKS.SET_OF_BOOKS_ID
TableFA_MC_BOOKS FK Joins to FA_MC_DEPRN_PERIODS FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_FULLY_RESERVED
FA_MC_BOOKS.SET_OF_BOOKS_ID
TableFA_MC_BOOKS FK Joins to FA_MC_DEPRN_PERIODS FA_MC_BOOKS.BOOK_TYPE_CODE
FA_MC_BOOKS.PERIOD_COUNTER_LIFE_COMPLETE
FA_MC_BOOKS.SET_OF_BOOKS_ID