39、NC企业报表取数

1、资产负债表

视图：view_jfjt_zcfzreport

create or replace view view_jfjt_zcfzreport as
select  t0.keyword1, c.name orgname, t0.keyword2, a.*
  from iufo_measure_data_awv9ruyp a
  left join iufo_measpub_0007 t0
    on a.alone_id = t0.alone_id
  left join org_financeorg c
    on t0.keyword1 = c.pk_financeorg
 order by t0.keyword2 desc,c.name asc;

| 字段对照
**

2、利润表

**

视图：view_jfjt_lrbreport

create or replace view view_jfjt_lrbreport as
select c.name,t0.keyword1, t0.keyword2, a.*
  from iufo_measure_data_fuhntpw1 a
  left join iufo_measpub_0007 t0
    on a.alone_id = t0.alone_id
  left join org_financeorg c
    on t0.keyword1 = c.pk_financeorg
 order by a.ts desc;

字段对照

**

3、现金流量表

**

视图：view_jfjt_xjllbreport

create or replace view view_jfjt_xjllbreport as
select c.name,t0.keyword1, t0.keyword2, a.*
  from iufo_measure_data_uum90412 a
  left join iufo_measpub_0007 t0
    on a.alone_id = t0.alone_id
  left join org_financeorg c
    on t0.keyword1 = c.pk_financeorg
 order by a.ts desc;

**

4、主要费用项目明细表

**
**

5、各经营单位税收简报

**