文章分类 - PS
ERP-PS业务相关SQL
摘要：select * from SCPTINFO WHERE SCPTINFO_ZHM NOT IN(SELECT isnull(组合码,'') FROM ningdaMES.DBO.车间配送明细) and SCPTINFO_ZHM like '%M1' and SCPTINFO_ZHM NOT lik
阅读全文
摘要：select * from ningdaMES.dbo.车间条码 where 条码值='2309088165M1' select * from ningdaMES.dbo.车间配送明细 where 组合码='2309088165M1' SELECT * FROM SCPTINFO WHERE SCP
阅读全文
摘要：select * from PSKC WHERE 零件代号='LY0628030008' AND 仓库编号 ='01006' and (零件代号+批次号) not in( select 零件代号+批次号 from V_配托未收入 where 零件代号='LY0628030008')
阅读全文
摘要：CREATE NONCLUSTERED INDEX KCCKD2_LSBH_1 ON lc0019999.KCCKD2 ( KCCKD2_LSBH, KCCKD2_WLBH, KCCKD2_PCH , KCCKD2_HWBH , KCCKD2_WLZT , KCCKD2_WLBZ , KCCKD2_
阅读全文
摘要：检查车间收入有，ERP遗漏单据 select * FROM ningdaMES.DBO.车间收入where 生产线代码<>'H' and 产品代号<>'积压报废'AND 组合码 not in(select KCYXZ1_C2 from KCYXZ1 where KCYXZ1_YRCK <>'0203
阅读全文
摘要：select * from CGDD1 SELECT * FROM CGFHD2 WHERE CGFHD2_LSBH+CGFHD2_FLBH IN(SELECT CGDHD1_C1 FROM CGDHD1) AND CGFHD2_ZT='ZZ' SELECT CGDHD2_CGDDLS,CGDHD2
阅读全文
摘要：SELECT CGDHD2_SSSL, CGDHD2_RKSL,CGDHD2_THSL,KCRKD2_SSSL, * FROM CGDHD2 , (select KCRKD2_DHLS,KCRKD2_DHFL,KCRKD2_WLBH,sum(KCRKD2_SSSL) KCRKD2_SSSL from
阅读全文
摘要：更新限额领料单的领用班组 update lc0019999.KCXED1 SET KCXED1_C3=生产线代码 FROM ningdaMES.dbo.采购领料单主 where KCXED1_SJDH=条码值 and isnull(KCXED1_C3,'')='' 更新生产领料单领用班组 updat
阅读全文
摘要：select * from KCRKD1 ,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH --AND KCRKD1_SJDH='G240427000063' AND kcrkd1_lbbh='02' AND KCRKD2_TSKC='Z' select * from KC
阅读全文
摘要：SELECT * FROM CGFHD1(nolock), CGFHD2(nolock), CGDD1(nolock), CGDD2(nolock), LSWLZD(nolock), ZWWLDW(nolock) WHERE CGFHD1_LSBH = CGFHD2_LSBH AND CGDD1_L
阅读全文
摘要：INSERT INTO KCRKD2(KCRKD2_PJLX,KCRKD2_LSBH,KCRKD2_FLBH,KCRKD2_WLBH,KCRKD2_TSKC,KCRKD2_XGDX,KCRKD2_DDLS,KCRKD2_DDFL, KCRKD2_SSSL,KCRKD2_DJ,KCRKD2_JE,KC
阅读全文
摘要：检查车间收入是否有在PS有遗漏 select 组合码,生产线代码 into #SRZHM from 车间收入 WHERE 组合码 like '%M1' AND CONVERT(date,操作时间)>'2024-02-25' AND 零件名称 <>'减震油' group by 组合码,生产线代码 se
阅读全文
