预付款申请报表

代码示例

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T2.[SlpName]AS'采购员', T1.[UseBaseUn], T1.[Quantity], T1.[Price], T1.[DiscPrcnt], T1.[LineTotal] 

FROM ODPO T0  INNER JOIN DPO1 T1 ON T0.[DocEntry] = T1.[DocEntry] 
INNER JOIN OSLP T2 ON T0.[SlpCode] = T2.[SlpCode] 
INNER JOIN OITM T3 ON T1.[ItemCode] = T3.[ItemCode]  
INNER JOIN OITB T4 ON  T4.[ItmsGrpCod] = T3.[ItmsGrpCod] 

WHERE T1.[ItemCode] >=[%0] AND  T1.[ItemCode] <=[%1] 
AND  ( T0.[DocDate]= '[%4]' or '[%4]'='') 
AND   ( T0.[DocStatus] = '[%5]' or '[%5]'='') 
AND    (T4.[ItmsGrpNam]  = '[%6]' or '[%6]'='') 
AND   ( T2.[SlpName]  = '[%7]' or '[%7]'='') 
AND ( T0.[CardCode]  = '[%8]' or '[%8]'='') 
AND   ( T0.[CardName] = '[%9]' or '[%9]'='')