进度表SQL语句

单位：万元，保留两位小数

以下为进度表语句 (此表为加快生成速度，项目列文字需对照“徵收项目”代码先手工填入）

--SP_JDB_JKDZ_JNBY今年本月入库

SELECT ZSXM_DM,

round(SUM(SE)/10000,2)

FROM V_KJ_SB_ZSXX_RKRQ

WHERE RKRQ>= $$0011 AND (RKRQ< $$0012 OR RKRQ=$$0012)

and ZSXM_DM=&&c888999000000002

and substr(nsr_swjg_dm,1,7)=1431123

group by ZSXM_DM

--SP_JDB_JKDZ_JNLJ今年累计入库

SELECT ZSXM_DM,

round(SUM(SE)/10000,2)

FROM V_KJ_SB_ZSXX_RKRQ

WHERE RKRQ>= $$0010 AND (RKRQ< $$0012 OR RKRQ=$$0012)

and ZSXM_DM=&&c888999000000002

and substr(nsr_swjg_dm,1,7)=1431123

group by ZSXM_DM

--SP_JDB_JKDZ_QNTY去年同月入库

SELECT ZSXM_DM,

round(SUM(SE)/10000,2)

FROM V_KJ_SB_ZSXX_RKRQ

WHERE RKRQ>=add_months( $$0011,-12) AND (RKRQ<add_months($$0012,-12) OR RKRQ=add_months($$0012,-12) )

and ZSXM_DM=&&c888999000000002

and substr(nsr_swjg_dm, 1, 7)=1431123

group by ZSXM_DM

--SP_JDB_JKDZ_QNLJ去年累计入库

SELECT ZSXM_DM,

round(SUM(SE)/10000,2)

FROM V_KJ_SB_ZSXX_RKRQ

WHERE RKRQ>=add_months( $$0010,-12) AND (RKRQ<add_months($$0012,-12) OR RKRQ=add_months($$0012,-12) )

and ZSXM_DM=&&c888999000000002

and substr(nsr_swjg_dm, 1, 7)=1431123

group by ZSXM_DM

企业所得税入库SQL语句

以下为企业所得税分企业入库SQL语句

--SP_QYSDS_ID

SELECT nsrsbh,nsrmc FROM DJ_NSRXX

where nsrsbh=&&c430005000000061