EAS 账套拆分注意事项原创
EAS Cloud-知识分享
金蝶云社区-zhxc95
zhxc95
3人赞赏了该文章 399次浏览 未经作者许可，禁止转载编辑于2022年08月26日 10:40:58

1、测试执行拆分工具，会发现会卡在某些表，记录好并在正式拆分前提前处理；

2、大表备份与处理；

3、正式执行拆分工具；


ps：拆分工具选择保留组织时只能选择实体组织，直接执行工具会导致部分不应该删除的虚体组织被删除；需要在选完保留组织后，收到在保留组织的表中插入全部要保留的组织id，然后再执行工具；



--temporg 以财务组织创建的临时表，里面储存的是FID一个字段

DROP TABLE temporg;

CREATE TABLE temporg AS SELECT

fid 

FROM

T_ORG_BaseUnit 

WHERE

flongnumber LIKE '%!01.02.02.01%' 

OR flongnumber LIKE '%!01.02.02.02%' 

OR flongnumber LIKE '%!01.02.02.03%' 

OR flongnumber LIKE '%!01.02.02.04%' 

OR flongnumber LIKE '%!01.02.03.03.01%' 

OR flongnumber LIKE '%!01.02.03.03.02%' 

OR flongnumber LIKE '%!01.02.02%' 

OR flongnumber LIKE '%!01.02.03.03%';

--费用类型科目映射

DELETE FROM T_BC_ExpenseTypeSubjectMapping where FCompanyID in (select fid from temporg);

--费用类型核算项目映射

DELETE FROM T_BC_ExpenseTypeAsstActType where FCompanyID in (select fid from temporg);


--费用类型

Delete from T_BC_ExpenseTypeEntry where FParentId in (select fid from T_BC_ExpenseType where FCompanyID in (select fid from temporg));

Delete from T_BC_ExpenseType where FCompanyID in (select fid from temporg);


--业务类别   

Delete from T_BC_OperationType where FCompanyID in (select fid from temporg);

--业务类别科目映射

DELETE FROM T_BC_OperationTypeSubject WHERE FCompanyID in (select fid from temporg);

--业务类别分录

DELETE FROM T_BC_OperationTypeCCEntry WHERE FcompanyId in (select fid from temporg);


--收款信息 没公司过滤全保留 T_BC_CollectionAccount


--员工额度表 

Delete from T_BC_AccountLimit where  FCompanyOrgUnitID in (select fid from temporg);


--额度控制 没公司过滤全保留 T_BC_BudgetControl 


--代理报销 

Delete from T_BC_ProxyReimburse where FCompanyID in (select fid from temporg);


--报销级别 

Delete from T_BC_ReimburseLevel where FCompanyID in (select fid from temporg);


--额度设置

Delete from T_BC_REIMBURSELEVELSETTING where FCompanyOrgUnitID in (select fid from temporg);


--费用申请单

DELETE FROM T_BC_OtherExpenseBillEntry WHERE fbillid in(SELECT fid FROM T_BC_OtherExpenseBill  WHERE FAPPLIERCOMPANYID in (select fid from temporg));  --费用申请单分录

DELETE FROM T_BC_OtherExpenseBill  WHERE FAPPLIERCOMPANYID in (select fid from temporg);--费用申请单表头


--出差申请单

DELETE FROM T_BC_EvectionReqBillEntry where fbillid in(SELECT fid FROM T_BC_EvectionReqBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));--出差申请单分录

DELETE FROM T_BC_EvectionReqBill WHERE FAPPLIERCOMPANYID in (select fid from temporg);--出差申请单表头


--费用报销单

DELETE FROM T_BC_BizABAR WHERE FParentID  in (select fid from T_BC_BizAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));    --费用报销单记账记录表

DELETE from T_BC_BizABLCE where FParentID  in (select fid from T_BC_BizAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));  --费用报销单借款核销表

DELETE FROM T_BC_BIZABRCE WHERE  FParentID  in (select fid from T_BC_BizAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg)); --费用报销单申请核销表

DELETE FROM T_BC_BizAccountBCE WHERE FBillID in (select fid from T_BC_BizAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg)); --费用报销单多收款人分录

DELETE FROM T_BC_BizAccountBillEntry WHERE fbillid in (select fid from T_BC_BizAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));  --费用报销单分录

DELETE from T_BC_BizAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg);--费用报销单表头


--对公报销单

DELETE FROM T_BC_BizOABAR WHERE FParentID  in (select fid from T_BC_BizAccountOutBill WHERE FAPPLIERCOMPANYID in (select fid from temporg)); --对公费用报销单记账记录表

DELETE from T_BC_BIZAOBLCE where FParentID  in (select fid from T_BC_BizAccountOutBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));  --对公费用报销单借款核销表

