text: create table charity_commission.charity_annual_return_partb (
  	date_of_extract date,
  	organisation_number int,
  	registered_charity_number int, -- regno in the old schema
  	latest_fin_period_submitted_ind bit,
  	fin_period_order_number int,
  	ar_cycle_reference varchar(255),
  	fin_period_start_date date,
  	fin_period_end_date date,
  	ar_due_date date,
  	ar_received_date date,
  	income_donations_and_legacies decimal,
  	income_charitable_activities decimal,
  	income_other_trading_activities decimal,
  	income_investments decimal,
  	income_other decimal,
  	income_total_income_and_endowments decimal,
  	income_legacies decimal,
  	income_endowments decimal,
  	expenditure_raising_funds decimal,
  	expenditure_charitable_expenditure decimal,
  	expenditure_other decimal,
  	expenditure_total decimal,
  	expenditure_investment_management decimal,
  	expenditure_grants_institution decimal,
  	expenditure_governance decimal,
  	expenditure_support_costs decimal,
  	expenditure_depreciation decimal,
  	gain_loss_investment decimal,
  	gain_loss_pension_fund decimal,
  	gain_loss_revaluation_fixed_investment decimal,
  	gain_loss_other decimal,
  	reserves decimal,
  	assets_total_fixed decimal,
  	assets_own_use decimal,
  	assets_long_term_investment decimal,
  	defined_benefit_pension_scheme decimal,
  	assets_other_assets decimal,
  	assets_total_liabilities decimal,
  	assets_current_investment decimal,
  	assets_total_assets_and_liabilities decimal,
  	creditors_one_year_total_current decimal,
  	creditors_falling_due_after_one_year decimal,
  	assets_cash decimal,
  	funds_endowment decimal,
  	funds_unrestricted decimal,
  	funds_restricted decimal,
  	funds_total decimal,
  	count_employees int,
  	charity_only_accounts bit,
  	consolidated_accounts bit,
  	primary key (organisation_number, ar_due_date)
  ) charset=utf8mb4;
  
  