PS - 文章分类 - CelonY

发票问题派发和还原

摘要：检查入库单是否有被参照过 SELECT * FROM A_CGFPCW where rkdbh in(SELECT CGFP2_RKDBH FROM CGFP1,CGFP2 WHERE CGFP1_LSBH=CGFP2_LSBH ) --查询入库单情况 SELECT KCRKD1_FPHX,KCRK 阅读全文

posted @ 2025-09-15 16:23 CelonY 阅读(3) 评论(0) 推荐(0)

采购预算

摘要：产品分解select * into 采购预算202620250901 from ( select 1 序号,'物资采购部' 预算部门,产品代号,产品代号+'@'+产品名称产品名称,零件代号,零件代号+'@'+零件名称零件名称,sum(生产定额) 生产定额 from xhbom where 物料来阅读全文

posted @ 2025-09-02 10:19 CelonY 阅读(4) 评论(0) 推荐(0)

联查TDZ和发运单

摘要：select KCTZD1_SJDH 通知单单号,KCYXZ1_SJDH 发运单单号,KCTZD1_C10 计划到货日期, KCYXZ1_DJRQ 发货单日期,KCTZD1_C6 到货地点,KCTZD1_YRCK 移入仓库,KCTZD1_YCCK 移出仓库,KCTZD1_BZ 通知单备注,KCYXZ 阅读全文

posted @ 2025-07-24 18:36 CelonY 阅读(3) 评论(0) 推荐(0)

处理采购价格表重复

摘要：select case CGJGB2_JGLX WHEN 1 THEN '合同价' WHEN 0 then '临时价' else '其它单价' END 价格类型, CGJGB1_ZDRQ 单据日期,CGJGB1_DJBH 单据编号,CGJGB1_LSBH 流水编号,CGJGB1_DWBH 单位编码, 阅读全文

posted @ 2025-05-29 17:42 CelonY 阅读(2) 评论(0) 推荐(0)

ERP-PS记账处理步骤

摘要：记账处理步骤1 JXC_CKYE_SSYE_NJ修改还原USE [cwbase3]GOALTER VIEW [lc0019999].[JXC_CKYE_SSYE_NJ] (FF_WLBH,FF_CKBH,FF_PCH,FF_HWBH,FF_WLZT,FF_WLBZ,FF_TSKC,FF_XGDX,F 阅读全文

posted @ 2025-05-22 13:23 CelonY 阅读(2) 评论(0) 推荐(0)

ERP-PS每月定时更新临时KCCKYE

摘要：drop table KCCKYE_NJ_LS SELECT KCCKYE_WLBH,KCCKYE_CKBH,KCCKYE_PCH,KCCKYE_HWBH,KCCKYE_WLZT,KCCKYE_WLBZ, KCCKYE_TSKC,KCCKYE_XGDX,KCCKYE_F1,KCCKYE_F2,KCC 阅读全文

posted @ 2025-05-13 17:35 CelonY 阅读(10) 评论(0) 推荐(0)

采购价格表核查合同价是否重复

摘要：select CGJGB2_WLBH,CGJGB1_DWBH,CGJGB2_KSRQ,CGJGB2_JSRQ,CGJGB1_DJZT from CGJGB1,CGJGB2 where CGJGB1_LSBH=CGJGB2_LSBH and CGJGB1_DJZT=1 group by CGJGB2_ 阅读全文

posted @ 2025-05-09 17:59 CelonY 阅读(3) 评论(0) 推荐(0)

对比移库单的派生单据是否有问题

摘要：--检查转储单 select KCRKD1_SJDH,SUM(KCRKD2_SSSL) KCRKD2_SSSL INTO #KCRKD FROM KCRKD1,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH AND KCRKD1_SJDH LIKE '@A%' GROUP 阅读全文

posted @ 2025-04-30 14:42 CelonY 阅读(2) 评论(0) 推荐(0)

机加方法变更处理

摘要：select * from KCRKD1,KCRKD2,LSWLZD WHERE KCRKD1_LSBH=KCRKD2_LSBH and KCRKD2_WLBH=LSWLZD_WLBH and LSWLZD_JJFF=6 and KCRKD2_JHDJ=0 and KCRKD2_WLBH='3B93 阅读全文

posted @ 2025-04-29 18:57 CelonY 阅读(4) 评论(0) 推荐(0)

库存存货对比

摘要：select a.KCCKYE_CKBH,a.KCCKYE_WLBH,a.KCCKYE_PCH,a.KCCKYE_F1,a.KCCKYE_TSKC,a.KCCKYE_HWBH,a.KCCKYE_XGDX,a.KCCKYE_SLYE,b.KCWLYE_SLYE from ( select * from 阅读全文

posted @ 2025-04-27 18:19 CelonY 阅读(2) 评论(0) 推荐(0)

清理PS条码库SCPTINFO

摘要：SELECT COUNT(*) FROM SCPTINFO SELECT * INTO SCPTINFO2024 FROM SCPTINFO WHERE 1=0 INSERT INTO SCPTINFO2024(SCPTINFO_ID,SCPTINFO_ZHM,SCPTINFO_WLBH,SCPTI 阅读全文

posted @ 2025-04-01 10:22 CelonY 阅读(4) 评论(0) 推荐(0)

检查生成条码是否有问题

摘要：select * from SCPTINFO WHERE SCPTINFO_ZHM NOT IN(SELECT isnull(组合码,'') FROM ningdaMES.DBO.车间配送明细) and SCPTINFO_ZHM like '%M1' and SCPTINFO_ZHM NOT lik 阅读全文

posted @ 2025-02-25 16:59 CelonY 阅读(3) 评论(0) 推荐(0)

核查处理车间配送掉数据清空

摘要：select * from ningdaMES.dbo.车间条码 where 条码值='2309088165M1' select * from ningdaMES.dbo.车间配送明细 where 组合码='2309088165M1' SELECT * FROM SCPTINFO WHERE SCP 阅读全文

posted @ 2025-01-17 14:29 CelonY 阅读(1) 评论(0) 推荐(0)

检查配托未扫描批次是否在库存中存在（用于修正批次混乱使用）

摘要：select * from PSKC WHERE 零件代号='LY0628030008' AND 仓库编号 ='01006' and (零件代号+批次号) not in( select 零件代号+批次号 from V_配托未收入 where 零件代号='LY0628030008') 阅读全文

posted @ 2024-10-30 20:39 CelonY 阅读(4) 评论(0) 推荐(0)

浪潮数据库优化

摘要：CREATE NONCLUSTERED INDEX KCCKD2_LSBH_1 ON lc0019999.KCCKD2 ( KCCKD2_LSBH, KCCKD2_WLBH, KCCKD2_PCH , KCCKD2_HWBH , KCCKD2_WLZT , KCCKD2_WLBZ , KCCKD2_ 阅读全文

posted @ 2024-10-12 17:59 CelonY 阅读(5) 评论(0) 推荐(0)

车间收入多写排查

摘要：检查车间收入有，ERP遗漏单据 select * FROM ningdaMES.DBO.车间收入where 生产线代码<>'H' and 产品代号<>'积压报废'AND 组合码 not in(select KCYXZ1_C2 from KCYXZ1 where KCYXZ1_YRCK <>'0203 阅读全文

posted @ 2024-10-08 22:23 CelonY 阅读(7) 评论(0) 推荐(0)

PDA到货扫描遗漏信息排查

摘要：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 阅读全文

posted @ 2024-08-09 15:14 CelonY 阅读(6) 评论(0) 推荐(0)

补PDA没有反写入库数量成功的情况

摘要：SELECT CGDHD2_SSSL, CGDHD2_RKSL,CGDHD2_THSL,KCRKD2_SSSL, * FROM CGDHD2 , (select KCRKD2_DHLS,KCRKD2_DHFL,KCRKD2_WLBH,sum(KCRKD2_SSSL) KCRKD2_SSSL from 阅读全文

posted @ 2024-05-20 16:53 CelonY 阅读(5) 评论(0) 推荐(0)

补领用班组

摘要：更新限额领料单的领用班组 update lc0019999.KCXED1 SET KCXED1_C3=生产线代码 FROM ningdaMES.dbo.采购领料单主 where KCXED1_SJDH=条码值 and isnull(KCXED1_C3,'')='' 更新生产领料单领用班组 updat 阅读全文

posted @ 2024-05-14 09:17 CelonY 阅读(7) 评论(0) 推荐(0)

业务类别错误修订

摘要：select * from KCRKD1 ,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH --AND KCRKD1_SJDH='G240427000063' AND kcrkd1_lbbh='02' AND KCRKD2_TSKC='Z' select * from KC 阅读全文

posted @ 2024-05-07 17:21 CelonY 阅读(14) 评论(0) 推荐(0)

文章分类 - PS

公告