--¹Ì¶¨×ʲú
truncate table T_FACard
truncate table T_FACardItem
truncate table T_FADevice
truncate table T_FAOrgFor
truncate table T_FADept
truncate table T_FAExpense
truncate table t_FAPurchase
truncate table T_FAbalCard
truncate table T_FAbalCardItem
truncate table T_FAbalDevice
truncate table T_FAbalOrgFor
truncate table T_FAbalDept
truncate table T_FAbalExpense
truncate table t_FAbalPurchase
truncate table t_FAVoucher
truncate table t_FAClear
DELETE FROM T_FAAlter
DELETE FROM t_FAbalance

--Ó¦ÊÕÓ¦¸¶
truncate table t_RP_NewReceiveBill
truncate table t_rp_ARBillOfSH
truncate table t_rp_AdjustAccount
truncate table t_rp_AdjustRate
truncate table t_rp_AdjustRateEntry
truncate table t_rp_ARBillOfSH
truncate table t_RP_ARPBill
truncate table t_rp_arpbillEntry
truncate table t_rp_BegData
truncate table t_rp_BegDataEntry
truncate table t_RP_Bill
truncate table t_rp_bill_discount
truncate table t_RP_Bill_Endorse
truncate table t_RP_Bill_Settle
truncate table t_Rp_CheckDetail
truncate table t_rp_CheckEntry
truncate table t_RP_Contact
truncate table t_RP_ContactBal
truncate table t_rp_ContractPlanReceive
truncate table t_RP_NewReceiveBill
truncate table t_rp_PayApplyBill
truncate table t_rp_PayApplyBillEntry
truncate table t_RP_Plan_Ap
truncate table t_RP_Plan_Ar
truncate table t_RPContract
truncate table t_rpContractEntry
truncate table t_RPContractScheme
truncate table t_RPVoucherAndBill
truncate table t_RP_NewCheckInfo

--×ÜÕË
truncate table t_ProfitAndLoss
truncate table t_Voucher
truncate table t_Voucherentry
truncate table t_Balance
truncate table t_ProfitAndLoss
truncate table icbal
truncate table icinvbal
truncate table ICInvInitial
truncate table POInvBal
truncate table cbBalance
truncate table cbCalInfo

--ÉèÖà ÆôÓÃÆڼ䣬µ±Ç°ÆÚ¼ä,ÕâÀＸÔ·ݿªÊ¼ÓþÍÉèÖÃΪ¼¸Ô·Ý
update t_SystemProfile set FValue=9 where FCategory='gl' and FKey='startperiod'
update t_SystemProfile set FValue=2020 where FCategory='gl' and FKey='startyear'
update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='startperiod'
update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='startyear'
update t_SystemProfile set FValue=9 where FCategory='CB' and FKey='startperiod'
update t_SystemProfile set FValue=2020 where FCategory='CB' and FKey='startyear'
update t_SystemProfile set FValue=9 where FCategory='FA' and FKey='startperiod'
update t_SystemProfile set FValue=2020 where FCategory='FA' and FKey='startyear'
update t_SystemProfile set FValue=9 where FCategory='gl' and FKey='currentperiod'
update t_SystemProfile set FValue=2020 where FCategory='gl' and FKey='currentyear'
update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='currentperiod'
update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='currentyear'
update t_SystemProfile set FValue=9 where FCategory='CB' and FKey='currentperiod'
update t_SystemProfile set FValue=2020 where FCategory='CB' and FKey='currentyear'
update t_SystemProfile set FValue=9 where FCategory='FA' and FKey='currentperiod'
update t_SystemProfile set FValue=2020 where FCategory='FA' and FKey='currentyear'
UPDATE dbo.t_RP_SystemProfile set FValue=9    WHERE FKey ='FAPCurPeriod'
UPDATE dbo.t_RP_SystemProfile  set FValue=2020  WHERE FKey ='FAPCurYear'
UPDATE dbo.t_RP_SystemProfile set FValue=9   WHERE FKey ='FAPUsePeriod'
UPDATE dbo.t_RP_SystemProfile  set FValue=2020  WHERE FKey ='FAPUseYear'
UPDATE dbo.t_RP_SystemProfile set FValue=9   WHERE FKey ='FARCurPeriod'
UPDATE dbo.t_RP_SystemProfile set FValue=2020   WHERE FKey ='FARCurYear'
UPDATE dbo.t_RP_SystemProfile  set FValue=9  WHERE FKey ='FARUsePeriod'
UPDATE dbo.t_RP_SystemProfile set FValue=2020   WHERE FKey ='FARUseYear'