From d4be4da8cb17eab18caacf5f689c441358b034b3 Mon Sep 17 00:00:00 2001
From: 陈炜 <5856420@qq.com>
Date: 星期三, 23 九月 2020 14:43:39 +0800
Subject: [PATCH] 新增K3数据库删除脚本

---
 删除数据2020.09.14-全(慎用).sql |  281 +++++++++++++++++++++++++
 删除数据1.sql                |   21 +
 删除数据4.sql                |   89 ++++++++
 删除数据2020.09.17.sql       |   21 +
 删除数据3.sql                |   65 +++++
 删除数据2.sql                |   26 ++
 财务会计.conf                |  108 +++++++++
 7 files changed, 611 insertions(+), 0 deletions(-)

diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2561.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2561.sql"
new file mode 100644
index 0000000..1c909f0
--- /dev/null
+++ "b/\345\210\240\351\231\244\346\225\260\346\215\2561.sql"
@@ -0,0 +1,21 @@
+--销售合同
+truncate table  t_RPContract
+truncate table  t_RPContractDetail
+truncate table  t_rpContractEntry
+--    订单
+truncate table  dbo.SEOrder
+truncate table  dbo.SEOrderEntry
+--发货通知,退货通知 
+truncate table  dbo.SEOutStock
+truncate table  dbo.SEOutStockEntry
+--销售发票
+truncate table  dbo.ICSale
+truncate table  dbo.ICSaleEntry
+DELETE  FROM dbo.t_RP_Contact WHERE FType =3
+--销售出库,库存类的单据都在一张表,删除所有库存单据后,需要删除存货核算余额表和即时库存表
+ALTER TABLE ICStockBill DISABLE TRIGGER ALL
+DELETE  FROM dbo.ICStockBill WHERE FTranType IN (21)
+DELETE  FROM dbo.ICStockBillEntry WHERE FInterID NOT IN (SELECT FInterID FROM dbo.ICStockBill)
+ALTER TABLE ICStockBill ENABLE TRIGGER ALL
+--收款单,与应收系统相关,需确认后再删除,删除后需要删除余额,建议应收应付一起处理
+--需全部删除后,需更新启用期间后账套才能开始使用
\ No newline at end of file
diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2562.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2562.sql"
new file mode 100644
index 0000000..4e6652c
--- /dev/null
+++ "b/\345\210\240\351\231\244\346\225\260\346\215\2562.sql"
@@ -0,0 +1,26 @@
+--    订单
+truncate table POOrder
+truncate table dbo.POOrderEntry
+truncate table dbo.ICSubContract
+truncate table dbo.ICSubContractEntry
+truncate table dbo.POInStock
+truncate table dbo.POInStockEntry
+--付款申请单
+TRUNCATE TABLE t_rp_PayApplyBillEntry
+TRUNCATE TABLE t_rp_PayApplyBill
+--采购发票
+truncate table  dbo.ICPurchase
+truncate table  dbo.ICPurchaseEntry
+DELETE  FROM dbo.t_RP_Contact WHERE FType =4
+--库存类的单据都在一张表,删除所有库存单据后,需要删除存货核算余额表和即时库存表
+ALTER TABLE ICStockBill DISABLE TRIGGER ALL
+DELETE  FROM dbo.ICStockBill
+DELETE  FROM dbo.ICStockBillEntry
+ALTER TABLE ICStockBill ENABLE TRIGGER ALL
+TRUNCATE TABLE dbo.ICBal
+TRUNCATE TABLE dbo.ICInvBal
+TRUNCATE TABLE dbo.ICInventory
+TRUNCATE TABLE ICInvInitial
+TRUNCATE TABLE POInvBal
+TRUNCATE TABLE dbo.POInventory
+--需全部删除后,需更新启用期间后账套才能开始使用
\ No newline at end of file
diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.14-\345\205\250\050\346\205\216\347\224\250\051.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.14-\345\205\250\050\346\205\216\347\224\250\051.sql"
new file mode 100644
index 0000000..3b6df87
--- /dev/null
+++ "b/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.14-\345\205\250\050\346\205\216\347\224\250\051.sql"
@@ -0,0 +1,281 @@
+--单据
+truncate table  QMSaleCkRequest	
+truncate table QMSaleCkRequestEntry
+truncate table QMINQCReq	
+truncate table QMINQCReqEntry
+truncate table ICQCBill	
+truncate table QMSourceInfo
+truncate table PPOrder
+truncate table 	PPOrderEntry
+truncate table 	ICExpenses
+truncate table 	ICExpensesEntry
+truncate table 	ICInvBackup
+truncate table ICQCScheme	
+truncate table ICQCSchemeEntry
+--固定资产
+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_Contact
+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_CheckDetail20120517134445300
+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
+DELETE FROM t_Item_3003
+DELETE FROM t_Item_3004
+DELETE FROM t_Item_3005
+DELETE FROM t_Item_3006
+DELETE FROM t_Item_3009
+truncate table ICStockBill
+truncate table ICPlanAdjPrice
+truncate table POrequest
+truncate table POOrder
+truncate table POInstock
+truncate table POInstock
+truncate table ICPurchase
+truncate table  ICSale
+truncate table SEOrder
+truncate table SEOutStock
+truncate table PORFQ
+truncate table ICMO
+truncate table ICSale
+truncate table t_Voucher
+truncate table t_Voucherentry
+truncate table ICStockBill
+truncate table ICStockBillEntry
+truncate table ICPlanAdjPriEntry
+truncate table POrequestEntry
+truncate table POOrderEntry
+truncate table POInstockEntry
+truncate table ICPurchaseEntry
+truncate table ICSaleEntry
+truncate table SEOrderEntry
+truncate table SEOutStockEntry
+truncate table PORFQEntry
+truncate table ppbom
+truncate table ICSTJGBill
+truncate table ICSTJGBillEntry
+truncate table POInventory
+truncate table ICChange                                                                 
+truncate table ICChangeEntry  
+truncate table ICMOChange                                                                      
+truncate table ICMOChangeEntry
+truncate table PPBomChange                                                                     
+truncate table PPBomChangeEntry  
+truncate table PPBOMEntry   
+truncate table ICitemScrap                                                                     
+truncate table ICitemScrapEntry   
+truncate table ICMORpt                                                                         
+truncate table ICMORptEntry     
+truncate table QMReject                                                                        
+truncate table QMRejectEntry   
+truncate table ICMOConvertBill                                                                 
+truncate table ICMOConvertBillEntry   
+truncate table icinventory
+truncate table icbal
+truncate table icinvbal
+truncate table ICInvInitial
+truncate table ICShop_ItemConsumeEntry
+truncate table CBStdStdPrice
+truncate table ICQCBillEntry
+truncate table cbMaterielInfo_History
+truncate table ICMnbomChild
+truncate table POInvBal
+truncate table ICClassCheckRecords1001000
+truncate table icstockbillentry2019011501
+truncate table icstockbillentry20181120
+truncate table ICQuotePriceMtrl
+truncate table CRM_SVTrace
+truncate table t_msgList
+truncate table cbCalinfoDetail
+truncate table ICBOMChild
+truncate table ICPrintCountEntry
+truncate table ICClassCheckStatus1001000
+truncate table ICPrintCount
+truncate table t_CashFlowBal
+truncate table ICMrpResult
+truncate table t_MakeVouchTemp
+truncate table t_BaseProperty
+truncate table ICClassMCRecord1000040
+truncate table ICClassMCStatus1000040
+truncate table t_ProfitAndLoss
+truncate table t_ICItemCore
+truncate table t_ICItemPlan
+truncate table t_ICItemQuality
+truncate table t_ICItemCustom
+truncate table t_ICItemMaterial
+truncate table t_ICItemBase
+truncate table t_ICItemDesign
+truncate table t_ICItemStandard
+truncate table t_LowestBomCode
+truncate table CRM_SVAssign
+truncate table CRM_ServiceRequest
+truncate table CRM_Satisfaction
+truncate table CRM_SVProcess
+truncate table cbCostObjDetail
+truncate table ICVouchBillTranType
+truncate table ICClassCheckRecords1001001
+truncate table t_SupplyEntry
+truncate table t_Supply
+truncate table cbExpenseDistributeInfo_History
+truncate table ICShop_ItemConsume
+truncate table ICClassTableInfo_bak20080418194131
+truncate table seorderentry20190624
+truncate table seorderentry20190516
+truncate table SEOutStockEntry20190624
+truncate table ICClassCheckStatus1001001
+truncate table CRM_Fittings
+truncate table cbProductCalInfo
+truncate table cbCalInfo
+truncate table CRM_Contact
+truncate table t_ItemDetailV
+truncate table t_ItemDetail
+truncate table ICMrpInfo
+truncate table t_Balance
+delete icstockcheckprocess 
+delete icinvbackup 
+DELETE FROM  t_Item WHERE FItemID >=135
+DELETE FROM  t_Base_Emp WHERE FItemID >0
+truncate table cb_CostObj_Product
+truncate table cb_ICStockBill
+truncate table cb_ICStockBillEntry
+truncate table cbBalance
+truncate table CBCalInfo_CurData
+truncate table CBCalInfoDetail_CurData
+truncate table cbCompleteQty
+DELETE  cbCostObj WHERE FItemID NOT IN (55,56)
+truncate table CBCostObjAdjustDetailbak
+truncate table cbExpenseDistributeInfo
+truncate table cbInQty
+truncate table cbMaterielInfo
+truncate table cbProductQty
+truncate table cn_Bill
+truncate table ICbal_sean2
+truncate table ICBOM
+truncate table ICClientVer
+truncate table ICPlan_PMCDetail
+truncate table ICPlanOrderRel
+DELETE FROM  t_Account
+truncate table t_Department
+truncate table t_dev_AZ
+truncate table t_dev_AZEntry2
+truncate table t_dev_AZSQ
+truncate table t_dev_AZSQEntry2
+truncate table t_dev_AZZF
+truncate table t_dev_AZZFEntry2
+truncate table t_dev_freight
+truncate table t_dev_freightEntry2
+truncate table t_dev_TC
+truncate table t_dev_TCEntry2
+truncate table t_dev_TCPay
+truncate table t_dev_TCPayEntry2
+truncate table t_dev_ZX
+truncate table t_dev_ZXEntry2
+truncate table t_dev_ZXSQ
+truncate table t_dev_ZXSQEntry2
+truncate table t_dev_ZXZF
+truncate table t_dev_ZXZFEntry2
+truncate table t_LockStock
+truncate table t_Organization
+truncate table t_Stock
+truncate table t_Supplier
+DELETE FROM ICHookRelations
+DELETE FROM cbWMaterielInfo
+DELETE FROM cbWCalinfoDetail
+DELETE FROM cbCostObjCheck
+DELETE FROM ICQuotePrice
+DELETE FROM cbWasterCostObjInfo
+DELETE FROM cbCostVoucher
+DELETE FROM CBCostExpenseInfo
+DELETE FROM ICSubContract
+DELETE FROM dbo.ICSubContractEntry 
+DELETE FROM ICSerialFlow
+--设置 启用期间,当前期间,这里几月份开始用就设置为几月份
+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'           
+--重建索引
+DECLARE @DBCCString NVARCHAR(1000)
+DECLARE @TableName VARCHAR(100) 
+DECLARE Cur_Index CURSOR FOR  
+SELECT Name AS TblName  FROM sysobjects   WHERE xType='U'  ORDER BY TblName FOR READ ONLY 
+OPEN Cur_Index 
+FETCH NEXT FROM Cur_Index INTO @TableName 
+
+WHILE @@FETCH_STATUS=0 
+BEGIN  
+PRINT '重建表' + @TableName +'的索引........Start!'  
+SET @DBCCString = 'DBCC DBREINDEX(@TblName,'''')WITH NO_INFOMSGS'  
+EXEC SP_EXECUTESQL  @DBCCString,     N'@TblName VARCHAR(100)',     @TableName  
+PRINT '重建表' + @TableName +'的索引........END!' 
+FETCH NEXT FROM Cur_Index  INTO @TableName 
+END 
+CLOSE Cur_Index 
+DEALLOCATE Cur_Index 
+PRINT '操作完成!' 
+--收缩数据库
+DELETE FROM t_SuspendWorkPushMain
+DELETE FROM t_SuspendWorkPushDetail
+DELETE FROM ICClassMCTaskCenter
\ No newline at end of file
diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.17.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.17.sql"
new file mode 100644
index 0000000..1c909f0
--- /dev/null
+++ "b/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.17.sql"
@@ -0,0 +1,21 @@
+--销售合同
+truncate table  t_RPContract
+truncate table  t_RPContractDetail
+truncate table  t_rpContractEntry
+--    订单
+truncate table  dbo.SEOrder
+truncate table  dbo.SEOrderEntry
+--发货通知,退货通知 
+truncate table  dbo.SEOutStock
+truncate table  dbo.SEOutStockEntry
+--销售发票
+truncate table  dbo.ICSale
+truncate table  dbo.ICSaleEntry
+DELETE  FROM dbo.t_RP_Contact WHERE FType =3
+--销售出库,库存类的单据都在一张表,删除所有库存单据后,需要删除存货核算余额表和即时库存表
+ALTER TABLE ICStockBill DISABLE TRIGGER ALL
+DELETE  FROM dbo.ICStockBill WHERE FTranType IN (21)
+DELETE  FROM dbo.ICStockBillEntry WHERE FInterID NOT IN (SELECT FInterID FROM dbo.ICStockBill)
+ALTER TABLE ICStockBill ENABLE TRIGGER ALL
+--收款单,与应收系统相关,需确认后再删除,删除后需要删除余额,建议应收应付一起处理
+--需全部删除后,需更新启用期间后账套才能开始使用
\ No newline at end of file
diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2563.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2563.sql"
new file mode 100644
index 0000000..f56fd46
--- /dev/null
+++ "b/\345\210\240\351\231\244\346\225\260\346\215\2563.sql"
@@ -0,0 +1,65 @@
+--质量管理
+TRUNCATE TABLE ICQCBill
+TRUNCATE TABLE ICQCBillEntry
+truncate table  dbo.QMReject
+truncate table  dbo.QMRejectEntry
+truncate table  QMSaleCkRequest
+truncate table  QMSaleCkRequestEntry
+truncate table  QMINQCReq
+truncate table  QMINQCReqEntry
+truncate table  QMOtCkRequest
+truncate table  QMOtCkRequestEntry
+
+--物料需求计划
+truncate table ICMrpInfo
+truncate table ICMrpResult
+truncate table ICMrpDestBills
+                                                     
+--生产管理
+DELETE FROM ICSerialFlow
+truncate table ICBOM
+truncate table ICClientVer
+truncate table ICPlan_PMCDetail
+truncate table ICPlanOrderRel
+truncate table ICBOMChild
+truncate table ICShop_ItemConsumeEntry
+truncate table ICMOConvertBill
+truncate table ICMOConvertBillEntry
+truncate table PPBomChange
+truncate table PPBomChangeEntry
+truncate table PPBOMEntry
+truncate table ICitemScrap
+truncate table ICitemScrapEntry
+truncate table ICMORpt
+truncate table ICMORptEntry
+truncate table ppbom
+truncate table dbo.PPBOMEntry
+truncate table ICChange
+truncate table ICChangeEntry
+truncate table ICMOChange
+truncate table ICMOChangeEntry
+truncate table ICMO
+
+--采购管理
+truncate table dbo.PORequest
+truncate table dbo.PORequestEntry
+truncate table dbo.POInStock
+truncate table dbo.POInStockEntry
+truncate table dbo.ICExpenses
+truncate table dbo.ICExpensesEntry
+   
+--委外加工
+
+--销售管理
+truncate table t_dev_freight
+truncate table t_dev_freightEntry2
+
+--仓库管理
+truncate table ICSTJGBill
+truncate table ICSTJGBillEntry
+  
+--需全部删除后,需更新启用期间后账套才能开始使用
+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='ic' and FKey='startperiod'
+update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='startyear'
\ No newline at end of file
diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2564.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2564.sql"
new file mode 100644
index 0000000..88d7dc9
--- /dev/null
+++ "b/\345\210\240\351\231\244\346\225\260\346\215\2564.sql"
@@ -0,0 +1,89 @@
+--固定资产
+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'
\ No newline at end of file
diff --git "a/\350\264\242\345\212\241\344\274\232\350\256\241.conf" "b/\350\264\242\345\212\241\344\274\232\350\256\241.conf"
new file mode 100644
index 0000000..58a8241
--- /dev/null
+++ "b/\350\264\242\345\212\241\344\274\232\350\256\241.conf"
@@ -0,0 +1,108 @@
+璐㈠姟浼氳
+    鎬昏处
+        鍑瘉澶勭悊
+            01002 鍑瘉鏌ヨ
+            01004 鍑瘉姹囨��
+        璐︾翱
+            01009 鎬诲垎绫昏处
+            1010 鏄庣粏鍒嗙被璐�
+            01013 澶氭爮璐�
+            1014 鏍哥畻椤圭洰鍒嗙被鎬昏处
+        璐㈠姟鎶ヨ〃
+            01016 绉戠洰浣欓琛�
+            01017 璇曠畻骞宠 琛�
+            01018 鏃ユ姤琛ㄦ煡璇�
+            01024 鏍哥畻椤圭洰涓庣鐩粍鍚堣〃
+    鎶ヨ〃
+
+    鍥哄畾璧勪骇绠$悊
+        涓氬姟澶勭悊
+            04014 鍗$墖鏌ヨ
+        缁熻鎶ヨ〃
+            04018 璧勪骇娓呭崟
+            04019 鍥哄畾璧勪骇浠峰�煎彉鍔ㄨ〃
+            04020 鏁伴噺缁熻琛�
+            04021 鍒版湡鎻愮ず琛�
+        绠$悊鎶ヨ〃
+            04025 鍥哄畾璧勪骇鍙樺姩鍙婄粨瀛樿〃
+            04027 鍥哄畾璧勪骇鍙婄疮璁℃姌鏃ф槑缁嗚处
+            04030 璧勪骇鏋勬垚琛�
+            04031 鍙樺姩鍘嗗彶璁板綍琛�
+        鏈熸湯澶勭悊
+            04035 鎶樻棫绠$悊
+            04038 鑷姩瀵硅处
+        鍑瘉绠$悊
+            04043 鍑瘉鏌ヨ
+
+    
+    搴旀敹娆剧鐞�
+        鍏朵粬搴旀敹鍗�
+            05009 鍏朵粬搴旀敹鍗�-缁存姢
+        鏀舵
+            05012 鏀舵鍗�-缁存姢
+        绁ㄦ嵁澶勭悊
+            05016 搴旀敹绁ㄦ嵁-缁存姢
+        缁撶畻
+            05022 搴旀敹娆炬牳閿�-鍒版缁撶畻
+            05023 搴旀敹娆炬牳閿�-棰勬敹娆惧啿搴旀敹娆�
+            05024 搴旀敹娆炬牳閿�-搴旀敹娆惧啿搴斾粯娆�
+            05025 搴旀敹娆炬牳閿�-搴旀敹娆捐浆閿�
+            05028 搴旀敹娆炬牳閿�-鏀舵鍐蹭粯娆�
+            05029 鏍搁攢鏃ュ織-缁存姢
+        鍑瘉澶勭悊
+            05031 鍑瘉-缁存姢
+        鍒嗘瀽
+            05037 璐﹂緞鍒嗘瀽
+            05039 娆犳鍒嗘瀽
+            05040 鍧忚处鍒嗘瀽
+            05041 鍥炴鍒嗘瀽
+            05042 鏀舵棰勬祴
+        璐﹁〃
+            05047 搴旀敹娆炬槑缁嗚〃
+            05048 搴旀敹娆炬眹鎬昏〃
+            05049 寰�鏉ュ璐�
+            05053 搴旀敹娆捐秼鍔垮垎鏋愯〃
+            05054 鏈堢粨鍗曡繛鎵�
+        鍚堝悓
+            05056 鍚堝悓璧勬枡-缁存姢
+            05057 鍚堝悓閲戦鎵ц鏄庣粏琛�
+            05058 鍚堝悓鎵ц鎯呭喌姹囨�昏〃
+            05059 鍚堝悓閲戦鎵ц姹囨�昏〃
+            05060 鍚堝悓鍒版湡娆鹃」鍒楄〃
+        鏈熸湯澶勭悊
+            05067 鏈熸湯鎬婚瀵硅处
+            05068 鏈熸湯绉戠洰瀵硅处
+        閿�鍞璐︽敹娆惧钩鍙�
+            05064 閿�鍞敹娆惧钩鍙�
+
+    搴斾粯娆剧鐞�
+        浠樻
+            06012 浠樻鍗�-缁存姢
+        缁撶畻
+            06018 搴斾粯娆炬牳閿�-浠樻缁撶畻
+            06019 搴斾粯娆炬牳閿�-棰勪粯娆惧啿搴斾粯娆�
+            06020 搴斾粯娆炬牳閿�-搴斾粯娆惧啿搴旀敹娆�
+            06021 搴斾粯娆炬牳閿�-搴斾粯娆捐浆閿�
+            06022 搴斾粯娆炬牳閿�-棰勪粯娆捐浆閿�
+            06023 搴斾粯娆炬牳閿�-棰勪粯娆惧啿棰勬敹娆�
+            06024 搴斾粯娆炬牳閿�-浠樻鍐叉敹娆�
+            06025 鏍搁攢鏃ュ織-缁存姢
+        鍑瘉澶勭悊
+            06027 鍑瘉-缁存姢
+        鍒嗘瀽
+            06028 璐﹂緞鍒嗘瀽
+            06029 浠樻鍒嗘瀽
+            06030 浠樻棰勬祴
+        璐﹁〃
+            06032 搴斾粯娆炬眹鎬昏〃
+            06037 搴斾粯娆捐秼鍔垮垎鏋愯〃
+            06038 鏈堢粨鍗曡繛鎵�
+        浠樻鐢宠鍗�
+            06046 浠樻鐢宠鍗�-缁存姢
+
+    鐜伴噾娴侀噺琛�
+        鐜伴噾娴侀噺琛�
+            01027 T鍨嬭处鎴�
+            01028 闄勮〃椤圭洰
+            01030 鐜伴噾娴侀噺琛�
+            01031 鐜伴噾娴侀噺鏌ヨ
\ No newline at end of file

--
Gitblit v1.10.0