FA Depreciation by period
Description
Categories: Draft, Toolkit - Operations
Columns: Asset Number, Asset Id, Period Counter, Period Name, Fiscal Year, Period Num, Book Type Code, Distribution Id, Deprn Run Date, Deprn Amount ...
Columns: Asset Number, Asset Id, Period Counter, Period Name, Fiscal Year, Period Num, Book Type Code, Distribution Id, Deprn Run Date, Deprn Amount ...
Detail report with asset ID, depreciation run date, depreciation amount per period and depreciation YTD.
SELECT fa.asset_number, fa.asset_id, fdd.period_counter, fdp.period_name, fdp.fiscal_year, fdp.period_num, fdd.book_type_code, fdd.distribution_id, fdd.deprn_run_date, fdd.deprn_amount, fdd.ytd_deprn, fdd.deprn_reserve, fdd.cost, fdd.deprn_adjustment_amount, fdd.event_id, fdd.deprn_run_id FROM fa_additions fa, fa_deprn_periods fdp, fa.fa_deprn_detail fdd WHERE 1=1 AND fa.asset_id = fdd.asset_id AND fdp.period_counter = fdd.period_counter AND fdp.book_type_code = fdd.book_type_code -- AND fa.asset_id = 432178 -- AND fdp.period_name = '04-14' |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Book |
| LOV |