FND Design Data [Home] [Help]

Table: FA_BOOK_CONTROLS

Product: OFA - Assets
Description: Control information that affects all assets in a depreciation book
Implementation/DBA Data: TableFA.FA_BOOK_CONTROLS
Primary Key: FA_BOOK_CONTROLS_PK
  1. ColumnBOOK_TYPE_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_BOOK_CONTROLS FK Joins to TableFA_CALENDAR_TYPES FA_BOOK_CONTROLS.DEPRN_CALENDAR
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_RETIREMENT_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_DEPRECIATION_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_RECLASS_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_ADDITION_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_ADJUSTMENT_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_TRANSFER_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_DEFERRED_DEPRN_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_CIP_ADJUSTMENT_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_CIP_ADDITION_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_CIP_RECLASS_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_SETS_OF_BOOKS_11I FA_BOOK_CONTROLS.SET_OF_BOOKS_ID
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_CIP_RETIREMENT_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_CIP_REVAL_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_CIP_TRANSFER_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_REVAL_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableGL_JE_CATEGORIES_TL FA_BOOK_CONTROLS.JE_DEPRN_ADJUSTMENT_CATEGORY
FA_BOOK_CONTROLS FK Joins to TableFA_BOOK_CONTROLS FA_BOOK_CONTROLS.MASS_COPY_SOURCE_BOOK
FA_BOOK_CONTROLS FK Joins to TableFND_CONCURRENT_REQUESTS FA_BOOK_CONTROLS.MASS_REQUEST_ID
FA_BOOK_CONTROLS FK Joins to TableGL_CODE_COMBINATIONS FA_BOOK_CONTROLS.FLEXBUILDER_DEFAULTS_CCID
FA_BOOK_CONTROLS FK Joins to TableFA_BOOK_CONTROLS FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK
FA_BOOK_CONTROLS FK Joins to TableFA_DEPRN_PERIODS FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.LAST_PURGE_PERIOD_COUNTER
FA_BOOK_CONTROLS FK Joins to TableFND_CONCURRENT_REQUESTS FA_BOOK_CONTROLS.CREATE_ACCOUNTING_REQUEST_ID
FA_BOOK_CONTROLS FK Joins to TableFA_DEPRN_PERIODS FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.INITIAL_PERIOD_COUNTER
FA_BOOK_CONTROLS FK Joins to TableFA_DEPRN_PERIODS FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.LAST_PERIOD_COUNTER
FA_BOOK_CONTROLS FK Joins to TableFA_DEPRN_PERIODS FA_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_BOOK_CONTROLS.LAST_MASS_COPY_PERIOD_COUNTER
FA_BOOK_CONTROLS FK Joins to TableFA_CALENDAR_TYPES FA_BOOK_CONTROLS.PRORATE_CALENDAR
FA_BOOK_CONTROLS FK Joins to TableFND_CONCURRENT_REQUESTS FA_BOOK_CONTROLS.DEPRN_REQUEST_ID
FA_BOOK_CONTROLS FK Joins to TableFA_FISCAL_YEAR FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR
FA_BOOK_CONTROLS.FISCAL_YEAR_NAME
TableCSI_I_ASSETS FK Joins to FA_BOOK_CONTROLS CSI_I_ASSETS.FA_BOOK_TYPE_CODE
TableFA_ADJUSTMENTS FK Joins to FA_BOOK_CONTROLS FA_ADJUSTMENTS.BOOK_TYPE_CODE
TableFA_ARCHIVE_HISTORY FK Joins to FA_BOOK_CONTROLS FA_ARCHIVE_HISTORY.BOOK_TYPE_CODE
TableFA_BOOKS FK Joins to FA_BOOK_CONTROLS FA_BOOKS.BOOK_TYPE_CODE
TableFA_BOOKS_SUMMARY FK Joins to FA_BOOK_CONTROLS FA_BOOKS_SUMMARY.BOOK_TYPE_CODE
TableFA_BOOK_CONTROLS FK Joins to FA_BOOK_CONTROLS FA_BOOK_CONTROLS.MASS_COPY_SOURCE_BOOK
TableFA_BOOK_CONTROLS FK Joins to FA_BOOK_CONTROLS FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK
TableFA_BUDGET_DISTRIBUTION FK Joins to FA_BOOK_CONTROLS FA_BUDGET_DISTRIBUTION.BOOK_TYPE_CODE
TableFA_CATEGORY_BOOKS FK Joins to FA_BOOK_CONTROLS FA_CATEGORY_BOOKS.BOOK_TYPE_CODE
Table% FK Joins to FA_BOOK_CONTROLS
TableFA_CATEGORY_BOOK_DEFAULTS FK Joins to FA_BOOK_CONTROLS FA_CATEGORY_BOOK_DEFAULTS.BOOK_TYPE_CODE
TableFA_DEFERRED_DEPRN FK Joins to FA_BOOK_CONTROLS FA_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE
TableFA_DEFERRED_DEPRN FK Joins to FA_BOOK_CONTROLS FA_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE
TableFA_DELETED_MASS_ADDITIONS FK Joins to FA_BOOK_CONTROLS FA_DELETED_MASS_ADDITIONS.BOOK_TYPE_CODE
TableFA_DEPRN_DETAIL FK Joins to FA_BOOK_CONTROLS FA_DEPRN_DETAIL.BOOK_TYPE_CODE
TableFA_DEPRN_OVERRIDE FK Joins to FA_BOOK_CONTROLS FA_DEPRN_OVERRIDE.BOOK_TYPE_CODE
TableFA_DEPRN_PERIODS FK Joins to FA_BOOK_CONTROLS FA_DEPRN_PERIODS.BOOK_TYPE_CODE
TableFA_DEPRN_SUMMARY FK Joins to FA_BOOK_CONTROLS FA_DEPRN_SUMMARY.BOOK_TYPE_CODE
TableFA_DISTRIBUTION_ACCOUNTS FK Joins to FA_BOOK_CONTROLS FA_DISTRIBUTION_ACCOUNTS.BOOK_TYPE_CODE
TableFA_DISTRIBUTION_HISTORY FK Joins to FA_BOOK_CONTROLS FA_DISTRIBUTION_HISTORY.BOOK_TYPE_CODE
TableFA_DISTRIBUTION_SETS FK Joins to FA_BOOK_CONTROLS FA_DISTRIBUTION_SETS.BOOK_TYPE_CODE
TableFA_INS_POLICIES FK Joins to FA_BOOK_CONTROLS FA_INS_POLICIES.BOOK_TYPE_CODE
TableFA_INVOICE_TRANSACTIONS FK Joins to FA_BOOK_CONTROLS FA_INVOICE_TRANSACTIONS.BOOK_TYPE_CODE
TableFA_MAINT_EVENTS FK Joins to FA_BOOK_CONTROLS FA_MAINT_EVENTS.BOOK_TYPE_CODE
TableFA_MAINT_SCHEDULE_HDR FK Joins to FA_BOOK_CONTROLS FA_MAINT_SCHEDULE_HDR.BOOK_TYPE_CODE
Table% FK Joins to FA_BOOK_CONTROLS
TableFA_MASS_ADDITIONS FK Joins to FA_BOOK_CONTROLS FA_MASS_ADDITIONS.BOOK_TYPE_CODE
TableFA_MASS_CHANGES FK Joins to FA_BOOK_CONTROLS FA_MASS_CHANGES.BOOK_TYPE_CODE
TableFA_MASS_CHANGES_ITF FK Joins to FA_BOOK_CONTROLS FA_MASS_CHANGES_ITF.BOOK
TableFA_MASS_RECLASS FK Joins to FA_BOOK_CONTROLS FA_MASS_RECLASS.BOOK_TYPE_CODE
TableFA_MASS_RECLASS_ITF FK Joins to FA_BOOK_CONTROLS FA_MASS_RECLASS_ITF.BOOK
TableFA_MASS_RETIREMENTS FK Joins to FA_BOOK_CONTROLS FA_MASS_RETIREMENTS.BOOK_TYPE_CODE
TableFA_MASS_REVALUATIONS FK Joins to FA_BOOK_CONTROLS FA_MASS_REVALUATIONS.BOOK_TYPE_CODE
TableFA_MASS_REVAL_REP_ITF FK Joins to FA_BOOK_CONTROLS FA_MASS_REVAL_REP_ITF.BOOK_TYPE_CODE
TableFA_MASS_TAX_ADJUSTMENTS FK Joins to FA_BOOK_CONTROLS FA_MASS_TAX_ADJUSTMENTS.ADJUSTED_BOOK_TYPE_CODE
TableFA_MASS_TAX_ADJUSTMENTS FK Joins to FA_BOOK_CONTROLS FA_MASS_TAX_ADJUSTMENTS.CONTROL_BOOK_TYPE_CODE
TableFA_MASS_TRANSFERS FK Joins to FA_BOOK_CONTROLS FA_MASS_TRANSFERS.BOOK_TYPE_CODE
TableFA_MC_ADJUSTMENTS FK Joins to FA_BOOK_CONTROLS FA_MC_ADJUSTMENTS.BOOK_TYPE_CODE
TableFA_MC_BOOKS_RATES FK Joins to FA_BOOK_CONTROLS FA_MC_BOOKS_RATES.BOOK_TYPE_CODE
TableFA_MC_BOOK_CONTROLS FK Joins to FA_BOOK_CONTROLS FA_MC_BOOK_CONTROLS.BOOK_TYPE_CODE
TableFA_MC_CONVERSION_HISTORY FK Joins to FA_BOOK_CONTROLS FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE
TableFA_MC_CONVERSION_RATES FK Joins to FA_BOOK_CONTROLS FA_MC_CONVERSION_RATES.BOOK_TYPE_CODE
TableFA_MC_DEFERRED_DEPRN FK Joins to FA_BOOK_CONTROLS FA_MC_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE
TableFA_MC_DEFERRED_DEPRN FK Joins to FA_BOOK_CONTROLS FA_MC_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE
TableFA_MC_DEPRN_DETAIL FK Joins to FA_BOOK_CONTROLS FA_MC_DEPRN_DETAIL.BOOK_TYPE_CODE
TableFA_MC_DEPRN_PERIODS FK Joins to FA_BOOK_CONTROLS FA_MC_DEPRN_PERIODS.BOOK_TYPE_CODE
TableFA_MC_DEPRN_SUMMARY FK Joins to FA_BOOK_CONTROLS FA_MC_DEPRN_SUMMARY.BOOK_TYPE_CODE
TableFA_PARALLEL_WORKERS FK Joins to FA_BOOK_CONTROLS FA_PARALLEL_WORKERS.BOOK_TYPE_CODE
TableFA_PERIODIC_PRODUCTION FK Joins to FA_BOOK_CONTROLS FA_PERIODIC_PRODUCTION.BOOK_TYPE_CODE
TableFA_RETIREMENTS FK Joins to FA_BOOK_CONTROLS FA_RETIREMENTS.BOOK_TYPE_CODE
TableFA_SHORT_TAX_RESERVES FK Joins to FA_BOOK_CONTROLS FA_SHORT_TAX_RESERVES.TAX_BOOK
TableFA_TAX_INTERFACE FK Joins to FA_BOOK_CONTROLS FA_TAX_INTERFACE.BOOK_TYPE_CODE
TableFA_TRANSACTION_HEADERS FK Joins to FA_BOOK_CONTROLS FA_TRANSACTION_HEADERS.BOOK_TYPE_CODE
TableFA_TRANSACTION_INTERFACE FK Joins to FA_BOOK_CONTROLS FA_TRANSACTION_INTERFACE.BOOK_TYPE_CODE
TableFA_TRX_REFERENCES FK Joins to FA_BOOK_CONTROLS FA_TRX_REFERENCES.BOOK_TYPE_CODE
TableIA_REQUEST_DETAILS FK Joins to FA_BOOK_CONTROLS IA_REQUEST_DETAILS.BOOK_TYPE_CODE
TableIA_REQUEST_HEADERS FK Joins to FA_BOOK_CONTROLS IA_REQUEST_HEADERS.BOOK_TYPE_CODE
TableJA_AU_BAL_CHG_APPLIED FK Joins to FA_BOOK_CONTROLS JA_AU_BAL_CHG_APPLIED.BOOK_TYPE_CODE
TableJA_AU_BAL_CHG_INTERFACE FK Joins to FA_BOOK_CONTROLS JA_AU_BAL_CHG_INTERFACE.BOOK_TYPE_CODE
TableJA_AU_BAL_CHG_SOURCE FK Joins to FA_BOOK_CONTROLS JA_AU_BAL_CHG_SOURCE.BOOK_TYPE_CODE
TableJA_AU_CAPITAL_VALUE FK Joins to FA_BOOK_CONTROLS JA_AU_CAPITAL_VALUE.BOOK_TYPE_CODE
TableJA_AU_FA_BOOK_CONTROLS FK Joins to FA_BOOK_CONTROLS JA_AU_FA_BOOK_CONTROLS.BOOK_TYPE_CODE
TableJL_CO_FA_ADJUSTMENTS FK Joins to FA_BOOK_CONTROLS JL_CO_FA_ADJUSTMENTS.BOOK_TYPE_CODE
TableJL_CO_FA_APPRAISAL_BOOKS FK Joins to FA_BOOK_CONTROLS JL_CO_FA_APPRAISAL_BOOKS.BOOK_TYPE_CODE
TableJL_CO_FA_PURGE FK Joins to FA_BOOK_CONTROLS JL_CO_FA_PURGE.BOOK_TYPE_CODE
TablePA_IMPLEMENTATIONS_ALL FK Joins to FA_BOOK_CONTROLS PA_IMPLEMENTATIONS_ALL.BOOK_TYPE_CODE
TablePA_STANDARD_UNIT_COSTS FK Joins to FA_BOOK_CONTROLS PA_STANDARD_UNIT_COSTS.BOOK_TYPE_CODE