DELETE FROM T_BC_BIZAOBRCE WHERE  FParentID  in (select fid from T_BC_BizAccountOutBill WHERE FAPPLIERCOMPANYID in (select fid from temporg)); --对公费用报销单申请核销表

DELETE FROM T_BC_BIZAOBAE WHERE FBillID in (select fid from T_BC_BizAccountOutBill WHERE FAPPLIERCOMPANYID in (select fid from temporg)); --对公费用报销单多收款人分录

DELETE FROM T_BC_BizAccountOutBillEntry WHERE  fbillid in (select fid from T_BC_BizAccountOutBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));  --对公费用报销单分录

DELETE from T_BC_BizAccountOutBill WHERE FAPPLIERCOMPANYID in (select fid from temporg);-- 对公费用报销单表头


--差旅报销单

DELETE FROM T_BC_TravelABAR WHERE FParentID in (select fid from T_BC_TravelAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));--差旅报销单记账凭证记录表

DELETE FROM T_BC_TravelABLCE WHERE FParentID in (select fid from T_BC_TravelAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));   --差旅报销单借款核销表

DELETE FROM T_BC_TRAVELABRCE WHERE FParentID in (select fid from T_BC_TravelAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg)); --差旅费报销单申请核销表

DELETE FROM T_BC_TravelAccountBCE WHERE FBillID in (select fid from T_BC_TravelAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg)); --差旅费报销单多收款人分录

DELETE FROM T_BC_TravelAccountBillEntry WHERE  fbillid in (select fid from T_BC_TravelAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));--差旅报销单分录

DELETE from T_BC_TravelAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg);   -- 差旅报销单表头



--物品采购报销单

DELETE FROM T_BC_DailyPABAR WHERE FParentID in (select fid from T_BC_DailyPurchaseAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));--差旅报销单记账凭证记录表

DELETE FROM T_BC_DAILYPABLCE WHERE FParentID in (select fid from T_BC_DailyPurchaseAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));   --物品采购报销单借款核销表

DELETE FROM T_BC_DAILYPABRCE WHERE FPARENTID in (select fid from T_BC_DailyPurchaseAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg)); --物品采购报销单申请核销表

DELETE FROM T_BC_DailyPurchaseAccontEntry WHERE  fbillid in (select fid from T_BC_DailyPurchaseAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));--物品采购报销单分录

DELETE from T_BC_DailyPurchaseAccountBill WHERE FAPPLIERCOMPANYID in (select fid from temporg);   -- 物品采购报销单表头


--借款单

DELETE FROM T_BC_DailyLoanBAE where FBillID in (select fid from T_BC_DailyLoanBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));--借款单多收款人分录

DELETE FROM T_BC_DailyLBRCE where FParentID in (select fid from T_BC_DailyLoanBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));--借款单申请核销表

DELETE FROM T_BC_DailyLoanBillEntry WHERE fbillid in (select fid from T_BC_DailyLoanBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));  --借款单分录

DELETE from T_BC_DailyLoanBill WHERE FAPPLIERCOMPANYID in (select fid from temporg);  --借款单表头


--出差借款单

DELETE FROM T_BC_Evectionlbrce where FParentID in (select fid from T_BC_EvectionLoanBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));--出差借款单申请核销表

DELETE FROM T_BC_EvectionLoanBillEntry WHERE FBillID in (select fid from T_BC_EvectionLoanBill WHERE FAPPLIERCOMPANYID  in (select fid from temporg) ) ;--出差借款单分录

DELETE FROM T_BC_EvectionLoanBill WHERE FAPPLIERCOMPANYID  in (select fid from temporg); -- 出差借款单表头


--还款单

DELETE FROM T_BC_RePaymentBillEntry WHERE FPARENTID in (select fid from T_BC_RePaymentBill WHERE FAPPLIERCOMPANYID in (select fid from temporg));--还款单分录

DELETE from T_BC_RePaymentBill WHERE FAPPLIERCOMPANYID in (select fid from temporg);--还款单表头


赞 3

推荐阅读

EAS集成平台注意事项

在创建视图的时候，一定要注意，系统会按照ENTRYPK向下的数据作为单据明细。所以ENTRYPK部分的字段不要放在单据头涉及到的字段，不然有可能在生成单据或基础 …

    文章

    451

EAS配置集群注意事项

问题： 看到好多人在配置EAS的服务端时，配置了集群，但是实例又只配置两个，这样的配置其实完全没有作用，甚至还不如不配置。 正确的配置是： 当内存32G以上，可 …

    文章

    566

EAS Cloud更换JDK注意事项

一、概述 更换JDK可以分为 更换 同类型不同版本的JDK和 更换 不同类型的 JDK 两种情况 如果是 更换 同类型不同版本的JDK, 只需更改eas\ser …

    知识

    570