此单里有一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原文：http://blog.51cto.com/bks2015/2336817