FND Design Data [Home] [Help]

Table: FA_CATEGORY_BOOK_DEFAULTS

Product: OFA - Assets
Description: Default depreciation rules for asset category and book combination for a particular date placed in service range
Implementation/DBA Data: TableFA.FA_CATEGORY_BOOK_DEFAULTS
Primary Key: FA_CATEGORY_BOOK_DEFAULTS_PK
  1. ColumnCATEGORY_ID
  2. ColumnBOOK_TYPE_CODE
  3. ColumnSTART_DPIS
Foreign Keys
Table
Foreign Table Foreign Key Column
FA_CATEGORY_BOOK_DEFAULTS FK Joins to TableFA_CATEGORIES_B FA_CATEGORY_BOOK_DEFAULTS.CATEGORY_ID
FA_CATEGORY_BOOK_DEFAULTS FK Joins to TableFA_ADDITIONS_B FA_CATEGORY_BOOK_DEFAULTS.GROUP_ASSET_ID
FA_CATEGORY_BOOK_DEFAULTS FK Joins to TableFA_BOOK_CONTROLS FA_CATEGORY_BOOK_DEFAULTS.BOOK_TYPE_CODE
FA_CATEGORY_BOOK_DEFAULTS FK Joins to TableFA_METHODS FA_CATEGORY_BOOK_DEFAULTS.DEPRN_METHOD
FA_CATEGORY_BOOK_DEFAULTS.LIFE_IN_MONTHS
FA_CATEGORY_BOOK_DEFAULTS FK Joins to TableFA_CONVENTION_TYPES FA_CATEGORY_BOOK_DEFAULTS.PRORATE_CONVENTION_CODE
FA_CATEGORY_BOOK_DEFAULTS FK Joins to TableFA_CEILING_TYPES FA_CATEGORY_BOOK_DEFAULTS.CEILING_NAME
FA_CATEGORY_BOOK_DEFAULTS FK Joins to TableFA_PRICE_INDEXES FA_CATEGORY_BOOK_DEFAULTS.PRICE_INDEX_NAME
FA_CATEGORY_BOOK_DEFAULTS FK Joins to TableFA_METHODS FA_CATEGORY_BOOK_DEFAULTS.STL_METHOD_CODE
FA_CATEGORY_BOOK_DEFAULTS.STL_LIFE_IN_MONTHS
FA_CATEGORY_BOOK_DEFAULTS FK Joins to TableFA_CONVENTION_TYPES FA_CATEGORY_BOOK_DEFAULTS.RETIREMENT_PRORATE_CONVENTION