盘点分摊核对

--1分摊原始数
SELECT sum(qty)
  FROM INVENTORY_TRANSACTION2 it
 WHERE APPORTION_LOT = '20260922141224';

-- 2分摊过程暂存表
SELECT sum(qty) FROM INVENTORY_TRANSACTION_TEMP it;

-- 3分摊过程 按 继承批号  汇总
SELECT WMS_JC_UUID, abs(sum(qty))
  FROM INVENTORY_TRANSACTION_TEMP
 group by WMS_JC_UUID
 order by 1;

--4分摊结果按 继承批号  汇总
SELECT WMS_JC_UUID, sum(qty)
  FROM INVENTORY_TRANSACTION
 WHERE APPORTION_LOT = '20260922141224'
 group by WMS_JC_UUID
 order by 1;

1  2一致 则标识全部分摊 未漏分摊

3 4 汇总 一致表示分摊结果全部推送erp ,对比 行数和  总合计