//开业清库 清除基本数据 ;
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
【官方】A3开业清库
- 提问者: 李祥
- 等级:问不倒翁
- 时间:2011-01-29 17:11
- 悬赏:0
- 解决时间:2011-02-10 13:18
快到期问题