您好,请您先 登陆 或者 注册

【官方】A3开业清库

//开业清库 清除基本数据 ;
delete from basBranchInfo
delete from basBrandInfo
delete from basCustInfo
delete from basCustType
delete from basItem_barcode
delete from basItem_Pack
delete from basItemCls
delete from basItemInfo
delete from basOverType
delete from basPayInfo
delete from basSheetWayInfo
delete from basSupInfo
delete from basSupType
delete from memIntegralExchange
delete from memPriceDetail
delete from memPriceInfo
delete from memTypeInfo
delete from posGiftDetail
delete from posGiftMaster
delete from posGiveDetail
delete from posGiveMaster
delete from posSpecialDetail
delete from posSpecialMaster
delete from safLogFlow
delete from sysBillFlow
delete from sysDwStyle
delete from sysWorkstation


//开业清库 清除前台销售数据 ;
delete from posSalePay
delete from posSaleDetail
delete from posSaleMaster
delete from posOverDetail
delete from posOverMaster
delete from PosStoreMaster
delete from PosStoreDetail
delete from posoperLog

//开业清库 清除后台单据数据 ;
delete from depSheetDetail
delete from depSheetMaster
delete from depPriceDetail
delete from depPriceMaster
delete from depOrderDetail
delete from depOrderMaster

//清除库存数据;
delete from depCheckDetail
delete from depCheckMaster
delete from depCheckInit_detail
delete from depCheckInit
delete from depCheckRange
delete from depStock
delete from depStock_every
delete from depCostFlow

提问者: 李祥
等级:问不倒翁
时间:2011-01-29 17:11
悬赏:0
解决时间:2011-02-10 13:18
总积分排行
ytkf00720058 4704
kh35927124 3414
赢通技术43538 3053
bonchen13219 2797
赢通技术37615 2590
JCLH11087 1917
浅逝1873 1873
李祥19958 1542
xiaobird3309 1254
daoptt3310 1237