Oracle Fixed Assets Tables

Tables in Oracle Fixed Assets













1. FA_DEPRN_PERIODS
                       Contains information about your depreciation periods.  Oracle assets uses this table to determine when each period in FA_CALENDARS was open for a depreciation book.

2. FA_DEPREN_SUMMARY
                       Contains depreciation information for your assets.

3. FA_ADDITIONS_B
                       Contains descriptive information to help you identify your assets.

4. FA_BOOKS
                       Contains the information that Oracle assets needs to calculate depreciation.  When you
initially add an asset, Oracle assets inserts one row into the table. This become the active row for the asset.

5. FA_CATEGORIES_B
                       Stores information about your asset categories.  This provide default info when you add on asset.

6. FA_DEPRN_DETAIL
                        Contains the depreciation amounts that the depreciation program charges to the depreciation expense account in each distribution line.


Share on Google Plus

About Pavan Kumar

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.

1 comments:

  1. It's interesting that many of the bloggers to helped clarify a few things for me as well as giving.Most of ideas can be nice content.The people to give them a good shake to get your point and across the command.
    Asset Management Software
    Asset Management Solutions
    Asset Tracking Software
    Fixed Asset Management Software

    ReplyDelete