oracle fa 表结构,ORACLE_EBS_FA_常用表结构_资产库表

oracle,EBS,FA,常用表结构,资产库表

1.数据库一览

# 1 FA_ACE_BOOKS

数据表ID

数据表名称

概要

资产ACE账簿 Financial information for updating ACE book 资产增加B 资产增加TL Descriptive information about assets (base MLS table) Descriptive information about assets (translated MLS table)

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

资产增加报表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.

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

资产列表报表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

1.数据库一览