進度表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