1 问题描述

客户出现项目启动通用报价单数据不正确，用户录入或者下推过来的标的数据异常了，导致定标数据不正确

2 解决方法

• 1、后台查询原始标的数据

  a)查询项目启动id: select fid from t_src_project where fbillno ='xxxx';

  b)查询通用报价单组件fid : select fid from t_src_purlist where fentitykey='src_purlist_stand' and fparentid='项目启动id';

  c)查询通用报价单分录数据：select * from t_src_purlistentry where fid = '报价单组件fid';

• 2、查询原始标的数据还存不存在，如果能查出数据则表示数据不存在了

  SELECT 报价单组件fid,项目启动id,'A', fpurlistid,fmaterialid,fmaterialnane,fmaterialmodel,funitid,fqty,fseq,fpackageid,fpurlistid,fturns from t_src_purlistentry where fprojectid = 项目启动id  and fid != 报价单组件fid and fpurlistid NOT IN(select fentryid from t_src_purlistentry) group by fpurlistid,fmaterialid,fmaterialnane,fmaterialmodel,funitid,fqty,fseq,fpackageid,fpurlistid,fturns;

• 3、如果发现查询的数据是不正确，异常的数据可用如下sql修复数据

  --清除脏数据

  DELETE FROM t_src_purlistentry where fid = 报价单组件fid;

  --重新生成原始标的通用报价单数据
  

  INSERT INTO t_src_purlistentry(fid,fprojectid,fentrystatus,fentryid,fmaterialid,fmaterialnane,fmaterialmodel,funitid,fqty,fseq,fpackageid,fpurlistid,fturns)  SELECT 报价单组件fid,项目启动id,'A', fpurlistid,fmaterialid,fmaterialnane,fmaterialmodel,funitid,fqty,fseq,fpackageid,fpurlistid,fturns from t_src_purlistentry where fprojectid = 项目启动id  and fid != 报价单组件fid and fpurlistid NOT IN(select fentryid from t_src_purlistentry) group by fpurlistid,fmaterialid,fmaterialnane,fmaterialmodel,funitid,fqty,fseq,fpackageid,fpurlistid,fturns;
  

  
  

3 适用版本

示例：金蝶云·星瀚V6.0.1及以上。