跳至主要內容

库存过账报表

五六零网校小于 1 分钟

代码示例

SELECT T0.[DocNum], T0.[FinncPriod], T1.[ItemCode], T1.[ItemName], T2.[FrgnName], T1.[Price], T1.[DocTotal], T1.[InvntryUom], T1.[CountDate], T1.[BinEntry], T1.[CountQty], T1.[Quantity], T1.[OnHandBef], T1.[Remark] FROM OIQR T0 , IQR1 T1 INNER JOIN OITM T2 ON T1.[ItemCode] = T2.[ItemCode] INNER JOIN OITB T3 ON T2.[ItmsGrpCod] = T3.[ItmsGrpCod] 
WHERE 
 (T1.[ItemCode] >= '[%0]' or '[%0]'='') AND ( T1.[ItemCode] <= '[%1]' or '[%1]'='') 

AND ( T2.[FrgnName] = '[%3]' or '[%3]'='') AND  ( T0.[CountDate] = '[%4]' or '[%4]'='') AND   (   T3.[ItmsGrpNam] = '[%5]' or '[%5]'='') AND    ( T1.[ItemCode]  = '[%6]' or '[%6]'='') AND   ( T0.[DocNum]  = '[%7]' or '[%7]'='')   AND ( T1.[WhsCode]   = '[%8]' or '[%8]'='') AND   ( T0.[FinncPriod]  = '[%8]' or '[%8]'='')