伊人色综合久久天天人手人停-国产剧情欧美精品久久-亚洲Va欧美va国产综合888-亚洲av第一页国产精品

首頁(yè) 關(guān)于我們 新聞資訊 金蝶軟件 實(shí)施流程 在線(xiàn)預約 會(huì )計技巧 服務(wù)咨詢(xún) 聯(lián)系我們 常見(jiàn)問(wèn)題
金蝶K3清空數據庫財務(wù)+物流+生產(chǎn)+質(zhì)量管理模塊歷史單據數據
2018-07-14 23:50:01

金蝶K3清空數據庫財務(wù)+物流+生產(chǎn)+質(zhì)量管理模塊歷史單據數據的語(yǔ)句,請謹慎使用。
TRUNCATE TABLE DRP_CarryingInvoice
TRUNCATE TABLE ICExpenses
TRUNCATE TABLE ICItemReplace
TRUNCATE TABLE ICitemScrap
TRUNCATE TABLE ICJobPay
TRUNCATE TABLE ICMO
TRUNCATE TABLE ICMORpt
TRUNCATE TABLE ICMrpResult
TRUNCATE TABLE ICOperShift
TRUNCATE TABLE ICPlanAdjPrice
TRUNCATE TABLE ICPurchase
TRUNCATE TABLE ICQCBill
TRUNCATE TABLE ICSale
TRUNCATE TABLE ICSaleQcbill
TRUNCATE TABLE ICSTJGBill
TRUNCATE TABLE ICStockBill
TRUNCATE TABLE ICTaskDispBill
TRUNCATE TABLE POInStock
TRUNCATE TABLE POOrder
TRUNCATE TABLE POrequest
TRUNCATE TABLE PORFQ
TRUNCATE TABLE POStockBill
TRUNCATE TABLE PPBOM
TRUNCATE TABLE PPOrder
TRUNCATE TABLE QMIcmoCkRequest
TRUNCATE TABLE QMINQCReq
TRUNCATE TABLE QMOtCkRequest
TRUNCATE TABLE QMQCBill
TRUNCATE TABLE QMSaleCkRequest
TRUNCATE TABLE SEOrder
TRUNCATE TABLE SEOutStock
TRUNCATE TABLE SHProcRptMain
TRUNCATE TABLE SHWorkBill
TRUNCATE TABLE t_Voucher
TRUNCATE TABLE ZPStockBill
TRUNCATE TABLE DRP_CarryingInvoiceEntry
TRUNCATE TABLE ICExpensesEntry
TRUNCATE TABLE ICItemReplaceEntry
TRUNCATE TABLE ICitemScrapEntry
TRUNCATE TABLE ICJobPayEntry
TRUNCATE TABLE ICMORptEntry

TRUNCATE TABLE ICPlanAdjPriEntry
TRUNCATE TABLE ICPurchaseEntry
TRUNCATE TABLE ICQCBillEntry
TRUNCATE TABLE ICSaleEntry
TRUNCATE TABLE ICSaleQcbillEntry
TRUNCATE TABLE ICSTJGBillEntry
TRUNCATE TABLE ICStockBillEntry
TRUNCATE TABLE ICTaskDispBillEntry
TRUNCATE TABLE POInStockEntry
TRUNCATE TABLE POOrderEntry
TRUNCATE TABLE POrequestEntry
TRUNCATE TABLE PORFQEntry
TRUNCATE TABLE POStockBillEntry
TRUNCATE TABLE PPBOMEntry
TRUNCATE TABLE PPOrderEntry
TRUNCATE TABLE QMIcmoCkRequestEntry
TRUNCATE TABLE QMINQCReqEntry
TRUNCATE TABLE QMOtCkRequestEntry
TRUNCATE TABLE QMQCBillEntry
TRUNCATE TABLE QMSaleCkRequestEntry
TRUNCATE TABLE SEOrderEntry
TRUNCATE TABLE SEOutStockEntry
TRUNCATE TABLE SHProcRpt
TRUNCATE TABLE SHWorkBillEntry
TRUNCATE TABLE t_VoucherEntry 
TRUNCATE TABLE ZPStockBillEntry

--刪除余額表
--財務(wù)部份
delete from t_balance where FYear+FPeriod*0.01<2007.03 
delete from t_QuantityBalance where FYear+FPeriod*0.01<2007.03 
delete from t_ProfitAndLoss where FYear+FPeriod*0.01<2007.03 

--應收應付部份
TRUNCATE TABLE t_RP_ARPBill 
TRUNCATE TABLE t_RP_ARPBillEntry 
TRUNCATE TABLE t_rp_ARBillOfSH 
TRUNCATE TABLE t_rp_ARBillOfSh_ICItem 
delete from t_RP_Contact where FYear+FPeriod*0.01<2007.03 
delete from t_RP_ContactBal where FYear+FPeriod*0.01<2007.03 
TRUNCATE TABLE t_RP_NewReceiveBill

update t_RP_SystemProfile set FValue=2007 where FCategory='ARP' and FKey='FAPUseYear'

update t_RP_SystemProfile set FValue=3 where FCategory='ARP' and FKey='FAPUsePeriod'

update t_RP_SystemProfile set FValue=2007 where FCategory='ARP' and FKey='FARUseYear'

update t_RP_SystemProfile set FValue=3 where FCategory='ARP' and FKey='FARUsePeriod'
--物流
delete from ICBal where FYear+FPeriod*0.01<2007.03 
delete from ICInvBal where FYear+FPeriod*0.01<2007.03 
TRUNCATE TABLE ICInventory
TRUNCATE TABLE ICInvInitial
update t_RP_SystemProfile set FValue=2007 where FCategory='GL' and FKey='StartYear'
update t_RP_SystemProfile set FValue=3 where FCategory='GL' and FKey='StartPeriod'
update t_RP_SystemProfile set FValue=2007 where FCategory='IC' and FKey='StartYear'
update t_RP_SystemProfile set FValue=3 where FCategory='IC' and FKey='StartPeriod'
-----刪除財務(wù)總帳/應收/應付累計
update t_Balance
set FYtdDebitFor=0 

update t_Balance
set FYtdcreditFor=0 

update t_Balance
set FYtdDebit=0 

update t_Balance
set FYtdcredit=0 

update t_QuantityBalance
set FDebitqty=0 

update t_QuantityBalance
set Fcreditqty=0 

update t_QuantityBalance
set FYtdDebitqty=0 

update t_QuantityBalance
set FYtdcreditqty=0 

update t_ProfitAndLoss
set FYtdAmountFor=0 

update t_ProfitAndLoss
set FYtdAmount=0 

update t_RP_ContactBal
set FYtdDebitFor=0 

update t_RP_ContactBal
set FYtdcreditFor=0 

update t_RP_ContactBal
set FYtdDebit=0 

update t_RP_ContactBal
set FYtdcredit=0 

-----更改應收應付本年累計=本期合計
update t_RP_ContactBal
set FYtdDebitFor=FDebitFor
update t_RP_ContactBal
set FYtdDebit=FDebit
update t_RP_ContactBal
set FYtdCreditFor=FCreditFor
update t_RP_ContactBal
set FYtdCredit=FCredit

bottom-map
昆山云數軟件信息技術(shù)有限公司 2007-2023 @ All Rights Reserved 蘇ICP備15052466號-1
友情鏈接:PbootCMS 百度 金蝶官網(wǎng) 云數建站 金蝶精斗云