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 |
