金蝶云星空-清除单据关联关系

select 'T_CN_PAYAPPLY' AS tablename, COUNT(*) as rows from T_CN_PAYAPPLY;
select 'T_CN_PAYAPPLYENTRY' AS tablename, COUNT(*) as rows from T_CN_PAYAPPLYENTRY;
select 'T_CN_PAYAPPLYENTRY_LK' AS tablename, COUNT(*) as rows from T_CN_PAYAPPLYENTRY_LK;

select * from T_CN_PAYAPPLY;
select * from T_META_OBJECTTYPE_L where FNAME like '%付款申请单%'
select * from T_BF_WRITEBACKRULE where FTARGETFORMID = 'CN_PAYAPPLY';
select * from T_BF_TABLEDEFINE where FFORMID = 'CN_PAYAPPLY'

select * from T_BF_INSTANCESNAP where FCID like '%CN_PAYAPPLY%'
-- 删除业务流程数据
delete from T_BF_INSTANCEENTRY where FTTABLENAME = 'T_CN_PAYAPPLYENTRY' and FTID IN ('146001',
'136505',
'142001',
'150505',
'143524',
'142503',
'142502',
'133512')

DELETE FROM T_BF_INSTANCESNAP WHERE FCID IN ('CN_PAYAPPLY,FPAYAPPLYENTRY_Link,146001',
'CN_PAYAPPLY,FPAYAPPLYENTRY_Link,136505',
'CN_PAYAPPLY,FPAYAPPLYENTRY_Link,142001',
'CN_PAYAPPLY,FPAYAPPLYENTRY_Link,150505',
'CN_PAYAPPLY,FPAYAPPLYENTRY_Link,143524',
'CN_PAYAPPLY,FPAYAPPLYENTRY_Link,142503',
'CN_PAYAPPLY,FPAYAPPLYENTRY_Link,142502',
'CN_PAYAPPLY,FPAYAPPLYENTRY_Link,133512');

DELETE T_CN_PAYAPPLYENTRY_LK WHERE FENTRYID IN ('146001',
'136505',
'142001',
'150505',
'143524',
'142503',
'142502',
'133512');