用友 U8出入库查询SQL 连接UNION ALL

-- 销售出库单查询
SELECT 
    '销售出库单' AS 单据类型,
    a.cCode AS 单号,
    a.dDate AS 日期,
    a.cMaker AS 制单人,
    a.cHandler AS 审核人,
    a.dVeriDate AS 审核日期,
    b.cInvCode AS 存货编码,
    b.iQuantity AS 数量,
    b.cBatch AS 批号,
    c.cInvSN AS 序列号
FROM 
    rdrecord32 a
JOIN 
    rdrecords32 b ON a.ID = b.ID
JOIN 
    ST_SNDetail_SaleOut c ON b.AutoID = c.iVouchsID
WHERE 
    a.dDate >= '2025-01-01' AND a.dDate <= GETDATE()

UNION ALL

-- 其他出库单查询
SELECT 
    '其他出库单' AS 单据类型,
    main.cCode AS 单号,
    main.dDate AS 日期,
    main.cMaker AS 制单人,
    main.cHandler AS 审核人,
    main.dVeriDate AS 审核日期,
    sub.cInvCode AS 存货编码,
    sub.iQuantity AS 数量,
    sub.cBatch AS 批号,
    sn.cInvSN AS 序列号
FROM 
    RdRecord09 main
JOIN 
    rdrecords09 sub ON main.ID = sub.ID
JOIN 
    ST_SNDetail_OtherOut sn ON sub.AutoID = sn.iVouchsID
WHERE 
    main.dDate >= '2025-01-01' AND main.dDate <= GETDATE()

UNION ALL

-- 采购入库单查询
SELECT 
    '采购入库单' AS 单据类型,
    rdrecord01.cCode AS 单号,
    rdrecord01.dDate AS 日期,
    rdrecord01.cMaker AS 制单人,
    rdrecord01.cHandler AS 审核人,
    rdrecord01.dVeriDate AS 审核日期,
    rdrecords01.cInvCode AS 存货编码,
    rdrecords01.iQuantity AS 数量,
    rdrecords01.cBatch AS 批号,
    ST_SNDetail_PUIN.cInvSN AS 序列号
FROM 
    rdrecord01
JOIN 
    rdrecords01 ON rdrecord01.ID = rdrecords01.ID
LEFT JOIN 
    ST_SNDetail_PUIN ON rdrecords01.AutoID = ST_SNDetail_PUIN.iVouchsID
WHERE 
    rdrecord01.dDate >= '2025-01-01' AND rdrecord01.dDate <= GETDATE()

UNION ALL

-- 材料出库单查询
SELECT 
    '材料出库单' AS 单据类型,
    r11.cCode AS 单号,
    r11.dDate AS 日期,
    r11.cMaker AS 制单人,
    r11.cHandler AS 审核人,
    r11.dVeriDate AS 审核日期,
    rds11.cInvCode AS 存货编码,
    rds11.iQuantity AS 数量,
    rds11.cBatch AS 批号,
    sndmo.cInvSN AS 序列号
FROM 
    rdrecord11 r11
LEFT JOIN 
    rdrecords11 rds11 ON r11.ID = rds11.ID
LEFT JOIN 
    ST_SNDetail_MaOut sndmo ON rds11.AutoID = sndmo.iVouchsID
WHERE 
    r11.dDate >= '2025-01-01' AND r11.dDate <= GETDATE()

UNION ALL

-- 产成品入库单查询
SELECT 
    '产成品入库单' AS 单据类型,
    recordinlist.ccode AS 单号,
    recordinlist.ddate AS 日期,
    recordinlist.cmaker AS 制单人,
    recordinlist.chandler AS 审核人,
    recordinlist.dveridate AS 审核日期,
    recordinlist.cinvcode AS 存货编码,
    recordinlist.iquantity AS 数量,
    recordinlist.cbatch AS 批号,
    ST_SNDetail_PROIN.cInvSN AS 序列号
FROM 
    recordinlist WITH (NOLOCK)
LEFT JOIN 
    ST_SNDetail_PROIN ON ST_SNDetail_PROIN.iVouchsID = recordinlist.autoid
WHERE 
    recordinlist.ddate >= '2025-01-01' AND recordinlist.ddate <= GETDATE()

UNION ALL

-- 其他入库单查询
SELECT 
    '其他入库单' AS 单据类型,
    rdrecord08.cCode AS 单号,
    rdrecord08.dDate AS 日期,
    rdrecord08.cMaker AS 制单人,
    rdrecord08.cHandler AS 审核人,
    rdrecord08.dVeriDate AS 审核日期,
    rdrecords08.cInvCode AS 存货编码,
    rdrecords08.iQuantity AS 数量,
    rdrecords08.cBatch AS 批号,
    ST_SNDetail_OtherIN.cInvSN AS 序列号
FROM 
    rdrecord08
JOIN 
    rdrecords08 ON rdrecord08.ID = rdrecords08.ID
LEFT JOIN 
    ST_SNDetail_OtherIN ON rdrecords08.AutoID = ST_SNDetail_OtherIN.iVouchsID
WHERE 
    rdrecord08.dDate >= '2025-01-01' AND rdrecord08.dDate <= GETDATE();