select SF_DYPXBQ,t.pxh,t.*,t.rowid from out_sale_task_d t where t.djbh = 'XSGYMA00323787' and djbh_fpd = '2018122951944' and fhtbh = 'FH90-01'
此单里有一pxh为0 去掉 SELECT F_GET_SYS_CS('ZSHYFHT'),PXH, SF_DYPXBQ FROM OUT_SALE_TASK_D WHERE PXH IS NOT NULL AND DJBH = 'XSGYMA00323787' AND YZID = 'ZDA' AND PXH = '1' and fhtbh = 'FH90-01' AND SF_DYPXBQ = '是'
运行后改一条单号pxh=1,SF_DYPXBQ = '是'
整个分配单就可以复核了
因为加拼箱号的时候手动填上去的0
