用友U8 其他出库单、销售出库单、材料出库单的出库数量及序列号

-- 统计 2025 年 1 月 1 日之后的其他出库单、销售出库单、材料出库单的出库数量及序列号
WITH OutgoingStock
AS (
   -- 其他出库单出库数量及序列号统计
   SELECT rdrecords09.cInvCode,
          RdRecord09.cWhCode,
          rdrecords09.cBatch,
          ST_SNDetail_OtherOut.cInvSN,
          SUM(rdrecords09.iQuantity) AS OutgoingQty
   FROM RdRecord09
       JOIN rdrecords09
           ON RdRecord09.ID = rdrecords09.ID
       LEFT JOIN ST_SNDetail_OtherOut
           ON rdrecords09.AutoID = ST_SNDetail_OtherOut.iVouchsID
   WHERE RdRecord09.ddate  >= '2025-01-01'
   GROUP BY rdrecords09.cInvCode,
            RdRecord09.cWhCode,
            rdrecords09.cBatch,
            ST_SNDetail_OtherOut.cInvSN
   UNION ALL

   -- 销售出库单出库数量及序列号统计
   SELECT rdrecords32.cInvCode,
          rdrecord32.cWhCode,
          rdrecords32.cBatch,
          ST_SNDetail_SaleOut.cInvSN,