EAS 账套拆分注意事项
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);--还款单表头
EAS 账套拆分注意事项
本文2024-09-16 22:13:46发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-46763.html