用友 U8查询产成品入库单及序列号语句

SELECT 
    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.cinvcode = '8009-0400-000021' 
    AND recordinlist.ddate >= '2025-01-01';