FA Depreciation by period

➜ Back to Library
Description
Categories: Enginatics
Repository: Github 
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 
fdd.book_type_code=:book_type_code
 LOV
Download
Related Blitz Reports
FA Fully Reserved Assets - draft FA Tax Preference - draft FA Additions By Source - draft FA Form 4626 - AMT Summary - draft FA Form 4626 - AMT Detail - draft FA Adjusted Form 4626 - AMT Summary - draft FA Adjusted Form 4626 - AMT Detail - draft FA Tax Additions - draft FA Conversion Assets - draft FA Asset Additions - draft
Blitz Report In Action