FA Calculation of Capital Adjustment / General Fund Account Balances for UK Local Authority Accounting Implementation
Description
- Categories
- BI Publisher
- Application
- Assets
- Source
- Calculation of Capital Adjustment / General Fund Account Balances for UK Local Authority Accounting Implementation
- Short Name
- FASRPCGC
- DB package
- FA_SORP_UPG_PKG
SQL 11 lines
select category_name, sum(current_cost) current_cost, sum(depriciation_reserve)depriciation_reserve, sum(revaluation_reserve) revaluation_reserve, sum(impairment_reserve) accumulated_impairment, sum(capital_adjustment_acct_amount)capital_adjustment_acct_amount, sum(general_fund_acct_amount) general_fund_acct_amount from &p_from &p_where group by category_name |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Asset Book | LOV Oracle | |
| Summary Mode | LOV Oracle | |
| Report Mode | LOV Oracle |