澳博V9连锁版，删除分店销售数据，在分店服务器执行

澳博V9连锁删除分店销售数据在分店服务器执行
--说明：下面的时间是填写删除到的日期，如要删到2017年1月1号，则到单引号中填入：2017-01-01



--删除分店前台销售明细


declare @d datetime 
declare @z varchar(4)


set @d = '时间'
set @z = '分店仓库编码'


DELETE FROM BBB077 WHERE o00781 <= @d  and o00935=@z
DELETE FROM BBB070 WHERE o00781 <= @d  and o00935=@z
DELETE FROM BBB022 WHERE o00781 <= @d  and o00935=@z








---前台日结


declare @e datetime
declare @z varchar(4)
set @e = '时间'
set @z = '分店仓库编码'


DELETE FROM BBB023 WHERE o00781 <= @e  and o00935=@z
DELETE FROM BBB059 WHERE o00781 <= @e  and o00935=@z
delete from bbb051 where o00781 <= convert(varchar(8),@e,112) and o00935=@z


---应收应付
declare @c datetime
declare @z varchar(4)


set @c = '时间'
set @z = '分店机构编码'


DELETE FROM RRR008 WHERE o00781 <= @c and o00935=@z
DELETE FROM RRR007 WHERE v01152 <= @c and v00332 =r00149   and o00935=@z




----进销存


declare @b datetime
declare @z varchar(4)


set @b = '时间'
set @z = '分店仓库编码'


delete from CCC036 where o00781 <= @b and o00935=@z
delete from CCC016 where convert ( integer , c00605 ) <= year(@b) + month(@b) and o00935=@z
delete from OOO126 where o00935=@z and convert(char(10),o00781,120)<=@b 


-----单据
declare @a datetime 
declare @z varchar(4)


set @a = '时间'
set @z = '分店仓库编码'


delete from ccc012 
where o01051 in (select o01051 from ccc010 where o00781 < @a and o00935=@z)
delete from ccc010 where o00781 < @a and o00935=@z or o00385=@z


delete from CCC018 
where o01051 in (select o01051 from ccc033 where o00781 < @a and o00935=@z)
delete from ccc033 where o00781 < @a and o00935=@z


delete from OOO110 
where o01051 in (select o01051 from OOO130 where o00781 < @a and o00935=@z)
delete from OOO130 where o00781 < @a and o00935=@z


delete from ooo019 
where o01051 in (select o01051 from ooo135 where o00781 < @a and o00935=@z)
delete from ooo135 where o00781 < @a and o00935=@z


delete from ooo090 
where o01051 in (select o01051 from ooo089 where o00781 < @a and o00935=@z)
delete from ooo089 where o00781 < @a and o00935=@z


delete from ccc028 where o01051 in (select o01051 from ooo129 where o00986<=@a and  o00935=@z )
delete from ooo129 where o00986<=@a and  o00935=@z 
delete from CCC016  where o00935=@z
delete from OOO068 where v00097=@z or r00650=@z and o00781<=@a
delete from OOO141 where v00097=@z or r00650=@z and o00781<=@a
delete from OOO147 where v00857=@z or o00055=@z and v01319<=@a
delete from OOO086 where v00857=@z or o00055=@z and v01319<=@a


--删除库存表记录,此操作请慎用！


declare @z varchar(4)
set @z = '分店仓库编码'


delete  from ccc029 where o00935=@z