說明:查找當前成品的即時入庫,出庫及庫存狀況
select t1.fnumber as 產品代碼,t1.fname as 產品名稱,t1.fmodel as 規格型號,t0.fqty as 即時庫存數量,t7.fdate as 入庫日期,t0.fbatchno as 批號xbs
X­-[1]F
,t2.fname as 計量單位 eb7~\|9l1i
,單價=(select top1 fprice from SEOrderEntry p0 inner join SEOrder p1 on p0.finterid=p1.finterid where 85ND 3F6q4
p0.fitemid=t0.fitemid order by p0.finterid desc ) 5Eu`1f?
,金額=t0.fqty*(selecttop 1 fprice from SEOrderEntry p0 inner join SEOrder p1 onp0.finterid=p1.finterid where hEAP,‑)>F
p0.fitemid=t0.fitemid order by p0.finterid desc ) Pj‑kjUP
,t4.fbillno as 銷售訂單號,t5.fname業務員 _
SqUPTb"u
from ICInventory t0 inner join t_icitem t1 ont0.fitemid=t1.fitemid AND t1.FNumber>='*ItemNo*' X@Yl<9|i
AND t1.FNumber<='#ItemNo#'
&W? hCr
inner join t_MeasureUnit t2 on t1.funitid=t2.fitemid M
][Zu[\*
right join SEOrderEntry t3 on t3.fitemid=t0.fitemid vR'rYDtU@
inner join seorder t4 on t3.finterid=t4.finterid Q*]y=Za#:
inner join t_emp t5 on t4.fempid=t5.fitemid ‑y5N­,~@$r
inner join icstockbillentry t6 on t6.fbatchno=t0.fbatchno andt6.fitemid=t0.fitemid and t3.finterid=t6.forderinterid and 5Cl;h^R|m
t3.fentryid=t6.forderentryid UE |