2011年9月1日工资新个税调整工具

jerometan

怎么获得金币啊， 需要升级包

长沙百合

好用不罗,买了试下

长沙百合

我付金币了,怎么不能下载?

长沙百合

我怎么付了两次金币才可能下载呀

as1216

................................

wsmn

太贵了，但还是下载了

yaobixing

下载了。主题5，附件5，下载还要3.我彻底服了。

szjyrj1

其实自己改改就好拿

cemianlyg

号东西，一定要顶！！

cemianlyg

若不用该工具的话手工该怎么调哦

cemianlyg

若不用该工具的话手工该怎么调哦

point09k

谢谢楼主，方便

春龙

钱呐，没钱呐

1015392766

用手工调太麻烦了啊

deerjam

--变更税率，如果从9月份工资开始计算，将下面的8改成9即可
declare @period int

set @period=8

--基数和附加费用

update [WA_SDS_p] set youtlay=3500,youtpluslay=1300 where period>=@period


--代扣税各税率级次
delete  from [WA_SDS_sl] where period>=8 and isl_id>7

update [WA_SDS_SL] set ymin_level=0,ymax_level=1500,isl=3,ysskcs=0 where period>=@period and isl_id=1

update [WA_SDS_SL] set ymin_level=1500,ymax_level=4500,isl=10,ysskcs=105 where period>=@period and isl_id=2

update [WA_SDS_SL] set ymin_level=4500,ymax_level=9000,isl=20,ysskcs=555 where period>=@period and isl_id=3

update [WA_SDS_SL] set ymin_level=9000,ymax_level=35000,isl=25,ysskcs=1005 where period>=@period and isl_id=4

update [WA_SDS_SL] set ymin_level=35000,ymax_level=55000,isl=30,ysskcs=2755 where period>=@period and isl_id=5

update [WA_SDS_SL] set ymin_level=55000,ymax_level=80000,isl=35,ysskcs=5505 where period>=@period and isl_id=6

update [WA_SDS_SL] set ymin_level=80000,ymax_level=0,isl=45,ysskcs=13505 where period>=@period and isl_id=7

--代付税各税率级次
delete  from [WA_SDS_SLnew] where period>=@period and isl_id>7

update [WA_SDS_SLnew] set ymin_level=0,ymax_level=1455,isl=3,ysskcs=0 where period>=@period and isl_id=1

update [WA_SDS_SLnew] set ymin_level=1455,ymax_level=4155,isl=10,ysskcs=105 where period>=@period and isl_id=2

update [WA_SDS_SLnew] set ymin_level=4155,ymax_level=7755,isl=20,ysskcs=555 where period>=@period and isl_id=3

update [WA_SDS_SLnew] set ymin_level=7755,ymax_level=27255,isl=25,ysskcs=1005 where period>=@period and isl_id=4

update [WA_SDS_SLnew] set ymin_level=27255,ymax_level=41255,isl=30,ysskcs=2755 where period>=@period and isl_id=5

update [WA_SDS_SLnew] set ymin_level=41255,ymax_level=57505,isl=35,ysskcs=5505 where period>=@period and isl_id=6

update [WA_SDS_SLnew] set ymin_level=57505,ymax_level=0,isl=45,ysskcs=13505 where period>=@period and isl_id=7