流程实例表数据清理
--1 查应收单内码以便第二部更新影视但发票数据金额字段
select FENTRYID, FIVALLAMOUNTFOR,FBUYIVBASICQTY,FBUYIVQTY from t_AR_receivableEntry
where FID in(select fid from T_AR_RECEIVABLE where fbillno='AR00002971')
--2 更新应收单发票数量跟金额
update t_AR_receivableEntry set FIVALLAMOUNTFOR=0,FBUYIVBASICQTY=0,FBUYIVQTY=0 where FENTRYID=106062;
select *from t_AR_receivableEntry
select * from T_IV_SALESIC where fbillno in('SVINV00000009',
'SVINV00000008',
'SVINV00000007',
'SVINV00000006')
--查询发票使用反写规则的记录内码
select *
from t_bf_instancesnap where FCID like 'AR_receivable%'
--删除使用了反写规则的数据记录,让其可以正常删除
--delete t_bf_instancesnap where FCID='IV_SALESIC,FSALESICENTRY_Link,100019'
select * from t_bf_instancesnap where FCID='IV_SALESIC,FSALESICENTRY_Link,100016'
select * from t_bf_instancesnap where FCID='IV_SALESIC,FSALESICENTRY_Link,100017'
select * from t_bf_instancesnap where FCID='IV_SALESIC,FSALESICENTRY_Link,100020'
select * from t_bf_instancesnap where FCID='IV_SALESIC,FSALESICENTRY_Link,100019'
--select *info t_bf_instancesnap_202401010
--select*from T_BF_INSTAMOUNTBACKUP
select *From T_bf_instanceentry where FTTABLENAME='T_IV_SALESICENTRY'
select *From T_bf_instanceentry where FTTABLENAME='T_IV_SALESICENTRY' and FSID=(select FENTRYID from t_AR_receivableEntry
where FID in(select fid from T_AR_RECEIVABLE where fbillno='AR00002968'))
--delete T_bf_instanceentry where FTTABLENAME='T_IV_SALESICENTRY' and FSID=(select FENTRYID from t_AR_receivableEntry
--where FID in(select fid from T_AR_RECEIVABLE where fbillno='AR00002968'))
SELECT * INTO T_bf_instanceentry_20240110 FROM T_bf_instanceentry;
流程实例表数据清理
本文2024-09-16 18:28:06发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-22338.html