ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN DEE3E31CA2AAFA61E05362FB090564AF with -- -- fa_impairment - impairment transaction -- fa_impairment_q as ( select to_number(:p_set_of_books_id) set_of_books_id, fi.book_type_code, fdp.period_name impairment_period, fcgu.cash_generating_unit cash_gen_unit, fcgu.description cash_gen_unit_desc, fi.impairment_date, fi.impairment_name, fi.description, fi.status status_code, fi.impair_class class_code, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'MASS_TRX_STATUS' and flt.lookup_code = fi.status and flt.language = userenv('lang')) status, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fi.impair_class and flt.language = userenv('lang')) class, fav1.asset_number goodwill_asset, fav1.description goodwill_asset_desc, fav2.asset_number asset, fav2.description asset_desc, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fi.impair_loss_acct) loss_account, fi.net_book_value, fi.net_selling_price, fi.value_in_use, fi.impairment_amount, fi.goodwill_amount, fi.user_date, fi.date_ineffective, fi.reason, fi.split_impair_flag, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fi.split1_impair_class and flt.language = userenv('lang')) split1_impair_class, fi.split1_reason, fi.split1_percent, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fi.split1_loss_acct) split1_loss_account, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fi.split2_impair_class and flt.language = userenv('lang')) split2_impair_class, fi.split2_reason, fi.split2_percent, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fi.split2_loss_acct) split2_loss_account, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fi.split3_impair_class and flt.language = userenv('lang')) split3_impair_class, fi.split3_reason, fi.split3_percent, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fi.split3_loss_acct) split3_loss_account, fi.cash_generating_unit_id, fi.goodwill_asset_id, fi.asset_id, fi.period_counter_impaired, fi.impairment_id from fa_impairments fi, fa_cash_gen_units fcgu, fa_deprn_periods fdp, fa_additions_vl fav1, fa_additions_vl fav2 where fi.cash_generating_unit_id = fcgu.cash_generating_unit_id (+) and fi.book_type_code = fcgu.book_type_code (+) and fi.period_counter_impaired = fdp.period_counter (+) and fi.book_type_code = fdp.book_type_code (+) and fi.goodwill_asset_id = fav1.asset_id (+) and fi.asset_id = fav2.asset_id (+) and fi.book_type_code = :p_book_type_code and fi.period_counter_impaired between :p_start_pc and :p_end_pc union all select fi.set_of_books_id, fi.book_type_code, fdp.period_name impairment_period, fcgu.cash_generating_unit cash_gen_unit, fcgu.description cash_gen_unit_desc, fi.impairment_date, fi.impairment_name, fi.description, fi.status status_code, fi.impair_class class_code, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'MASS_TRX_STATUS' and flt.lookup_code = fi.status and flt.language = userenv('lang')) status, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fi.impair_class and flt.language = userenv('lang')) class, fav1.asset_number goodwill_asset, fav1.description goodwill_asset_desc, fav2.asset_number asset, fav2.description asset_desc, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fi.impair_loss_acct) loss_account, fi.net_book_value, fi.net_selling_price, fi.value_in_use, fi.impairment_amount, fi.goodwill_amount, fi.user_date, fi.date_ineffective, fi.reason, fi.split_impair_flag, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fi.split1_impair_class and flt.language = userenv('lang')) split1_impair_class, fi.split1_reason, fi.split1_percent, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fi.split1_loss_acct) split1_loss_account, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fi.split2_impair_class and flt.language = userenv('lang')) split2_impair_class, fi.split2_reason, fi.split2_percent, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fi.split2_loss_acct) split2_loss_account, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fi.split3_impair_class and flt.language = userenv('lang')) split3_impair_class, fi.split3_reason, fi.split3_percent, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fi.split3_loss_acct) split3_loss_account, fi.cash_generating_unit_id, fi.goodwill_asset_id, fi.asset_id, fi.period_counter_impaired, fi.impairment_id from fa_mc_impairments fi, fa_cash_gen_units fcgu, fa_deprn_periods fdp, fa_additions_vl fav1, fa_additions_vl fav2 where fi.cash_generating_unit_id = fcgu.cash_generating_unit_id (+) and fi.book_type_code = fcgu.book_type_code (+) and fi.period_counter_impaired = fdp.period_counter (+) and fi.book_type_code = fdp.book_type_code (+) and fi.goodwill_asset_id = fav1.asset_id (+) and fi.asset_id = fav2.asset_id (+) and fi.book_type_code = :p_book_type_code and fi.set_of_books_id = :p_set_of_books_id and fi.period_counter_impaired between :p_start_pc and :p_end_pc ), -- -- fa_itf_impairment - impairment transaction financials -- fa_itf_impairment_q as ( select to_number(:p_set_of_books_id) set_of_books_id, fii.book_type_code, fdp.period_name impairment_period, fii.impairment_date, fcgu.cash_generating_unit cash_gen_unit, fcgu.description cash_gen_unit_desc, fii.impair_class class_code, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fii.impair_class and flt.language = userenv('LANG')) class, fav.asset_number asset, fav.description asset_desc, fii.goodwill_asset_flag, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fii.impair_loss_acct) loss_account, fii.reason, -- fii.cost, fii.adjusted_cost, fii.deprn_amount, fii.net_selling_price, fii.value_in_use, fii.net_book_value, (fii.net_book_value - (fii.impairment_amount + nvl(fii.reval_reserve_adj_amount,0))) new_net_book_value, fii.impairment_amount, fii.ytd_deprn, fii.ytd_impairment, fii.reval_reserve_adj_amount, -- fii.split_impair_flag, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fii.split1_impair_class and flt.language = userenv('LANG')) split1_class, fii.split1_reason, fii.split1_reval_reserve, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fii.split1_loss_acct) split1_loss_account, fii.split1_loss_amount, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fii.split2_impair_class and flt.language = userenv('LANG')) split2_class, fii.split2_reason, fii.split2_reval_reserve, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fii.split2_loss_acct) split2_loss_account, fii.split2_loss_amount, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fii.split3_impair_class and flt.language = userenv('LANG')) split3_class, fii.split3_reason, fii.split3_reval_reserve, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fii.split3_loss_acct) split3_loss_account, fii.split3_loss_amount, -- fii.impairment_id, fii.cash_generating_unit_id, fii.period_counter, fii.asset_id from fa_itf_impairments fii, fa_cash_gen_units fcgu, fa_deprn_periods fdp, fa_additions_vl fav where 2=2 and fii.cash_generating_unit_id = fcgu.cash_generating_unit_id (+) and fii.book_type_code = fcgu.book_type_code (+) and fii.period_counter = fdp.period_counter (+) and fii.book_type_code = fdp.book_type_code (+) and fii.asset_id = fav.asset_id (+) and fii.book_type_code = :p_book_type_code union all select to_number(:p_set_of_books_id) set_of_books_id, fii.book_type_code, fdp.period_name impairment_period, fii.impairment_date, fcgu.cash_generating_unit cash_gen_unit, fcgu.description cash_gen_unit_desc, fii.impair_class class_code, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fii.impair_class and flt.language = userenv('LANG')) class, fav.asset_number asset, fav.description asset_desc, fii.goodwill_asset_flag, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fii.impair_loss_acct) loss_account, fii.reason, -- fii.cost, fii.adjusted_cost, fii.deprn_amount, fii.net_selling_price, fii.value_in_use, fii.net_book_value, (fii.net_book_value - (fii.impairment_amount + nvl(fii.reval_reserve_adj_amount,0))) new_net_book_value, fii.impairment_amount, fii.ytd_deprn, fii.ytd_impairment, fii.reval_reserve_adj_amount, -- fii.split_impair_flag, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fii.split1_impair_class and flt.language = userenv('LANG')) split1_class, fii.split1_reason, fii.split1_reval_reserve, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fii.split1_loss_acct) split1_loss_account, fii.split1_loss_amount, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fii.split2_impair_class and flt.language = userenv('LANG')) split2_class, fii.split2_reason, fii.split2_reval_reserve, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fii.split2_loss_acct) split2_loss_account, fii.split2_loss_amount, (select flt.meaning from fa_lookups_tl flt where flt.lookup_type = 'IMPAIRMENT_CLASSIFICATION' and flt.lookup_code = fii.split3_impair_class and flt.language = userenv('LANG')) split3_class, fii.split3_reason, fii.split3_reval_reserve, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = fii.split3_loss_acct) split3_loss_account, fii.split3_loss_amount, -- fii.impairment_id, fii.cash_generating_unit_id, fii.period_counter, fii.asset_id from fa_mc_itf_impairments fii, fa_cash_gen_units fcgu, fa_deprn_periods fdp, fa_additions_vl fav where 2=2 and fii.cash_generating_unit_id = fcgu.cash_generating_unit_id (+) and fii.book_type_code = fcgu.book_type_code (+) and fii.period_counter = fdp.period_counter (+) and fii.book_type_code = fdp.book_type_code (+) and fii.asset_id = fav.asset_id (+) and fii.book_type_code = :p_book_type_code and fii.set_of_books_id = :p_set_of_books_id ) -- -- Main Query -- select fbc.book_type_code, fbc.book_type_name, gsob.name ledger, gsob.currency_code, fi.impairment_name impairement_name, fi.description impairement_desc, fi.goodwill_asset goodwill_asset, fi.goodwill_asset_desc goodwill_asset_desc, fi.goodwill_amount goodwill_amount, -- -- Impairment Transaction -- fi.cash_gen_unit impair_cash_gen_unit, fi.cash_gen_unit_desc impair_cash_gen_unit_desc, fi.impairment_period impair_period, fi.impairment_date impair_date, fi.status impair_status, fi.class impair_class, fi.asset impair_asset, fi.asset_desc impair_asset_desc, fi.loss_account impair_loss_account, fi.net_book_value impair_net_book_value, fi.net_selling_price impair_net_selling_price, fi.value_in_use impair_value_in_use, fi.impairment_amount impair_impairment_amount, fi.user_date impair_user_date, fi.date_ineffective impair_date_ineffective, fi.reason impair_reason, fi.split_impair_flag impair_split_impair_flag, fi.split1_impair_class impair_split1_impair_class, fi.split1_reason impair_split1_reason, fi.split1_percent impair_split1_percent, fi.split1_loss_account impair_split1_loss_account, fi.split2_impair_class impair_split2_impair_class, fi.split2_reason impair_split2_reason, fi.split2_percent impair_split2_percent, fi.split2_loss_account impair_split2_loss_account, fi.split3_impair_class impair_split3_impair_class, fi.split3_reason impair_split3_reason, fi.split3_percent impair_split3_percent, fi.split3_loss_account impair_split3_loss_account, -- -- Impairment Transaction Financials -- fii.cash_gen_unit asset_cash_gen_unit, fii.cash_gen_unit_desc asset_cash_gen_unit_desc, fii.impairment_period asset_impairment_period, fii.impairment_date asset_impairment_date, fii.class_code impairment_class_code, fii.class impairment_class, fii.asset asset_number, fii.asset_desc asset_desc, fii.goodwill_asset_flag, fii.loss_account asset_loss_account, fii.reason impairment_reason, fii.cost, fii.adjusted_cost, fii.deprn_amount, fii.net_selling_price, fii.value_in_use, fii.net_book_value, fii.new_net_book_value, fii.impairment_amount, fii.ytd_deprn, fii.ytd_impairment, fii.reval_reserve_adj_amount, -- fii.split_impair_flag, fii.split1_class, fii.split1_reason, fii.split1_reval_reserve, fii.split1_loss_account, fii.split1_loss_amount, fii.split2_class, fii.split2_reason, fii.split2_reval_reserve, fii.split2_loss_account, fii.split2_loss_amount, fii.split3_class, fii.split3_reason, fii.split3_reval_reserve, fii.split3_loss_account, fii.split3_loss_amount, -- -- IDs -- fi.impairment_id, fi.cash_generating_unit_id impair_cgu_id, fi.goodwill_asset_id impair_goodwill_asset_id, fi.asset_id impair_asset_id, fi.period_counter_impaired impair_period_counter, fii.cash_generating_unit_id asset_cgu_id, fii.period_counter, fii.asset_id asset_id from fa_impairment_q fi, fa_itf_impairment_q fii, fa_book_controls fbc, gl_sets_of_books gsob where 1=1 and fi.book_type_code = fii.book_type_code (+) and fi.set_of_books_id = fii.set_of_books_id (+) and fi.impairment_id = fii.impairment_id (+) and fi.book_type_code = fbc.book_type_code and fi.set_of_books_id = gsob.set_of_books_id order by nvl(fi.cash_gen_unit_desc,fii.cash_gen_unit_desc), nvl(fi.period_counter_impaired,fii.period_counter), fi.goodwill_asset, nvl(fii.asset,fi.asset) Y #,##0.00;[Red]-#,##0.00 AR FA تقرير تخفيض قيمة الأصول Imported from Concurrent Program Application: الأصول Source: تقرير تخفيض قيمة الأصول Short Name: FAXRASIM DB package: D FA Auswertung "Wertminderung von Anlagen" Imported from Concurrent Program Application: Anlagen Source: Auswertung "Wertminderung von Anlagen" Short Name: FAXRASIM DB package: E FA Depreciación de Activos Imported from Concurrent Program Application: Assets Source: Depreciación de Activos Short Name: FAXRASIM DB package: F FA Etat des dépréciations d'immobilisation Imported from Concurrent Program Application: Assets Source: Etat des dépréciations d'immobilisation Short Name: FAXRASIM DB package: I FA Rapporto riduzione durevole del valore cespite Imported from Concurrent Program Application: Assets Source: Rapporto riduzione durevole del valore cespite Short Name: FAXRASIM DB package: JA FA 資産減損レポート Imported from Concurrent Program Application: Assets Source: 資産減損レポート Short Name: FAXRASIM DB package: KO FA 자산 감액 보고서 Imported from Concurrent Program Application: Assets Source: 자산 감액 보고서 Short Name: FAXRASIM DB package: PTB FA Relatório de Imparidade de Ativos Imported from Concurrent Program Application: Assets Source: Relatório de Imparidade de Ativos Short Name: FAXRASIM DB package: RU FA Отчет об обесценении активов Imported from Concurrent Program Application: Активы Source: Отчет об обесценении активов Short Name: FAXRASIM DB package: S FA Nedskrivning av anläggning - rapport Imported from Concurrent Program Application: Assets Source: Nedskrivning av anläggning - rapport Short Name: FAXRASIM DB package: TR FA Varlık Amortisman Raporu Imported from Concurrent Program Application: Duran Varlıklar Source: Varlık Amortisman Raporu Short Name: FAXRASIM DB package: US FA Asset Impairments Source: Asset Impairment Report Short Name: FAXRASIM DB package: ZHS FA 资产损耗报表 Imported from Concurrent Program Application: 资产 Source: 资产损耗报表 Short Name: FAXRASIM DB package: Enginatics R12 only 1=1 2=2 :p_book_type_code :p_end_pc :p_set_of_books_id :p_start_pc 1 -20 2=2 1=2 LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y F Inclure les finances des actifs dépréciés US Include Impaired Asset Financials 2 -10 1=1 fi.status_code=:p_status Char POSTED AR الحالة E Estado F Statut I Stato JA ステータス KO 상태 RU Статус TR Statü US Status ZHS 状态 3 10 :p_book_type_code LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code select case when xrpv.parameter_type='LOV Oracle' and xrrpv.value not like '<multiple_values>%' then xxen_report.id_to_value(xrpv.parameter_id,xrrpv.value) else xrrpv.value end value from xxen_report_parameters_v xrpv, (select xrr.report_id,max(xrr.run_id) run_id from xxen_report_runs xrr where xrr.created_by = fnd_global.user_id and xrr.responsibility_id = fnd_global.resp_id group by xrr.report_id) xrr, xxen_report_run_param_values xrrpv where xrpv.report_name = 'FA Asset Impairments' and xrpv.parameter_name = 'Book' and xrpv.report_id = xrr.report_id and xrr.run_id = xrrpv.run_id and xrpv.parameter_id = xrrpv.parameter_id Y AR الدفتر D AfA-Buch E Libro F Livre I Registro JA 台帳 KO 장부 PTB Livro RU Книга S Bok TR Defter US Book ZHS 帐簿 4 20 :p_set_of_books_id LOV Oracle FA_CA_SOB_CURRENCY Y select gsob.set_of_books_id id, gsob.currency_code value, gsob.name description from gl_sets_of_books gsob where gsob.set_of_books_id in ( select set_of_books_id from fa_book_controls where book_type_code=:$flex$.fa_book_type union all select set_of_books_id from fa_mc_book_controls where book_type_code=:$flex$.fa_book_type) order by gsob.currency_code select set_of_books_id from fa_book_controls where book_type_code=:$flex$.fa_book_type Y AR عملة دفاتر الحسابات D Währung Buchungsstruktur E Divisa de Juego de Libros F Ensemble de livres Monnaie I Divisa set of books JA 会計帳簿通貨 KO 회계장부 통화 PTB Moeda do Conjunto de Livros RU Валюта набора книг S Räkenskapsvaluta TR Yasal Muhasebe Birimi Para Birimi US Set of Books Currency ZHS 帐套币种 5 30 :p_start_pc LOV Oracle FA_PERIOD_COUNTER Y select period_counter id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter>(select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type) order by period_counter select max(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type and dp2.period_close_date is not null Y AR فترة البداية D Von Periode E Período de Inicio F Période de début I Periodo iniziale JA 期間:自 KO 시작 기간 PTB Período Inicial RU Начальный период S Startperiod TR Başlangıç Dönemi US Start Period ZHS 起始期间 6 40 :p_end_pc LOV Oracle FA_END_PERIOD_COUNTER Y select period_counter id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter>=(select period_counter from fa_deprn_periods where book_type_code= :$flex$.fa_book_type and period_counter= :$flex$.fa_period_counter) order by period_counter :$flex$.Start_Period Y AR فترة النهاية D Bis Periode E Período de Finalización F Fin de la période I Periodo finale JA 期間:至 KO 종료 기간 PTB Per. Final RU Конечный период S Slutperiod TR Bitiş Dönemi US End Period ZHS 终止期间 7 50 1=1 fi.impairment_id=:p_impairment_id LOV Oracle FA_IMPAIRMENT Y select impairment_id id, impairment_name value, null description from fa_impairments where book_type_code=:$flex$.fa_book_type order by value,description AR تخفيض القيمة D Wertminderung E Depreciación F Dépréciation I Riduzione durevole del valore JA 減損 KO 감액 PTB Imparidade RU Обесценение S Nedskrivning TR Azalma US Impairment ZHS 损耗 8 60 1=1 nvl(fi.cash_generating_unit_id,fii.cash_generating_unit_id) = :p_cgu_id LOV Oracle FA_CASH_GEN_UNIT Y select cash_generating_unit_id id, cash_generating_unit value, null description from fa_cash_gen_units where book_type_code=:$flex$.fa_book_type order by value,description AR وحدة تكوين النقدية D Kapitalflusseinheit E Unidad Generadora de Efectivo F Unité génératrice de trésorerie I Unità generazione cassa JA 現金生成単位 KO 현금 창출 단위 PTB Unidade de Geração de Caixa RU Генерирующая единица S Enhet för likvidgenerering TR Nakit Oluşturan Birim US Cash Generating Unit ZHS 现金产生单位 :$flex$.Start_Period Start Period End Period :$flex$.fa_book_type Book Cash Generating Unit :$flex$.fa_book_type Book End Period :$flex$.fa_book_type Book Impairment :$flex$.fa_book_type Book Set of Books Currency :$flex$.fa_book_type Book Start Period :$flex$.fa_period_counter Start Period End Period Asset Impairment Report Asset Impairment Report SYSADMIN 23 ADJUSTED_COST 5 ASSET_CASH_GEN_UNIT 6 ASSET_CASH_GEN_UNIT_DESC 2 52 ASSET_CGU_ID 16 ASSET_DESC 54 ASSET_ID 7 ASSET_IMPAIRMENT_DATE 3 8 ASSET_IMPAIRMENT_PERIOD 18 ASSET_LOSS_ACCOUNT 15 ASSET_NUMBER 6 1 BOOK_TYPE_CODE 1 2 BOOK_TYPE_NAME -4.0005 CASH_GEN_UNIT -4.0006 CASH_GEN_UNIT_DESC 22 COST 4 CURRENCY_CODE 24 DEPRN_AMOUNT 14 GOODWILL_AMOUNT 12 GOODWILL_ASSET 5 13 GOODWILL_ASSET_DESC 17 GOODWILL_ASSET_FLAG 10 IMPAIREMENT_DESC 9 IMPAIREMENT_NAME 4 27 IMPAIRMENT_AMOUNT -42.0048 IMPAIRMENT_ASSET_ID -42.0047 IMPAIRMENT_CGU_ID 11 IMPAIRMENT_CLASS -4.0008 IMPAIRMENT_DATE 47 IMPAIRMENT_ID -4.0007 IMPAIRMENT_PERIOD 19 IMPAIRMENT_REASON 50 IMPAIR_ASSET_ID 48 IMPAIR_CGU_ID 49 IMPAIR_GOODWILL_ASSET_ID 51 IMPAIR_PERIOD_COUNTER -42.0045 IMPAIR_TRX_ASSET_ID -42.0043 IMPAIR_TRX_CGU_ID -15.0018 IMPAIR_TRX_GOODWILL_AMOUNT -15.0017 IMPAIR_TRX_GOODWILL_ASSET -42.0044 IMPAIR_TRX_GOODWILL_ASSET_ID -11.0012 IMPAIR_TRX_NAME -42.0046 IMPAIR_TRX_PERIOD_COUNTER 3 LEDGER -15.0016 LOSS_ACCOUNT 25 NET_BOOK_VALUE 20 NET_SELLING_PRICE 26 NEW_NET_BOOK_VALUE -20.0021 OLD_NET_BOOK_VALUE 53 PERIOD_COUNTER -24.0025 REASON 30 REVAL_RESERVE_ADJ_AMOUNT 32 SPLIT1_CLASS 35 SPLIT1_LOSS_ACCOUNT 36 SPLIT1_LOSS_AMOUNT 33 SPLIT1_REASON 34 SPLIT1_REVAL_RESERVE 37 SPLIT2_CLASS 40 SPLIT2_LOSS_ACCOUNT 41 SPLIT2_LOSS_AMOUNT 38 SPLIT2_REASON 39 SPLIT2_REVAL_RESERVE 42 SPLIT3_CLASS 45 SPLIT3_LOSS_ACCOUNT 46 SPLIT3_LOSS_AMOUNT 43 SPLIT3_REASON 44 SPLIT3_REVAL_RESERVE 31 SPLIT_IMPAIR_FLAG 21 VALUE_IN_USE 28 YTD_DEPRN 29 YTD_IMPAIRMENT ADJUSTED_COST VALUE 5 SUM ASSET_CASH_GEN_UNIT ROW 1 ASSET_CASH_GEN_UNIT_DESC ROW 2 ASSET_DESC ROW 4 ASSET_IMPAIRMENT_DATE ROW 5 ASSET_IMPAIRMENT_PERIOD ROW 6 ASSET_NUMBER ROW 3 BOOK_TYPE_CODE FILTER 1 BOOK_TYPE_NAME FILTER 2 CASH_GEN_UNIT ROW 1 CASH_GEN_UNIT_DESC ROW 2 COST VALUE 4 SUM CURRENCY_CODE FILTER 4 DEPRN_AMOUNT VALUE 6 SUM GOODWILL_AMOUNT VALUE 3 SUM GOODWILL_ASSET ROW 10 IMPAIREMENT_DESC ROW 8 IMPAIREMENT_NAME ROW 7 IMPAIRMENT_AMOUNT VALUE 9 SUM IMPAIRMENT_CLASS ROW 9 IMPAIRMENT_DATE ROW 6 IMPAIRMENT_PERIOD ROW 3 IMPAIR_TRX_GOODWILL_AMOUNT VALUE 3 SUM IMPAIR_TRX_GOODWILL_AMOUNT ROW 9 IMPAIR_TRX_GOODWILL_ASSET ROW 10 LEDGER FILTER 3 LOSS_ACCOUNT FILTER 5 NET_BOOK_VALUE VALUE 7 SUM NET_SELLING_PRICE VALUE 1 SUM NEW_NET_BOOK_VALUE VALUE 8 SUM OLD_NET_BOOK_VALUE VALUE 6 SUM REVAL_RESERVE_ADJ_AMOUNT VALUE 12 SUM VALUE_IN_USE VALUE 2 SUM YTD_DEPRN VALUE 10 SUM YTD_IMPAIRMENT VALUE 11 SUM FA Asset Impairment - Asset Impairment Report Template.xlsx US UEsDBBQAAAAIACSmp1y+0BxCqwEAAOEHAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM1VyU7DMBC9I/EPka+ocSkSQqhpDyxHQFA+wI2njdXEtjzT0v49E7csqroQtQguiRN73nuzeKbbn1dlMoOAxtlMnKdtkYDNnTZ2nInXwX3rSiRIympVOguZWACKfu/0pDtYeMCErS1moiDy11JiXkClMHUeLO+MXKgU8WcYS6/yiRqD7LTblzJ3lsBSi2oM0evewkhNS0ru5vx7qWRorEhuludqqkwo70uTK+JtObN6jaTlRiOTg3b5tGKTFH0ApbEAoKpMfTCMFF6AiB1DITdyBiixGenKq5QtozAsjMczdn0LQ72z3auV3SOnIxgNyZMK9KAq9l3OS/nmwmTo3CTdDdI0NDFEaaWM/dC9gz8eRhlf50cWUvsXgRvq6PwTHRd/pMObmaMbxVdPfi35Rhlr6pI8dpo2cezJ2EaFz5C7oPH35K0I9mgj7lgg4/NwKRFmDyHSogQ8cq0sQfcxFyqAfiHuheOjC/iO/ZNyGKghK15WbFwfHv21lv+JvEsOz4un4DzySArQPCkf/b+2bnkGgkBmdyI+GXmeNSdcm3JQD0wNegO3jAO69w5QSwMEFAAAAAgAJKanXLVVMCPuAAAATAIAAAsAAABfcmVscy8ucmVsc42Sz07DMAzG70i8Q+T76m5ICKGlu0xIuyFUHsAk7h+1jaMkQPf2hAOCSmPb0fbnzz9b3u7maVQfHGIvTsO6KEGxM2J712p4rZ9WD6BiImdpFMcajhxhV93ebF94pJSbYtf7qLKLixq6lPwjYjQdTxQL8exypZEwUcphaNGTGahl3JTlPYa/HlAtPNXBaggHeweqPvo8+bK3NE1veC/mfWKXToxAnhM7y3blQ2YLqc/bqJpCy0mDFfOc0xHJ+yJjA54m2lxP9P+2OHEiS4nQSODzPN+Kc0Dr64Eun2ip+L3OPOKnhOFNZPhhwcUPVF9QSwMEFAAAAAgAJKanXLtzkmOkAQAAdAMAABAAAABkb2NQcm9wcy9hcHAueG1snZNNb9swDIbvA/ofBN0TuU1RDIGiImhXdMCGBYvbnTWZjoXKkiGyRrJfP9lGHKddL7vx4xX1UKTk7b52rIWINvgVv5xnnIE3obB+t+JP+cPsM2dI2hfaBQ8rfgDkt+rik9zE0EAkC8hSCY8rXhE1SyHQVFBrnKe0T5kyxFpTcuNOhLK0Bu6Dea3Bk7jKshsBewJfQDFrxoJ8qLhs6X+LFsF0fPicH5oErGQeSLvc1qAyKU6OXDeNs0ZT6l59tyYGDCWxL3sDToppUibqLZjXaOnQ1Zi6cmu0g7t0oSq1Q5DiFJCPoLvH3GgbUcmWli0YCpGh/ZOe84qz3xqhw1zxVkerPSXcTjY4ve0apKh+hfiCFQChFGOwN6faqW2v1aIXJONc2J/qQVLiHDG35AB/lBsd6R/EiylxDzbwDowPa7ZGBGJf6yZ13I15CjvqNrYNNHsrZT+hCfGDEzrqGiht6rvuj328If9m/Qs+NXm41wTHyZwH5bbSEYo0zHFyY0A+pqFE1xW5q7TfQXHUvE90e/Q8fCJ1eTPPFllakUlMitN3UX8BUEsDBBQAAAAIACSmp1xBAfRWNgEAAFECAAARAAAAZG9jUHJvcHMvY29yZS54bWyNklFLwzAUhd8F/0PJe5u0005C24HKnhwIThTfQnLXBZs0JNFu/9603boN9uDjvefcL+deUix2qol+wTrZ6hKlCUERaN4KqesSva+X8QOKnGdasKbVUKI9OLSobm8KbihvLbza1oD1ElwUSNpRbkq09d5QjB3fgmIuCQ4dxE1rFfOhtDU2jH+zGnBGSI4VeCaYZ7gHxmYiogNS8AlpfmwzAATH0IAC7R1OkxSfvB6sclcHBuXMqaTfm7DTIe45W/BRnNw7Jydj13VJNxtihPwp/ly9vA2rxlL3t+KAqkJwyi0w39qqCGlPRThcw5xfhRtvJIjHfdCv9AQf4o5zIKIQgI5xj8rH7Ol5vURVRrIsJnmczdckp+mc3pOv/smL+T7Q2FCHh/9NvJvTND8jHgFj7stPUP0BUEsDBBQAAAAIACSmp1xNQdbSGgEAAHsEAAAaAAAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHO9lMFKxDAQhu+C7xDmbtN2dRXZdA8uwl51fYDQTtuwbRIycbVvb6zQWljqHoqXwMwk//8xzGSz/WwbdkJHymgBSRQDQ52bQulKwNvh+eYBGHmpC9kYjQI6JNhm11ebF2ykD4+oVpZYUNEkoPbePnJOeY2tpMhY1KFSGtdKH0JXcSvzo6yQp3G85u63BmQTTbYvBLh9sQJ26Gxw/lvblKXKcWfy9xa1P2PBP4w7Uo3og6h0FXoBQ4p4X1lFgRj4eZj7JWGolg6LV+9Cr2kEmqTnYNIlYS7oTDoHk/wzTDIHs14ShnzXhKEfBuYnnrO/W9Leh1XC0b0PeX/OtuB2SQarTsY/ybDVOyyVVt97PyKNVX7u4oDJJ19G9gVQSwMEFAAAAAgAJKanXOIrf3u7AAAAMwEAADIAAAB4bC9waXZvdENhY2hlL19yZWxzL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWwucmVsc4WPwWrDMBBE74X+g9h7LTuHUIrlHBICuQbnAxZpbYvYWqFVQvz30TGhhR6HYd7MtLvHMqs7JfEcDDRVDYqCZefDaODSH7++QUnG4HDmQAZWEth1nx/tmWbMJSSTj6IKJYiBKef4o7XYiRaUiiOF4gycFsxFplFHtFccSW/qeqvTKwO6N6Y6OQPp5BpQ/RpL8/9sHgZv6cD2tlDIf1To6O+c91jmnclyclLgmEbKBn5ZTVWmg+5a/Xa1ewJQSwMEFAAAAAgAJKanXCmO58oHBgAAoCIAACcAAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWzVWtFu6jgQfV9p/8HK0+4DEIdAAZVehQBd9rZQQXulfUwTA9kmMbKTlmp1/33HdoBAaUkqaG9RRYltzRyPzxyPDefflmGAHgnjPo3aGi7rGiKRSz0/mrW1u9t+qaEhHjuR5wQ0Im3tmXDt28Xvv50v/Eca2447J10y9SM/BgMIjEW8rc3jeNGqVDh0hg4v0wWJoGdKWejE8MhmFb5gxPH4nJA4DCqGrtcroeNHmrLQYnls0OnUd0mXuklIolgZYSRwBBI+9xd8ZS1085gLHfaQLEouDRdg4t4P/PhZGtVQ6LYGs4gy5z6AECzZyvDyJc7QdxnldBqXwVBFQXwxW2wC0EdfxFxDrOV7bY0NPAyfyZQRiIrXeW5rVhLPKfhKG0fRFXVgZHZY14kBkGnis2a5Xq3hpoGNZr2qIRfCGxPvx2phYRJr29nG0I/GyqeY27oHLDDiUubZNIli8AAzZq1EAP1PT18l+G+JN73Uh5d8q0O8xOundnHuCm5MaMJcguLnBeB8ouxBLjn0rj+nIwAdzBi3Op0aEE4Mamt9C1mckxgNYEl8JlZZq1ycVzKWUzd9nwQeR65CWzNX7mU7ipwQvHcofUC3AATZ1CMaipKwH8YDmJIOwyEAjHiDmIRrM1g0o8e2NrqZIHs0vpHOMwNXUKSXLJIXHoeAoJjH3ti6HYyGyvEIHnqoMxp9LwrhingzAhzKP9kfkpZotCBMZRL6425i/VnUsZ0wBkLyXDjYd5NuUV+KJLbD5+iSROgOxCjHjI3V8tqXd7qOhVO52vLROAIG1CXcLQQknYGMfDSTE0Fb0PYPeCfYTVYhoSNvI41ikGc+IaF/7S+JJ/IIhB52C5eqriGNlBpl2lQDCNZq0CRmcmOBMaA8qtvQsV7SjZKOb3W9Jf+g11nu9BqZ3jTPRYJ6Ysn2mSiYq7tCg24I86mXY/nWMtEn9yWsFyWOWgUixA3llIkd5qISEq5FENYk/osmXFBoElP3Yau7iIBlsR0ms+JBJ3Cih3TRpRqL+IQFVyNDTTtwOOzkBwVsExTQrCRcyHqETlEPuEdhV0YdEkGhIncQledzJ5oR5EfohkGFwuJn+AC7NS+6gpeUek9+EKjNKk8aHSVG225ziM3O+qx30te2r42DUOyreSaWye9VymfnmipFEt4TqJwyujCIYgL7lGwDYfjhBIlSEtCB9cNBwCqHh9J8DsaIKkEyYXB9AzXLZgdQz1JVM/3VnWezKE8UvMN5lFZcqfO/7Q5q6LhsouvBcIC6g8vL3ngN5bvVGd1aCNdxqYosUIJ9g7q9a+sSWXa1doXssTXsvSITUAmi9+1+O1zsB84sD13W3Mi5tFeUc2S5Uv6Paz8jOGPicFGXv6o4B8EOYZknJAiEAEtJyYP1c1NHJhkaQPHEvwBam/Kt9TdfVvAH65U98VbKkUOYMAZ9yIpTU556NoeT1yTV8v5NOJzLoCqGGeyeOn5NzF2yYBGy1B5wZMgbrW/icv0sG1JcyxNQkWryYCcJfDp4WG/qjXIVzsWbHanRbOTE+IQ+DmftDCK5BbOh54KZkcBTL3a1Wi+fbcUSN3Llzz+xBxso8PF0K/1OIgpkmWuKk+XJu0M3Jo9OgMaEE/ZIEAjRKqXfLK1TSdoc2z6hrJss4CouDS46fmkhzWOU45xRtIBOLR8sKNbH4/z10Np0ZlF//SojRX26Mm7LwRc5tUjMxsn4Z0DOHyho38s/Yfrr8c9AJ+bfysFX4l/1ZPyrno5/wnRB/hVU2OqpubJy8EW4kqkRB96xa7BVabH/MkgcubbOXKJB3tmo74NeO3IpyMieJQggf3ixsxd2jpNiCnvnYuUzZlD0Fi5Fnl6of0bIcRXr22dJ1ZKXK+rqH87ocOKFm8Qj1/Jv09wwsWFkj2+q4SD09DswxfIPRfzexPy6Uf7wCAv6wlfwm6sHvJ/QGSXkF+dkGV/xWP5HCfPhq/szo2b1DKtXappNXDIb96TUMTpmyex1mmdm367qDfPn+scN2Hzxs4lcv27Qm5Wm+jXHxfkSm619vxQRfAZc6l2irOwbdvE/UEsDBBQAAAAIACSmp1yZesyPDgIAAP4IAAAkAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1szVZNj9sgEL33VyDutcEfib2Ks4eueq6q9gcgTNaoNliAo+y/75jUwXayUtWNqhysMH4wMH5veNk9n7oWHYWxUqsK04hgJBTXtVSvFf754+vnAiPrmKpZq5Wo8Juw+HmPPu16edTuC+ON+C64NrVFkEnZCjfO9U9xbAHpmI10LxQgB2065iA0r7HtjWC1bYRwXRsnhGzijkmFzxmezN/k0IeD5OJF86ETyp2TGNEyB3XYRvYWI64H5Sqc4f3O7HcndKwwwfH/HnWw4/jc2n/C7Hi2by1TDhlRD3wsAkmFjqwdBKrhcRqJkzMMPrRUzLyhwYqxlikDzAX2KCG+whtRSaPNNmCkJEWUprMX+RZmXOI03UTbAC9XB3Da/iO/58PCyensNH8KWZSXZDRJruf49SuMppRk49QYmH8U8n19XgZ+dGfy03xO/jJKVvxl2yX7QCjwXc6+LYghC/Sv1lNygT9C/FK79xdA/mgC8OL1AvCjOwuAjgKYtf8qTPIZlhXbRZjRvIhoaP8sB8UUvoPO7TlfPQMfmX5fzb/0/6pP3zWOMC/Yyurd4vL3/eSz+dGC/hcx3vXevZA+oEYPFhwYnFfzX5MB8MEY8DoEdqt0JzkYnKqlN7wrKyhHLQTCV+EolQu3RVkswoLMQ1qsRRVEMUF3VYE/2MrW4DYP3nVtA8E4btiAXzjKIL76x7L/DVBLAwQUAAAACAAkpqdcCkEM6r0AAABHAQAAKQAAAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzhY/BCsIwDIbvgu9QcrfdPIjIOg+K4FX0AUKXbcUtLW0VfXvrbQPBY8if789X7V/jIJ4UonWsoZQFCGLjGsudhtv1tNqCiAm5wcExaXhThH29XFQXGjDlo9hbH0WmcNTQp+R3SkXT04hROk+cN60LI6Y8hk55NHfsSK2LYqPClAH1jCnOjYZwbkoQ17fPzf/Zrm2toaMzj5E4/ahQ3j5dOmB+70itZfsVyHwMHSUNUk4CP7OlzDqg6krN9OsPUEsDBBQAAAAIACSmp1y4XH/ynwcAANxNAAAeAAAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1s7Vxtb9s4DP5+wP0Hw989x6nzViQZsqTZCvS2ou12uI+urSS62ZZhK22Kw/33Iym/Jm2XbL0NaDRgrk1JNElRlKyIz/DtJgqNO5ZmXMQj03nTMg0W+yLg8XJkfr6ZW33TyKQXB14oYjYyH1hmvh3//tsw4XdC3ni3IZuxBY+5BAYGMIuzkbmSMjm17cxfscjL3oiExVCyEGnkSXhMl3aWpMwLshVjMgrtdqvVtSOPx6bicBr5+zCJvPTrOrF8ESWe5Lc85PKBeJlG5J+eL2ORonwjc5MWjDfpDuOI+6nIxEK+AUa2WCy4z3bkc1w7ZXccrQSs0tM1D0bmP638nwV/e3hpWS0HL7V//5pG7EUgxGVpMMc0fA9scw48+gPT8JIkfPi4jm5ZOlc2GpnQD0R+J9LgEfJcxHKn7qUnJUvjHfok5Ms4Yo+0+JMHcvWB8eWq4gbSBZ70pl6CXToyv3jhGjrdWCdAZsGXwlfAMSIeX7FFyrIV2rksOYHKGZuspVCiSHIm1FqE71PwpRshvVApySWLLlMeyxsuQwY0rAa+UX8T9CePA5CfWlB3+437GchLZdE6lDwJ2ZyzMJjzEMxBrxkPQ+GDj4CLpmwxMifd0y8OiLngaSY/gCey9ErcEwsiIUMigDQlYSpCIECVVNxfeks2FWsUySW9agTHtMdqeJAYGRRTxY4LclR0w9twEA6v2LipmFjLkON4qyl1Dqa6ZiHzUY9JGIp7Bg4EEmYrcQ/PVDlgCw+McL2+lWhkpTwauRTDyQnGBgtBVJuKx0O2kReZpL/GOuXg3+2B2z2b9bvWxOl1LPek7Vn9ydSxuu5Za9pxu7Pe7Az8W43ZjeN+39hqDeyBGv3jITA5rZlowcNwJu7jC++WocOQaW0QUF1JXLuqr837SOjS5tXeq4NDGDSCg5qSp162Mt6zmKUwN8RL4zMsY+gCk28ZnGEeeDo210NvJlJ585AAXy/zWYxLqO3Ye7IdezH0YiCmwEYPMFHkMfwVx+ZnzD9jmZ9yWnu8WC/sMSu2n+2ZVzpFqm44h/UUT3F9aMC6BxYiz/h+vI7mkcSFq9OFhU99mfKtobBHJxzL0mTH7pcs5SL4mf5+LKZ+oTi+h/MefQRhKoT8mvit/fmlg3Hdn6vlydF8NP7Qsm+PcHEsDlvfrnlqufDopsUr247APTXaD8p3wqpNrGO2ys+bnnHzrfjaom2v3U8viG3tesnJq/8Cm2QZ+2VTdr1Hdu3+dF+90o8xHSgpPDb29485NGp/UP6gJ878h6TGBqa2irbKvr+EaV/RvqJ95Ud+S9YjSI8gPYL0CHrpMyo6rjwWV/SXj/4Srh+U0/6g/UH7A/lAYw9Ajws9LvS40OPiqRPQOj7o+KDjg44POj48nymi46SOkzpO6jip46SOk/tkFur5Qs8Xer7Q80Vjvqg9QC41pIg3k78hb3w8XNCBJjhm6uLJ0vKp03hymoVOs7TbqNtrPPUbT4MmVzrzWr7SUZnUpZgkMSaYl2niPTwvCwnZUK38b9zlJ2QbVKyBJcQSS2xoxw1AWsAUgloRVqIztYc2p9OhO42eeG8tgbImzo4gStpKpIYG9K5dSqlb8x1lRaU4FC4R5QCVz1ugocm64yFgBWx5Rt0xLFLVLitR/Ua/OJSXUTc0ZOpjMkElrxIDyKX9FdeCjFmoleYlGc/jEpkcsCR3CjI5YknuFmTyyJKMbkNMyDVLcr8gk4+W5EFBJmctyTRYlD45QkGuELhtUaAcGFRCY+W2TQBHoWlcglwoqMYCT98DSMKKM/BOSwE1NEsBTuGZ0vazpQAoUW9rV+KMh+UvvRUOA/ZOSc5BQoyPcB4bQB4A/GFpAC6GD+mYJLUDOCG3XqbUIyXwCfXOURx2OBFuh3EeG5+zgkk7b7Y/k/dCBPcAwmBMIgSxKIQBTQ8TZiqyonEbTPx0Y6PKMHWp73f0mgR/rzOABzHqPKFjDhNoxpI0bmrVPlgr7Kx3Qnw1yNa5cdqQF3uYLB/ZPfX7LqvOoayMWjJvo8vaAKJymFR/yQCS+cBKhV697+FQyVOwAdyYwwS5YndeaFyxjKV3zIDu3+q2b40Muxp7MAMqgJ0CkwXHoCIZwWZBec0FSMsEUGjo8PGnOHygEVc/jU4z6aXICPdIoawAsgxLATyJNaBWSioAydDQdQFVZdDtwRVhBQgZpgyDanYsYzDdUdilO4q0VXClO4qndEchtBY01W0+zxei4Zxfillgp6CmcK/ssG0P1IwQVnbtESIqi7IOjOkjsU5uJpjJKwSsa/kQsvN4IepQT0T8gwV8HYGHYnY8pBQqrCEFc4QkwBTaJkGtawkICAiGBE6X19omXXiZhMbrCFG7sOd30+UG3fbZvDNzrM500rZcf3Bi9c/mrjV7N+9MWx33ZDBr/0/oPdu4YM2TYwAYhhhFZIQVD5hCmCrwlnI0IZjXtmDEHgXqYhuf1QHEcFFA+EAVilHP7U26AFdgOf3OxHJbsymgGE061rzldJx2x2nNOm5lhyQA0KR93rwNYeZ01SdAnswYeg8wInC5AhwVptGWVZyucRYjcFZQoDVlpWWg40vip/hGJLWSUsUtCKQt9uP/AFBLAwQUAAAACAAkpqdc9St8MzQAAADcAAAAJwAAAHhsL3ByaW50ZXJTZXR0aW5ncy9wcmludGVyU2V0dGluZ3MxLmJpbmNgoAwwsjCy3wEawT+bkYmRgZNhFrcJRwoDIwM7QwQTE5COAIoyMDgymFBmDV7dIBuwAQBQSwMEFAAAAAgAJKanXGfvGlXMAwAAOwwAAA0AAAB4bC9zdHlsZXMueG1svVZbb9s2FH4fsP9AMK+TdYnl2o7lorYjoEBXDEsGDJiHgZYomygvBkWn8ob99x1Ssi2lTZy4xV4k8vDwO/dzOHlbCY4eqC6ZkgkOewFGVGYqZ3Kd4N/uU2+IUWmIzAlXkiZ4T0v8dvrjD5PS7Dm921BqEEDIMsEbY7Zj3y+zDRWk7KktlXBSKC2Iga1e++VWU5KX9pLgfhQEA18QJnGNMBbZS0AE0Z92Wy9TYksMWzHOzN5hYSSy8fu1VJqsOKhahX2SoSoc6AhV+iDEUb+QI1imVakK0wNcXxUFy+iX6o78kU+yExIgX4YUxn4QdWyv9IVIfV/TB2bDh6cTuROpMCXK1E6aBF8fSag+eZ9DjAd9jOqozFUOfsrzZU+IZW+/x/4BosMfP8W/RJvNWIhxWT5xE2LSlnT109VV0AuCv9DNH7/S/M+ld6AskUXwG/2nk0LJthkQRYja+JNUn2Vqj8AMsM1yTSfl3+iBcKAEFiNTXGlkIAfBtNDpRQStOeaEs5VmllgQwfi+JkeW4NK24RMMksgpVEuovyvL9T/JekaOs/LbbXKmlWAb47yTMJYwnUBtGaplChvUrO/3W3CphDZQu8bxneFea7IPo/jlF0rFWW5Du567QOr1KsFpevvuNk0dzKo5YDKnFYV8hnS26rQUPirndAQbV0rn0OIOZWFTpyZNJ5wWBq5rtt7Yv1FbK0MZA21gOskZWStJuBVwuNEsADajnN/ZNvh70cGuilb5QEO1nraVZ5egULOs8eqNxW+j1dht2AB0fj0uqoqjgKduhyetIozaWh1vI7Ld8r0tPFtSzQ4saQqsg9y0l3MWP8L+uBMrqlPXlb6O6prQd0Z9UWwu8sIrkbfsQZnZDrLODmGbDt8Q6zo+5z3qmvN39mg4aKFCOj2R72ei3823x97oyHhx9j72x5mcduUIBdiq8k6NH6sV2Vac4I82dTk8DZqCQ6sd44bJr9Q3YObVqWPYIQ37w5TpzK+6M9Tjx3dM7lOPyc6Mfu2kfRbsTXds39zcOD3cHfsFC4x9Y7nmd3QL5HxOC7Lj5v54mODT+meas52ApGi4frFJ7yASfFrXXCMrkFbmQwmWwx/tNEvwP7ezN6PFbRp5w2A29PrXNPZG8Wzhxf35bLFIR0EUzP9tvfQue1MF9p3nHqZQh2F/XHJ4DerG2Eb5uxMtwa3NBztIXAX7oHZb91E0CN7FYeCl10Ho9Qdk6A0H17GXxmG0GPRnt3Eat3SPL9M9DPwwPCkfjw0TlDN5iNUhQm0qBAm2zxhhTXGR8E+v/ul/UEsDBBQAAAAIACSmp1y9oL+9HAcAAB0iAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbO1aS28bNxC+F+h/IPaeWLIlxzIiB5YsxUn8gq2kyJFaUbu0uMsFSdnRrUiOBQoUTYteCvTWQ9E2QAL0kv4atynaFMhf6JCrBylRsZwH+rIDxEvuN8PhvDg79PUbDxKGToiQlKfVoHi1ECCShrxD06ga3G01r6wFSCqcdjDjKakGAyKDGxsffnAdr6uYJAQBfSrXcTWIlcrWl5ZkCNNYXuUZSeFdl4sEKxiKaKkj8CnwTdjScqGwupRgmgYoxQmw3e92aUhQS7MMNkbMGwyGqZJ6ImTiSLMmDoXBdnpF/UsOZJ0JdIJZNYB1Ovy0RR6oADEsFbyoBgXzEyxtXF8aEzE1h9aia5qfId2QoNNbNmuKqD1etNgsVa5tjfkbAFOzuEajUW8Ux/wMAIch7DSXxeZZaq4VayOeFih/nOVdL5QLJRdv8V+Z4V+p1WrlylCWnKkB5Y+lGfxaYbW0uezgDSjHl2flr23W66sO3oBy/OoMvnmtslpy8QYUM5r2ZtDanmPLjCFdzra98DWAr40cYIICbxh7l16iy1M1z9cSfMxFEwDGuFjRFKlBRro4BC+u46QtKA5QhlMuYaKwXGgWVuB//a9knkpaF3idYIsunwrlzJSWBMlQ0ExVg9vANbAgr55//+r5U/Tq+ZOzh8/OHv509ujR2cMfc14O4TZOI5vw5bef/fn1x+iPp9+8fPyFHy9t/K8/fPLLz5/7gRBfk/2/+PLJb8+evPjq09+/e+yBbwrctuEtmhCJ9sgpOuQJ7M0jOWmLi1G0YkwdChwDbw/rhood4N4AMx+uRlzl3ROQWnzAm/1jR9ajWPQV9ax8J04c4C7nrMaFVwF39FqWhlv9NPIvLvo27hDjE9/adZw6pm30M8ip4LKzuq/HxBHzgOFU4YikRCH9jvcI8ZDdp9TR6y4NBZe8q9B9imqYelXSom3HkSZE2zQBuwx8AoKpHd3s3kM1zny73iInLhICAjOP8C3CHDXexH2FEx/LFk6YrfAdrGKfkEcDEdq4hlRg6YgwjhodIqWPZl/Afi2j38GQzbxm32WDxEUKRXs+njuYcxu5xXv1GCeZV2aaxjb2luyBi2J0wJUPvsvdCNFjsANO55r7HiWOuc9PBHdp5Ig0cRD9pi88trxJuBuPA9bFxJdlNkXiJNZNyOE+76j1I8e1dwhh+BR3CEF3b3kkqPHM0flE6NsxZJVt4nOs29j1VT1OiYTaSBczs2G6Q6Xjskck4nPk2R1MJZ4BThMs5nHeA6s7rgtnmzeV7rOwZwP3KNR84C9epexL4GE5d2Me14MYO6eWHku/vw6EY79FYgzi8viicQk05MI0kNgX1k0LM2eBicO0MEU7vnQLJI75JyT6XDVkfS9d1w3aiRmgGnKKnISmr6t4GAUDTlU85cuKJy/ZpiueeZlle6rOmYf7F1Y3W7ifHhA4UGZT12Vxc1ncBP/54mZeLF+WNJclzWVJ4/sIey8lzaSKgQJn0uExzZJkbrunSxk7UgNGdqTp+Ej4sOk0YdIMTD9y3P7LYngcdrocXCSwoUGCq4+oio9inEFzqGial5Ecso4kyriEnpGZ9vI2jVEKLSHT4yyPupmAxmqXd/LpFbvLOWZjep6R6aSOFlrRDBZdbOXasHX6hosVc6kW3FrRiGYqBmdr4y3DZma3ZnY41CZ8MSP4zgYtr0KzWXODPhqU1x2t97wDPDKL0cm7NJGM4ZtwaCO979mNFI2RRr4yciOPjXTH8hytWatVNNu3WG0RI9nLleYsN7Le21hppJ2JlXTcToUjS+3gZCk6rQaV8nI5QCHOqkEXGrTwmGRgdam/dzCL4JYjVCJ3xHOD2aAm1qz43bIIPfc51nSWyIRUW1jGuWuYV6NLgNS0k438y2VQ67vaQO7pbyDFyho4w98mBcjsmpZ0uyRUtrGtGdNPN4Bh8PO+IuIo7pyiNuuLQwzm164K++lQCZ9lJiPoAVwKaW2bkZuch0FnX8UYXD6PWRbjYbrVITqK5BxudD6WwYws8cYjs5uJ7FPDRbdiQv4dbcV24//ZVvR5Aq3tlY65iYE7SYGRjtdqwIWKOWShLKZhU8CFjPEA8Ba4WITXoHy4GTW/BTnRv/OYy3mYsIYOpTqkERIUziMVC0IOIC0Z7zuHWXF4duUsR4zymJ6IK7Nc7DY5Iaylc8iqPtsDFI+yyTANGNy0/7njodu1I12w/FMrnzyYL1oeTCqfnH7BWqRkJX3rKKi8nQgXPGrzjDWz4+XywkdtBhcUcC+pwCdCKkJoNJrSF6zc4oeQOtG4okTg1VfywgPpBJk/taFwyidzZ9Ks3m8ZNal0x+u+x+LTOubHxZm7nBOLr68+L6bsoYYdXduVrkfVYIDpENXl0ehDxhjG/H2G/ScUvH0Mht6Cy+o+UzK/hn4A11FwZOXX3RD8uXEN6cZfUEsDBBQAAAAIACSmp1zdVkVo5gIAAJAGAAAPAAAAeGwvd29ya2Jvb2sueG1spVVRb9owEH6ftP/gWUh9CknchIYIqEIzNKRuQmvXPiKTGGI1iSPbQFDV/75zaCiUPVRdBA53Z3/+7vP5GFzXRY42TCouyiF2uw5GrExEysvVEP+5n1gBRkrTMqW5KNkQ75jC16OvXwZbIZ8WQjwhACjVEGdaV6FtqyRjBVVdUbESIkshC6rBlCtbVZLRVGWM6SK3ieP07ILyEu8RQvkRDLFc8oTFIlkXrNR7EMlyqoG+ynilWrQi+QhcQeXTurISUVQAseA517sGFKMiCaerUki6yCHt2vVRLeHTg6/rwEDanSB0tlXBEymUWOouQNt70mf5u47tuicS1OcafAzJAxE23JzhgZXsfZKVEXSPBSrsj8ak/N9oLpRWC0c+ieYfuBE8Gix5zh72pYtoVf2ihTmpHKOcKv095ZqlQ3wFptiyE4dcV+M1zyFKfEJ8bI8O5TyTCGA1kzPJNzTZwZ3AKOMpm/GN0BPO8vSWK924U7ak61zfQ8W3PMBPPEJ6BrKWYavkTEsEv6fxLTC7oxvgCWqkr2U8BSLu5bxMZOjOn/1ofBX0A9+Ko5ux5UWea/XjmFhe7MdXThR5wWTyAlLKXpgIutbZqwQGeog9yPcs9JPWbcR1wjVP32g8O6+PZd7vhjb2YtIxl/2Bs616E8uYqH7kZSq2oGXQCyCrXWtbLgFz20QfeaozmNJ3vIPvB+OrzCjpB8ZJE8037J4uGm3hghmiQ3xCMN4TnMDTDCcE7SOGTZcBps0blU1lTCIUKQXmFG47l6aBQG8zE5oDwEiGZkM5TV2T7/HS5vCt96vRb1YJeQwCTeEAQs5AqAQeUFrQpA7bXh6tuDQr7JY6VBcvWWqqGhI5sl7Tmdd5WXTnk6ZaY6rpgipmij2h+V2bFegKxZsy09vx6OIfElx860QdN+yMxx13YB9tA1ROKQBuAtfDvBrBCCFuo1Rl1Lmh0PmB6JsBM8Flpgb9oyy9JsuTNXb7ZzL6C1BLAwQUAAAACAAkpqdcN4tbidgAAADZAQAAIwAAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQyLnhtbC5yZWxzrZHBasMwDIbvg76D0b120sMYo04vY9Drmj2A6yiJaSIbSyvt28+7lKUUdtlN0o8+/ZK2u8s8qTNmDpEs1LoCheRjF2iw8Nm+r19AsTjq3BQJLVyRYdesnrYfODkpTTyGxKpQiC2MIunVGPYjzo51TEhF6WOenZQ0DyY5f3IDmk1VPZv8mwHNgqn2nYW87zag2msqk/9mx74PHt+i/5qR5MEIk3IgwXxAkbIgF7TLA4oFre+1+7zWx0BgHpus/9VkOEdp3XHCpb9bmU26xbUuB/6xZRYPab4BUEsDBBQAAAAIACSmp1w4IQo5ogQAAJoUAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1srZjbbuM2EIbvC/QdBF30LpKpQ3yo7UU2gbEBWmDR9HDNyLRNRBJVkU7iFH33zkgaUYukgGjvImuOJfPncPgNJc7y02uRe8+i1lKVK58FE98TZaa2styv/D9+31zNfE8bXm55rkqx8k9C+5/WP/6wfFH1kz4IYTxQKPXKPxhTLcJQZwdRcB2oSpRwZ6fqghv4Wu9DXdWCb5tORR5Gk8l1WHBZ+q3Coh6joXY7mYk7lR0LUZpWpBY5N+C/PshKk1qRjZEreP10rK4yVVQg8ShzaU6NqO8V2eJ+X6qaP+Yw71eW8Mx7reEvgv8xDdNcfzdSIbNaabUzASiHrc/vpz8P5yHPeqX38x8lwxIIwLPEBbRS0XkusbTXiqxYfKYYrkzrGIarXhzlduX/M+n+XUHL8GNiP+jev/56uZWwwtjZq8Vu5d+wxefPqR+ulw1Af0rxoge2hzw+KvWEN+5hnAlIVLwU3umhglUFtn3PqOoXsTO3Is9BEGbIMyOfxVf42cp/VMaoAu83xBu4tKvVmyibMUUu4LfgDGp+++NWxIrqv1uHI+wY9t4ObfJ802TH19rbih0/5uZW5X/JrTmAt5CI3cXf1MsXIfcHnEMUTFOIJUK32J7uhM4gC2CyQTNYpnJQhk+vkJjNADF/bdqXThW4fhTabLqAZEcNc6YhO4m2M0Sn6Qxt1zka3xnWu+kMLY08D2ZpmlzP0P+RLiSdCrSkkgRTNpnHDiIwXOMKtNaVaJay9Doa7wruB6gCLUUjDtLpJGYOItNOBFoSYe5RgQ25cQVa6wpLJi7TmXca0JIG8DZyWRDNliswKKZT94mwnk8LaDR1XmBGpKJB7oxfWUasomEJSaJ0OnNZXEa0omGjQgujzQkfI7D0Y6NM4LIBuUng7hehywbspmesFtHLLL5s5r5ahC+z/IKMc0IyQhiNLtxp5B6eiGBGo98lg7OXLSKo0SC9+AK9fh8e0A3bfb+BOYMVEfBo2H31EkVCPxqgn14wZ0If99Y+oy1q7lOmHMBH2EcPJHdFyoZokA3zS1ykvIgGecEuWmfKkMhmCBsmvvOkY8oVNOi5kdjHoLsgJUs8SJYz9qaYkgQNWl8wR261cf+6MsiI2H2LjCkP0LCYub4mxIQ/GiQzc9/aYqIejY903NeLqI8H1DvEmRiPB4yfE2ciOx6QPXd+HUsIZzQuiHNCFKPxXeKcEM9ouPOcEM9o2GeQ+/t3/wJ+Ec8J8YzGJXEmnpPvxXNCPKNhH4WuCZsQ12jYeLueVBLCGg3aXiP3bSglrtGwj0/HI0JKVKPRHxLO8IZYTocsn6FDUKcDqO1LxsitPiWk0ehmNR+9tYbtAbs50t9xw+lI39r8aNRG5kbUg4oFBO/Dysf8fysfcI6v+F78yuu9LLWXQ0ECD/hAaN0WARobShmNhQedpnBB3w5QYhNQSpoEEKedUuBO+6XTfRDmWEEVoxL1g3yDIwnApmoJZYSmhrbycyj26Qzu+94BbrwpuJPfVRJLKlgpNDLrv4NmO96mGWi9VNvtl+bC+ideVD/fbm68G62hSHgPBTZZY81uGdofLcNvu4d9VXH9H1BLAwQUAAAACAAkpqdci1J/0HQHAAAsIAAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbKVZ23LaSBB936r9B5Wedh8sNLqAoMCpxNhrh0AwGPZZFsKoLBCRhC/Z2n/f7tF1WgoIrytBYvrM6Z7uMzNC0//0tvWlFzeMvGA3kJmiypK7c4KVt3sayIuHmwtLlqLY3q1sP9i5A/ndjeRPl7//1n8Nwudo47qxBAy7aCBv4njfa7UiZ+Nu7UgJ9u4OLOsg3NoxfA2fWtE+dO0V77T1W5qqtltb29vJCUMvbMIRrNee4w4D57B1d3FCErq+HUP80cbbRxnb1mlCt7XD58P+wgm2e6B49HwvfueksrR1endPuyC0H30Y9xszbEd6C+GfBv/1zA1vr3jaek4YRME6VoC5lcRcHX631W3ZTs5UHX8jGmZAAl48LGBBpX0sJGbmXFpBpn+QDCuTBIbpCnsHbzWQ/1HTvwu4MvxQL1SGH6W/f+XL/sqDCmNnKXTXA/kz6y2ZLrcu+1xAS899jUr3Umw/zl3fdWIXnDBZQn0+BsEzAu+gSQXKvb1zpff5Hqo8kKHEcbD/5q7jK9f3wUFHlmwn9l7cKcAG8mMQx8EW7XwGxNC0DoOf7o7HwF1hcMgpghOSgjT6kQyggx1befTl+2wkN3y2TENp5a7tgx9fBf7f3irewIiYYmhmx2KaKWfWWfB663pPGxgM05QOGLgae6v3oRs5MD1g1IqGXp3ABxfwKW09nOagbvstSVNKbykdpnZ1JHl0o/gGMwRm5xBBErIYUqqEBATCSeCakmiWwgy1jRE25ABdcA64ZoEYimaZzDyHxUhZ4JpF0jl7OBA0DwWuGUk55Q0HhOsGssA1Y9EUyzSNtnVGakGJnAWuRSxns8DKzVng+j9i6aYscM1Yumcnl8G2kigObopKmx1V54JumF2WC7ek3A8IhmXaxZssHKBsGkYmW1iP8u7m+bplmXDxJg/j/ORm0mWFdmE9OHsasUy8eJOFo3+AJ5MvK/TL9POHlemXFQLG26ZFyoTLCuUy6/zRaJl08SbNSre0FjcMR8ukizf5DGg8Gi1fbUvLraY0nECtZP3nW8/Qju3Lfhi8SvC8AbFEsIHB0xvroYva/QM2DsR+RjBfH2FriGA3fblU+60X2MacFPEFELmN5bYWOMs9gpPmHhEsetSIR0DkHvV6jzBHm3tEsOjRIB4BkXs06z3CbG7uEcGixzbxCIjcY6feI0zY5h4RLHq0iMcqoisirqoIRsQwrIEUmuCKuq6BkALf1ECKOnOWv2ogpGi3NZCidpzlrgZCCvG1BlLUg7OM8KEymx2MpPWbYCQZHZeNGsnlJPEMi19OrpFcfq+BkFxOayAkl/c1EJLLWQ2E5HJeAyG5fKiBkFwuaiAko8saSJFXYd2Braj5DAFwsarQRU4wkipcCUaS/6FgJJm/xgDxYRrXVUPV6HS6ETqTmvwlGEk1bgUjqcOdYCQV+Hqs5ygJuM1/E6D2v9GGMW2YJA0dPkYGv/lIar+fsE/L9i5T2iTee6G/2lUtRSdpnokQswMs4tI2LyN0va10CMXDiSgWpwiWGQB/Dpb3RnzV0ng3Li8GOtWoYKQaFYxkRg0FI1mjrjHAYxoVOlONCkaqUcFINSoYqUaP9RwlAZc0ShvGtGGSNCQa1c2qRk/Yp2W7VidSgcDo1IlUgOhtECGpxLyMYCqo2KAqPRXH4iTFMkNQncIDdXOdAvjXa6lgpDotGw36dCEY6XMFBnhMp4JbqlPBSHUqGKlOBSPV6bGeoyTgkk5pw5g2TJKGdC1FndLF9BRgKgA0k/S/F8wGvL4ggJkIMJgJr3/oYlrGGCZMB4uk++F4FIuTBMsMQVWKrxqayxTRuU4NsnOPOJdQoErLuNIySVvSGnXb1RqdRExFRFvXFd0oXpQS4d8TPkNvt5U2qclMBFlWHWgugKqRP5wV1+IE2zK3V4p43i/U8g9QuiJ+wbdHRYmJDq9EK5n3Q9FKMnqN1qMLjtBdpyuOSE4WjluxL11zxL5kN/96tO8oDbu07FRaxpWWSdqSqLrLtSg+QX0/iZgKCAarl8hwL9itrlVBzESEpVYQc9GHVQnz4UQQi1MEyxxQUe1ZbznwJWShS7LTj9BKlh7aMq5gJmnLsSIlLL9GTAWOuiKVGeqLJCBqi1RGsLoiCYBKlRdikFWCZQ6oFOmsF0P4qrd470P0OkIrKRJtGVcwk7Ql3R/U2g0ioTkCmQosOuM7BJ1OhEWzcF8wu+mfiJ6RsNrWMfRcQGu4N4l0D6fjW5ziwIO/JA15EZNztORlphPsVh4extl+coAWw+m1lB27teHckK9SsGA569nBd6X4fQ9ndg4c+93BefHqbY0HhCC0fegFIZwA8xejcIAd2nEAv2zdHwfbh954ln3w7Uv5j0ff3j3/KfdbWRO8BOXU+Da0Lho8e3xyx3b45O0iyYdDRTybgx+CYXJ+x+/hOJLf4YEIP3zMvm3g2NyFQFQF8rAOgjj7AulA3rkbH/ZwEgkRz72fMDR4JoKBwAkgPxcfyPsgjEPbg5PMDbT/DMDgD/cenori4X/sOcX3sIfHtOHdip8ctvJz/sv/AFBLAQIUABQAAAAIACSmp1y+0BxCqwEAAOEHAAATAAAAAAAAAAAAIAC2gQAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAhQAFAAAAAgAJKanXLVVMCPuAAAATAIAAAsAAAAAAAAAAAAgALaB3AEAAF9yZWxzLy5yZWxzUEsBAhQAFAAAAAgAJKanXLtzkmOkAQAAdAMAABAAAAAAAAAAAAAgALaB8wIAAGRvY1Byb3BzL2FwcC54bWxQSwECFAAUAAAACAAkpqdcQQH0VjYBAABRAgAAEQAAAAAAAAAAACAAtoHFBAAAZG9jUHJvcHMvY29yZS54bWxQSwECFAAUAAAACAAkpqdcTUHW0hoBAAB7BAAAGgAAAAAAAAAAACAAtoEqBgAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAAUAAAACAAkpqdc4it/e7sAAAAzAQAAMgAAAAAAAAAAACAAtoF8BwAAeGwvcGl2b3RDYWNoZS9fcmVscy9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sLnJlbHNQSwECFAAUAAAACAAkpqdcKY7nygcGAACgIgAAJwAAAAAAAAAAACAAtoGHCAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sUEsBAhQAFAAAAAgAJKanXJl6zI8OAgAA/ggAACQAAAAAAAAAAAAgALaB0w4AAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZVJlY29yZHMxLnhtbFBLAQIUABQAAAAIACSmp1wKQQzqvQAAAEcBAAApAAAAAAAAAAAAIAC2gSMRAAB4bC9waXZvdFRhYmxlcy9fcmVscy9waXZvdFRhYmxlMS54bWwucmVsc1BLAQIUABQAAAAIACSmp1y4XH/ynwcAANxNAAAeAAAAAAAAAAAAIAC2gScSAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWxQSwECFAAUAAAACAAkpqdc9St8MzQAAADcAAAAJwAAAAAAAAAAACAAtoECGgAAeGwvcHJpbnRlclNldHRpbmdzL3ByaW50ZXJTZXR0aW5nczEuYmluUEsBAhQAFAAAAAgAJKanXGfvGlXMAwAAOwwAAA0AAAAAAAAAAAAgALaBexoAAHhsL3N0eWxlcy54bWxQSwECFAAUAAAACAAkpqdcvaC/vRwHAAAdIgAAEwAAAAAAAAAAACAAtoFyHgAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLAQIUABQAAAAIACSmp1zdVkVo5gIAAJAGAAAPAAAAAAAAAAAAIAC2gb8lAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAACAAkpqdcN4tbidgAAADZAQAAIwAAAAAAAAAAACAAtoHSKAAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHNQSwECFAAUAAAACAAkpqdcOCEKOaIEAACaFAAAGAAAAAAAAAAAACAAtoHrKQAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAhQAFAAAAAgAJKanXItSf9B0BwAALCAAABgAAAAAAAAAAAAgALaBwy4AAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbFBLBQYAAAAAEQARANQEAABtNgAAAAA= xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 Book Type Code 1 OPS CORP 2 Book Type Name 3 OPERATIONS CORPORATE BOOK 4 Ledger 5 Vision Operations (USA) 6 Currency Code 7 USD 8 Cash Generating Unit Unit 9 Cash Generating Unit Description 10 Asset Number 11 Asset Description 12 Impairment Date 13 Impairment Period 14 Impairement Name 15 Impairement Description 16 Impairment Class 17 Goodwill Asset 18 Net Selling Price 19 Value In Use 20 Goodwill Amount 21 Cost 22 Adjusted Cost 23 Deprn Amount 24 Net Book Value 25 New Net Book Value 26 Impairment Amount 27 Ytd Deprn 28 Ytd Impairment 29 Reval Reserve Adj Amount 30 CGU001 31 Cash Generating Unit 001 32 IMP0001 33 JCB 801.4 MINI DIGGER 34 Feb-10 35 CGU001 - Feb-2010 36 (blank) 37 Consumption of Economic Benefit 38 IMP0002 39 KABOTA 161-3 A - MINI DIGGER 40 IMP0003 41 DEMAG AC35L CRANE 42 CGU001 Total 43 CGU002 44 Cash Generating Unit 002 45 IMP0004 46 Housing Stock Ref CGU002 47 Housing Stock Feb-2010 48 Change in Property Prices 49 CGU002 Total 50 Grand Total data A1 1 data AA 7 data AA1 9 data AB 7 data AB1 9 data AC 7 data AC1 9 data AD1 9 data AE1 1 data AF1 1 data AG1 1 data AH1 1 data AI1 1 data AJ1 9 data AK1 1 data AL1 1 data AM1 1 data AN1 1 data AO1 9 data AP1 1 data AQ1 1 data AR1 1 data AS1 1 data AT1 9 data AU1 1 data AV1 1 data AW1 1 data AX1 1 data AY1 1 data AZ1 1 data B1 1 data BA1 1 data BB1 1 data C1 1 data D1 1 data E1 1 data F1 1 data G 2 data G1 1 data H1 1 data I1 1 data J1 1 data K1 1 data L1 1 data M1 1 data N1 9 data O1 1 data P1 1 data Q1 1 data R1 1 data S1 1 data T1 9 data U1 9 data V 7 data V1 9 data W 7 data W1 9 data X 7 data X1 9 data Y 7 data Y1 9 data Z 7 data Z1 9 parameter A1 1 parameter A10 1 parameter A11 1 parameter A12 1 parameter A13 1 parameter A14 1 parameter A15 1 parameter A2 1 parameter A3 1 parameter A4 1 parameter A5 1 parameter A6 1 parameter A7 1 parameter A8 1 parameter B1 4 parameter B10 4 parameter B11 4 parameter B12 4 parameter B13 4 parameter B14 4 parameter B15 4 parameter B2 4 parameter B3 3 parameter B4 4 parameter B5 4 parameter B6 4 parameter B7 4 parameter B8 4 S Site Impairment Transactions Y Reports the Impairment Transactions loaded into Assets SYSADMIN 45 ADJUSTED_COST 39 ASSET_CASH_GEN_UNIT 40 ASSET_CASH_GEN_UNIT_DESC 42 ASSET_IMPAIRMENT_DATE 41 ASSET_IMPAIRMENT_PERIOD 43 ASSET_LOSS_ACCOUNT 1 BOOK_TYPE_CODE 1 2 BOOK_TYPE_NAME 4 CURRENCY_CODE 46 DEPRN_AMOUNT 15 GOODWILL_AMOUNT 13 GOODWILL_ASSET 14 GOODWILL_ASSET_DESC 10 IMPAIREMENT_DESC 9 IMPAIREMENT_NAME 4 49 IMPAIRMENT_ID 44 IMPAIRMENT_REASON 16 IMPAIR_ASSET 17 IMPAIR_ASSET_DESC 51 IMPAIR_ASSET_ID 7 IMPAIR_CASH_GEN_UNIT 3 8 IMPAIR_CASH_GEN_UNIT_DESC 11 IMPAIR_CLASS 6 IMPAIR_DATE 2 24 IMPAIR_DATE_INEFFECTIVE 50 IMPAIR_GOODWILL_ASSET_ID 22 IMPAIR_IMPAIRMENT_AMOUNT 18 IMPAIR_LOSS_ACCOUNT 19 IMPAIR_NET_BOOK_VALUE 20 IMPAIR_NET_SELLING_PRICE 5 IMPAIR_PERIOD 52 IMPAIR_PERIOD_COUNTER 25 IMPAIR_REASON 27 IMPAIR_SPLIT1_IMPAIR_CLASS 30 IMPAIR_SPLIT1_LOSS_ACCOUNT 29 IMPAIR_SPLIT1_PERCENT 28 IMPAIR_SPLIT1_REASON 31 IMPAIR_SPLIT2_IMPAIR_CLASS 34 IMPAIR_SPLIT2_LOSS_ACCOUNT 33 IMPAIR_SPLIT2_PERCENT 32 IMPAIR_SPLIT2_REASON 35 IMPAIR_SPLIT3_IMPAIR_CLASS 38 IMPAIR_SPLIT3_LOSS_ACCOUNT 37 IMPAIR_SPLIT3_PERCENT 36 IMPAIR_SPLIT3_REASON 26 IMPAIR_SPLIT_IMPAIR_FLAG 12 IMPAIR_STATUS -4.0015 IMPAIR_TRX_ASSET -4.0016 IMPAIR_TRX_ASSET_DESC -4.0005 IMPAIR_TRX_CASH_GEN_UNIT -4.0006 IMPAIR_TRX_CASH_GEN_UNIT_DESC -4.0012 IMPAIR_TRX_CLASS -4.0008 IMPAIR_TRX_DATE -4.0024 IMPAIR_TRX_DATE_INEFFECTIVE -4.001 IMPAIR_TRX_DESC -4.0022 IMPAIR_TRX_GOODWILL_AMOUNT -4.0013 IMPAIR_TRX_GOODWILL_ASSET -4.0014 IMPAIR_TRX_GOODWILL_ASSET_DESC -4.0021 IMPAIR_TRX_IMPAIRMENT_AMOUNT -4.0017 IMPAIR_TRX_LOSS_ACCOUNT -4.0009 IMPAIR_TRX_NAME -4.0018 IMPAIR_TRX_NET_BOOK_VALUE -4.0019 IMPAIR_TRX_NET_SELLING_PRICE -4.0007 IMPAIR_TRX_PERIOD -4.0025 IMPAIR_TRX_REASON -4.0027 IMPAIR_TRX_SPLIT1_IMPAIR_CLASS -4.003 IMPAIR_TRX_SPLIT1_LOSS_ACCOUNT -4.0029 IMPAIR_TRX_SPLIT1_PERCENT -4.0028 IMPAIR_TRX_SPLIT1_REASON -4.0031 IMPAIR_TRX_SPLIT2_IMPAIR_CLASS -4.0034 IMPAIR_TRX_SPLIT2_LOSS_ACCOUNT -4.0033 IMPAIR_TRX_SPLIT2_PERCENT -4.0032 IMPAIR_TRX_SPLIT2_REASON -4.0035 IMPAIR_TRX_SPLIT3_IMPAIR_CLASS -4.0038 IMPAIR_TRX_SPLIT3_LOSS_ACCOUNT -4.0037 IMPAIR_TRX_SPLIT3_PERCENT -4.0036 IMPAIR_TRX_SPLIT3_REASON -4.0026 IMPAIR_TRX_SPLIT_IMPAIR_FLAG -4.0011 IMPAIR_TRX_STATUS -4.0023 IMPAIR_TRX_USER_DATE -4.002 IMPAIR_TRX_VALUE_IN_USE 23 IMPAIR_USER_DATE 21 IMPAIR_VALUE_IN_USE 3 LEDGER 47 YTD_DEPRN 48 YTD_IMPAIRMENT S Site Asset Impairment Report