流程实例表数据清理

--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;