库存对应在库序列号查询SQL原创
9人赞赏了该文章
119次浏览
编辑于2024年06月04日 14:31:14
如何查询即时库存对应序列号SQL
说明:
系统即时库存联查序列号时,可直接查询出即时库存对应的序列号,以下脚本则为此逻辑SQL。
脚本示例:
SELECT T0.FMATERIALID,T0.FNUMBER AS FSNNUMBER FROM T_BD_SERIALMASTER T0 INNER JOIN T_BD_SERIALBILLTRACE T1 ON T0.FSERIALID = T1.FSERIALID INNER JOIN (SELECT MAX(T3.FBILLTRACEID) AS FBILLTRACEID FROM T_BD_SERIALBILLTRACE T3 INNER JOIN (SELECT DISTINCT FSERIALID FROM T_BD_SERIALBILLTRACE WHERE FINVID IN ('XXXX')) T4 ON T4.FSERIALID = T3.FSERIALID WHERE ISNULL(T3.FINVID, ' ') <> ' ' GROUP BY T3.FSERIALID) T2 ON T1.FBILLTRACEID = T2.FBILLTRACEID WHERE T0.FFORBIDSTATUS = 'A' AND T1.FSTATE = '1' AND T1.FINVID IN ('XXXX') ORDER BY T1.FINVID,T0.FNUMBER
以上为即时库存联查序列号取数脚本,如果需要取得即时库存其他维度信息的话,需要再关联 T_STK_INVENTORY IT ON T1.FINVID = IT.FID 即可。