进度表SQL语句

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

--SP_QYSDS_ID

SELECT nsrsbh,nsrmc FROM DJ_NSRXX

where nsrsbh=&&c430005000000061

--SP_QYSDS_JNBY今年本月入库

SELECT nsrsbh,round(SUM(SE)/10000,2) FROM SB_ZSXX WHERE rkrq>=$$0011 and rkrq<=$$0012 AND RKSKBZ = 'Y' AND ZSXM_DM in ('04','05') and nsrsbh=&&c430005000000061 group by nsrsbh

--SP_QYSDS_JNLJ今年累计入库

SELECT nsrsbh,round(SUM(SE)/10000,2) FROM SB_ZSXX WHERE rkrq>=$$0010 and rkrq<=$$0012 AND RKSKBZ = 'Y' AND ZSXM_DM in ('04','05') and nsrsbh=&&c430005000000061 group by nsrsbh

--SP_QYSDS_QNTY去年同月入库

SELECT nsrsbh,round(SUM(SE)/10000,2) FROM SB_ZSXX WHERE RKRQ >=add_months( $$0011,-12) AND (RKRQ

--SP_QYSDS_QNLJ去年累计入库

SELECT nsrsbh,round(SUM(SE)/10000,2) FROM SB_ZSXX WHERE RKRQ >=add_months( $$0010,-12) AND (RKRQ2100433B

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

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

--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

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

and ZSXM_DM=&&c888999000000002

and substr(nsr_swjg_dm, 1, 7)=1431123

group by ZSXM_DM

生产周期进度表，亦称“产品生产周期进度表”。表示产品在生产过程中，各个工艺加工阶段以及各道工序之间时间上衔接状况的一种作业计划图表。适用于生产周期较长的单件生产。

其编制方法，首先确定产品的装配周期，然后确定机械加工和毛坯制造所需要时间，并充分考虑各工艺阶段之间平行交叉作业的可能性，以求尽可能缩短生产周期。在各工艺阶段之间和关键工序上需要留出保险时间，以保证整个生产进度顺利进行。 2100433B