ORACLE_EBS_FA_常用表结构_资产库表

资产排除等级水平 Which hierarchy levels should be excluded from an inheritance rule 资产外部发票报废 External invoice retirements. Identifies the source line(s) to be retired by a mass external retirement 资产会计年度 Range of dates for all fiscal years 资产统一费用 Annual depreciation rates for all flat-rate methods 资产公式 Depreciation rates for formula-based methods 资产分组资产 Contains group asset definitions - flexfield and general descriptive information 资产分组资产默认 Defines accounts to be used for a group asset within a particular book. e.g. Expense account, reserve account etc 资产分组资产规则 Defines the depreciation rules to be followed when depreciating a group asset within a particular book. This is also a history table 资产分组折旧明细 Redundant - mirrors FA_DEPRN_DETAIL and exists purely to store information returned by the depreciation process. Would usually store depreciation charged to expense accounts identified in the distribution list of an asset - since group ass 资产分组折旧比率 Contains the depreciation rates to be used when calculating the reserve amount to be transferred with an asset which is being moved out of a group 资产分组折旧总额 Stores information about depreciation taken on a group asset, in a particular book in a particular period. This is a history table 资产分级控制 For a hierarchy purpose (root node) defines the rules that apply to the hierarchy. e.g. Maximum allowed number of levels, mandatory attributes etc
2 FA_ADDITIONS_B 3 FA_ADDITIONS_TL 4 FA_ADDITION_REP_ITF 5 FA_ADD_WARRANTIES 6 FA_ADJUSTMENTS 7 FA_ADJUST_REP_ITF 8 FA_AMORT_SCHEDULES 9 FA_ARCHIVE_HISTORY 10 FA_ASSET_HIERARCHY 11 FA_ASSET_HIERARCHY_PURPOSE
资产类别账簿 Default financial information for an asset category and depreciation book combination 资产类别账簿默认 Default depreciation rules for asset category and book combination for a particular date placed in service range 资产最高限额 Seeded and user-defined ceilings for depreciation expense, investment tax credit cost basis, and depreciation cost basis 资产最高限额类型 General ceiling information 资产惯例 Detailed prorate convention information
32 FA_CATEGORY_BOOKS 33 FA_CATEGORY_BOOK_DEFAULTS 34 FA_CEILINGS 35 FA_CEILING_TYPES 36 FA_CONVENTIONS 37 FA_CONVENTION_TYPES 38 FA_COSTCLEAR_REP_ITF 39 FA_DEFERRED_DEPRN 40 FA_DELETED_MASS_ADDITIONS 41 FA_DEPRN_BASIS_RULES 42 FA_DEPRN_DETAIL
资产附加规则 Bonus rule information used by the Depreciation program 资产账簿 资产账簿组 Financial information of each asset
Contains financial (cost) information for a group asset within a particular book. This is also a history table. 资产账簿控制 Control information that affects all assets in a depreciation book 资产预算分配 Capital budget information entered manually or uploaded from the FA_BUDGET_INTERFACE table 资产预算借口 Capital budget information to be uploaded into Oracle Assets 资产日历期间 Detailed calendar information 资产日历类型 General calendar information 资产资金预算 Budget assets used to run depreciation projections and reports 资产资金报表ITF Interface table for Report eXchange reports 资产类别B 资产类别TL Default financial information for asset categories (base MLS table) Default financial information for asset categories (base MLS table)Default financial information for asset categories (translated MLS table)
20 FA_BONUS_RULES 21 FA_BOOKS 22 FA_BOOKS_GROUPS 23 FA_BOOK_CONTROLS 24 FA_BUDGET_DISTRIBUTION 25 FA_BUDGET_INTERFACE 26 FA_CALENDAR_PERIODS 27 FA_CALENDAR_TYPES 28 FA_CAPITAL_BUDGET 29 FA_CAP_REP_ITF 30 FA_CATEGORIES_B 31 FA_CATEGORIES_TL
资产惯例类型 Names and descriptions for prorate conventions 资产成本清理报表ITF Interface table for Report eXchange reports 资产递延折旧 Deferred depreciation calculated for each distribution line 资产删除成批增加 Invoice information of mass additions you deleted from the FA_MASS_ADDITIONS table using the Delete Mass Additions form 资产折旧基准规则 Depreciable Basis Rules 资产折旧明细 Depreciation amounts charged to the depreciation expense account in each distribution line
资产折旧代理佣金 Table for Depreciation Override Feature 资产折旧期间 Information about each depreciation period 资产折旧报表ITF Interface table for Report eXchange reports 资产折旧总额 Depreciation information at the asset level 资产折旧税务报表ITF Depreciable Assets Tax Reports interim table 资产分配账户 Table to store account ccids for all distributions for a book 资产分配默认 Distribution set information 资产分配历史 Employee, location, and Accounting Flexfield values assigned to each asset 资产分配集 Header information for distribution sets
43 FA_DEPRN_OVERRIDE 44 FA_DEPRN_PERIODS 45 FA_DEPRN_REP_ITF 46 FA_DEPRN_SUMMARY 47 FA_DEPRN_TAX_REP_ITF 48 FA_DISTRIBUTION_ACCOUNTS 49 FA_DISTRIBUTION_DEFAULTS 50 FA_DISTRIBUTION_HISTORY 51 FA_DISTRIBUTION_SETS 52 FA_EXCLUDE_HIERARCHY_LEVELS 53 FA_EXT_INV_RETIREMENTS 54 FA_FISCAL_YEAR 55 FA_FLAT_RATES 56 FA_FORMULAS 57 FA_GROUP_ASSETS 58 FA_GROUP_ASSET_DEFAULT 59 FA_GROUP_ASSET_RULES 60 FA_GROUP_DEPRN_DETAIL
资产列表报表ITF Interface table for Report eXchange reports 资产余额报表 Temporary storage area for the balance reports 资产余额报表ITF Interface table for Report eXchange reports 资产附加比率 Bonus rate information used by the Depreciation program
12 FA_ASSET_HIERARCHY_VALUES 13 FA_ASSET_HISTORY 14 FA_ASSET_INVOICES 15 FA_ASSET_KEYWORDS 16 FA_ASSET_LISTING_REP_ITF 17 FA_BALANCES_REPORT 18 FA_BALANCES_REP_ITF 19 FA_BONUS_RATES
资产分级目标 Contains Purpose information. This contains rules regarding how the Inheritance Rule Set will be used and whether the relationship between an asset and a node is mandatory or not. 资产分级值 Stores attribute values associated with a hierarchy node that may be inherited by other nodes. 资产历史 Historical information about asset reclassifications and unit adjustments 资产发票 资产关键字 Accounts payable and purchasing information for each asset Asset key flexfield segment combinations
1.数据库一览
# 1 FA_ACE_BOOKS
数据表ID
数据表名称
概要
资产ACE账簿 Financial information for updating ACE book 资产增加B 资产增加TL Descriptive Fra Baidu biblioteknformation about assets (base MLS table) Descriptive information about assets (translated MLS table)
资产增加报表ITF Interface table for Report eXchange reports 资产增加保修单 Warranty information 资产调整 Information used by the posting program to generate journal entry lines in the general ledger 资产调整报表ITF Interface table for Report eXchange reports 资产摊销计划 Amortization schedules 资产存档历史 Archive, purge, and restore request information 资产分级 Defines hierarchy nodes and the relationship between them.