FND Design Data [Home] [Help]

Table: FA_BOOKS

Product: OFA - Assets
Description: Financial information of each asset
Implementation/DBA Data: TableFA.FA_BOOKS
Primary Key: FA_BOOKS_PK
  1. ColumnTRANSACTION_HEADER_ID_IN
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_BOOKS FK Joins to TableFA_BOOK_CONTROLS FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS FK Joins to TableFA_DEPRN_PERIODS FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_FULLY_RESERVED
FA_BOOKS FK Joins to TableFA_DEPRN_PERIODS FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_FULLY_RETIRED
FA_BOOKS FK Joins to TableFA_DEPRN_PERIODS FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_CAPITALIZED
FA_BOOKS FK Joins to TableFA_CEILING_TYPES FA_BOOKS.CEILING_NAME
FA_BOOKS FK Joins to TableFA_DEPRN_PERIODS FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS.PERIOD_COUNTER_LIFE_COMPLETE
FA_BOOKS FK Joins to TableFA_BONUS_RULES FA_BOOKS.BONUS_RULE
FA_BOOKS FK Joins to TableFA_ADDITIONS_B FA_BOOKS.ASSET_ID
FA_BOOKS FK Joins to TableFA_SUPER_GROUPS FA_BOOKS.SUPER_GROUP_ID
FA_BOOKS FK Joins to TableFA_TRANSACTION_HEADERS FA_BOOKS.TRANSACTION_HEADER_ID_IN
FA_BOOKS FK Joins to TableFA_TRANSACTION_HEADERS FA_BOOKS.TRANSACTION_HEADER_ID_OUT
FA_BOOKS FK Joins to TableFA_METHODS FA_BOOKS.DEPRN_METHOD_CODE
FA_BOOKS.LIFE_IN_MONTHS
FA_BOOKS FK Joins to TableFA_CONVENTION_TYPES FA_BOOKS.PRORATE_CONVENTION_CODE
FA_BOOKS FK Joins to TableFA_RETIREMENTS FA_BOOKS.RETIREMENT_ID
FA_BOOKS FK Joins to TableFND_CONCURRENT_REQUESTS FA_BOOKS.TAX_REQUEST_ID
FA_BOOKS FK Joins to TableFA_ITC_RATES FA_BOOKS.ITC_AMOUNT_ID
TableFA_CAPITAL_BUDGET FK Joins to FA_BOOKS FA_CAPITAL_BUDGET.BOOK_HEADER_ID
TableFA_DISTRIBUTION_HISTORY FK Joins to FA_BOOKS FA_DISTRIBUTION_HISTORY.TRANSACTION_HEADER_ID_IN
TableFA_TRANSFER_DETAILS FK Joins to FA_BOOKS FA_TRANSFER_DETAILS.BOOK_HEADER_ID