产品款式 产品款号 产品尺码 产品颜色 teT3 teT3F22 teT3F23 teT3F25 teT3F60 物料档案表 smT3 smT3F15 smT3F17 smT3F44 smT3F45 销售明细表 smT7 smT7F8 smT7F10 smT7F11 smT7F12　销售出货明细表 smT8 smT8F7 smT8F8 smT8F9 smT8F10 销售退货明细表 smT16 smT16F28 smT16F29 smT16F30 smT16F31 销售报价明细表 prT1 prT1F66 prT1F67 prT1F68 prT1F69 工作单表 stT21 stT21F42 stT21F43 stT21F44 stT21F45 收货表 stT8 stT8F42 stT8F43 stT8F44 stT8F45 入库表 stT9 stT9F43 stT9F44 stT9F45 stT9F46 出库表 prT4　 prT4F51 prT4F52 prT4F53 prT4F54 报时报数表 采购退货表没有以上字段 已完成工作任务： 　　工程基础资料 　　工程BOM 工程工艺路线 　　销售单 　　采购单 3730 4945 296.7 918.3 2680+365+300+1600 工作单管理 　　库存管理的入库　 33 收货中 34　已收货 11 已付款 12 付款中 9 收款中 10 已收款 30 出货中 43 已出货 update acT33 set acT33F6=0 where acT33F6=6 update acT34 set acT34F6=0 where acT34F6=6 truncate table acT4 truncate table acT36 truncate table acT31 delete acT32 where acT32F1>=461 select * from acT32 update acT33 set acT33F6=0 where acT33F6 in (6,1) and acT33F9>='2012-12-01' and acT33F9<='2012-12-31' and acT33F17=2 update acT34 set acT34F6=0 where acT34F6 in (6,1) and acT34F7 in (select acT33F1 from acT33 where acT33F9>='2012-12-01' and acT33F9<='2012-12-31' and acT33F17=2) delete acT4 where acT4F8=2012 and acT4F9=12 and acT4F17=2 delete acT36 where acT36F11>='2012-12-01' and acT36F11<='2012-12-31' and acT36F7=2 delete acT31 where acT31F11>='2012-12-01' and acT31F11<='2012-12-31' and acT31F10=2 delete acT32 where acT32F11=2012 and acT32F12=12 and acT32F10=2 update acT4 set acT4F18=0 where acT4F8=2012 and acT4F9=11 and acT4F17=2 update acT32 set acT32F20=0 where acT32F11=2012 and acT32F12=11 and acT32F10=2 delete acT32 where acT32F11=2012 and acT32F12=13 and acT32F10=2 delete acT4 where acT4F8=2012 and acT4F9=13 and acT4F17=2 update acT4 set acT4F18=0 where acT4F8=2012 and acT4F9=12 and acT4F17=2 update acT32 set acT32F20=0 where acT32F11=2012 and acT32F12=12 and acT32F10=2 select @acT36F7 = 0 --int -- 所属分公司 select @acT36F8 = 0 --int -- 会计期间 select @acT36F9 = '' --varchar(50) -- 凭证类型 select @acT36F10 = '' --varchar(50) -- 凭证编号 select @acT36F12 = 0 --int -- 附单据数 select @acT36F17 = '' --varchar(50) -- 出纳签字 select @acT36F18 = '' --varchar(500) -- 摘要 select @acT36F19 = '' --varchar(50) -- 科目编码 select @acT36F20 = '' --varchar(50) -- 币种 select @acT36F21 = 0 --float -- 汇率 select @acT36F22 = '' --varchar(50) -- 本币 select @acT36F23 = 0 --float -- 借方金额 select @acT36F24 = 0 --float -- 贷方金额 select @acT36F25 = 0 --float -- 本币借方金额 select @acT36F26 = 0 --float -- 本币贷方金额 select @acT36F27 = 0 --float -- 数量借方 select @acT36F28 = 0 --float -- 数量贷方 select @acT36F29 = '' --varchar(50) -- 结算方式 select @acT36F30 = '' --varchar(50) -- 票据号 select @acT36F31 = NULL --datetime -- 票据日期 select @acT36F32 = 0 --int -- 部门 select @acT36F33 = '' --varchar(50) -- 经手人 select @acT36F34 = '' --varchar(50) -- 客户/供应商 select @acT36F35 = '' --varchar(50) -- 项目 select @acT36F36 = '' --varchar(50) -- 项目类别 select @acT36F37 = '' --varchar(50) -- 业务员 select @acT36F38 = '' --varchar(50) -- 银行帐两清标志 select @acT36F39 = '' --varchar(50) -- 往来帐两清标志 select @acT36F40 = 0 --int -- 是否核销 select @acT36F41 = 0 --int -- 来源表ID update acT33 set acT33F6=0 where acT33F6 in (6,1) and acT33F9>='2013-06-01' and acT33F9<='2013-06-30' and acT33F17=2 update acT34 set acT34F6=0 where acT34F6 in (6,1) and acT34F7 in (select acT33F1 from acT33 where acT33F9>='2013-06-01' and acT33F9<='2013-06-30' and acT33F17=2) delete acT4 where acT4F8=2013 and acT4F9=6 and acT4F17=2 delete acT36 where acT36F11>='2013-06-01' and acT36F11<='2013-06-30' and acT36F7=2 delete acT31 where acT31F11>='2013-06-01' and acT31F11<='2013-06-30' and acT31F10=2 delete acT32 where acT32F11=2013 and acT32F12=6 and acT32F10=2 update acT4 set acT4F18=0 where acT4F8=2013 and acT4F9=5 and acT4F17=2 update acT32 set acT32F20=0 where acT32F11=2013 and acT32F12=5 and acT32F10=2 update acT33 set acT33F6=0 where acT33F6 in (6,1) and acT33F9>='2013-05-01' and acT33F9<='2013-05-31' and acT33F17=2 update acT34 set acT34F6=0 where acT34F6 in (6,1) and acT34F7 in (select acT33F1 from acT33 where acT33F9>='2012-12-01' and acT33F9<='2012-12-31' and acT33F17=2) delete acT4 where acT4F8=2013 and acT4F9=5 and acT4F17=2 delete acT36 where acT36F11>='2013-05-01' and acT36F11<='2013-05-31' and acT36F7=2 delete acT31 where acT31F11>='2013-05-01' and acT31F11<='2013-05-31' and acT31F10=2 delete acT32 where acT32F11=2013 and acT32F12=5 and acT32F10=2 update acT4 set acT4F18=0 where acT4F8=2013 and acT4F9=4 and acT4F17=2 update acT32 set acT32F20=0 where acT32F11=2013 and acT32F12=4 and acT32F10=2