| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849 |
- ALTER TABLE org_annual_report
- add `basic_research_cost` DECIMAL(8,2) NULL COMMENT '基础研究投入费用' AFTER `total_export_volume`;
- ALTER TABLE org_activity
- MODIFY COLUMN budget DECIMAL(8,2) COMMENT '预算(万元)',
- MODIFY COLUMN first_year_expenditure DECIMAL(8,2) COMMENT '第一年研发经费支出(万元)',
- MODIFY COLUMN second_year_expenditure DECIMAL(8,2) COMMENT '第二年研发经费支出(万元)',
- MODIFY COLUMN third_year_expenditure DECIMAL(8,2) COMMENT '第三年研发经费支出(万元)';
- ALTER TABLE org_activity_cost
- MODIFY COLUMN internal_labor_cost DECIMAL(8,2) COMMENT '内部人员人工费用(万元)',
- MODIFY COLUMN internal_direct_cost DECIMAL(8,2) COMMENT '内部直接投入费用(万元)',
- MODIFY COLUMN internal_depreciation_cost DECIMAL(8,2) COMMENT '内部折旧费用与长期待摊费用(万元)',
- MODIFY COLUMN internal_amortization_cost DECIMAL(8,2) COMMENT '内部无形资产摊销费用(万元)',
- MODIFY COLUMN internal_design_cost DECIMAL(8,2) COMMENT '内部设计费用(万元)',
- MODIFY COLUMN internal_equipment_cost DECIMAL(8,2) COMMENT '内部装备调试费用与实验费用(万元)',
- MODIFY COLUMN internal_other_cost DECIMAL(8,2) COMMENT '内部其他费用(万元)',
- MODIFY COLUMN external_total_cost DECIMAL(8,2) COMMENT '委托外部研究开发总费用(万元)',
- MODIFY COLUMN external_abroad_cost DECIMAL(8,2) COMMENT '委托外部境内的外部研发费用(万元)';
- ALTER TABLE org_cognizance
- MODIFY COLUMN basic_research_cost DECIMAL(8,2) COMMENT '基础研究投入费用总额(万元)';
- ALTER TABLE org_finance
- MODIFY COLUMN main_business_income DECIMAL(8,2) COMMENT '主营业务收入(万元)',
- MODIFY COLUMN management_cost DECIMAL(8,2) COMMENT '管理费用(万元)',
- MODIFY COLUMN operating_profit DECIMAL(8,2) COMMENT '营业利润(万元)',
- MODIFY COLUMN various_tax DECIMAL(8,2) COMMENT '支付的各项税费(万元)',
- MODIFY COLUMN current_asset DECIMAL(8,2) COMMENT '流动资产(万元)',
- MODIFY COLUMN net_fixed_asset DECIMAL(8,2) COMMENT '固定资产净额(万元)',
- MODIFY COLUMN total_asset DECIMAL(8,2) COMMENT '资产总额(万元)',
- MODIFY COLUMN net_asset DECIMAL(8,2) COMMENT '所有者权益合计(万元)',
- MODIFY COLUMN gross_profit DECIMAL(8,2) COMMENT '利润总额(万元)',
- MODIFY COLUMN net_profit DECIMAL(8,2) COMMENT '净利润(万元)',
- MODIFY COLUMN sales_revenue DECIMAL(8,2) COMMENT '销售收入(万元)';
- ALTER TABLE org_ratepay
- MODIFY COLUMN operating_income DECIMAL(8,2) COMMENT '营业收入(万元)',
- MODIFY COLUMN management_cost DECIMAL(8,2) COMMENT '管理费用(万元)',
- MODIFY COLUMN operating_profit DECIMAL(8,2) COMMENT '营业利润(万元)',
- MODIFY COLUMN non_operating_income DECIMAL(8,2) COMMENT '营业外收入(万元)',
- MODIFY COLUMN non_taxable_income DECIMAL(8,2) COMMENT '不征税收入(万元)',
- MODIFY COLUMN tax_exempt_income DECIMAL(8,2) COMMENT '免税收入(万元)',
- MODIFY COLUMN subsidy_income DECIMAL(8,2) COMMENT '政府补助收入(万元)',
- MODIFY COLUMN gross_profit DECIMAL(8,2) COMMENT '利润总额(万元)',
- MODIFY COLUMN research_cost DECIMAL(8,2) COMMENT '研发费用(万元)';
- ALTER TABLE org_tech_product
- MODIFY COLUMN last_year_revenue DECIMAL(8,2) COMMENT '上年度销售收入(万元)';
|