VIEW FA Asset Financials Historical


VIEW FA Asset Financials Historical

Share this:

Price: $199.99

 

Product Description

NOTE - This is a VIEW not a report and enables you to build dozens of reports.  

What happens now?

Once you've decided on the report or view you'd like to buy, simply add it to your basket and proceed through the checkout. You will visit 2checkout.com who are our payment processor, and on successful payment you will return to our site and the code will be unlocked for you to use. There will be a direct link in the order confirmation screen, or you can view the code at any time in the future through your Account screen.

What am I buying?

There are a total of 159 lines of code in this product. Here is an example:
54.    SUBSTR(BOOKS.CAPITALIZE_FLAG,1,1) Capitalize_Flag,
55.    BOOKS.CEILING_NAME Ceiling_Name,
56.    BOOKS.COST Cost,
57.    NVL (Retirement.COST_RETIRED, 0) Cost_Retired,
58.    BOOKS.DATE_PLACED_IN_SERVICE Date_Placed_In_Service,
59.    decode(BOOKS.DEPRN_METHOD_CODE,'MACRS STL MQ',

Report Fields

Asset Number Major Category Minor Category
Tag Number Age In Months Age In Years
Asset Current Cost Asset Depreciate Flag Asset Description
Asset Original Cost Asset Type Base Currency Code
Basic Rate Bonus Rule Book Class
Book Corporate Book Book Depreciation Calendar Book Descriptive Name
Book Name Book Operating Unit Book Posting Frequency
Book Proration Calendar Capitalize Flag Ceiling Name
Cost Retired Current Depreciation Date Placed In Service
Depreciation Method Depreciation Reserve Amount Depreciation Start Date
Effective Date Itc Amount Itc Basis
Asset Key Net Book Value Net Book Value Adjusted
Period Capitalized Period Fully Reserved Period Fully Retired
Production Capacity Prorate Convention Prorate Date
Recoverable Cost Remaining Life In Months Remaining Life In Years
Retirement Date Retirement Pending Flag Retirement Reference
Retirement Status Retirement Type Revaluation Amortized Basis
Revaluation Ceiling Salvage Value Serial Number
Tag Number Total Life In Months Total Life In Years
Unit Of Measure Units Retired Unrevalued Cost