Piolot_RepotForm_PeiHao/非C#代码文件/K3数据.txt

select sum([价税合计（本位币）]) as [价税合计（本位币）] ,a.FHeadSelfI0456, a.FNumber from (SELECT TOP 1000  a.FSourceTranType,a.FSourceInterId,a.FSourceBillNo,aa.FBillNo,a.FOrderInterID,a.FOrderEntryID, b.FNumber,FAuxQty [数量],a.FTaxPrice [含税价]
,a.FStdAmount [金额（本位币）],a.FStdAmountIncludeTax [价税合计（本位币）],a.FStdTaxAmount [税额（本位币）]
 
,aa.FHeadSelfI0553
,aa.FHeadSelfI0456,
  aa.FDate
 
,frob,aa.FTranType,a.FInterID,a.FEntryID
 
--,c.FBillNo

FROM k3.AIS20130323140156.dbo.icsaleentry a 
LEFT JOIN  k3.AIS20130323140156.dbo.icsale aa ON a.FInterID=aa.FInterID 
LEFT JOIN  k3.AIS20130323140156.dbo.t_icitem b ON a.FItemID=b.FItemID 
INNER JOIN [AIS2025].[dbo].[ZZZ_ZZ_FaPiaoLosed] ddd ON a.FInterID=ddd.[FInterID] AND a.[FEntryID]=ddd.[FEntryID]
INNER JOIN (SELECT DISTINCT 合同号 FROM  [AIS20250707104732].[dbo].[oldk3seorder0701]) vv  ON aa.FHeadSelfI0456=vv.合同号 -- AND vv.物料编码= b.FNumber
INNER JOIN dbo.T_SAL_ORDER gg WITH(NOLOCK) ON vv.合同号=gg.F_CONTRACTNUMBER
) a
group by a.FHeadSelfI0456, a.FNumber
having sum([价税合计（本位币）]) !=0
  --WHERE [合同号] ='S110403-PLR01'   AND  FNumber='H.01.020.0006'
--ORDER BY aa.FDate desc, aa.FHeadSelfI0456, b.FNumber
--WHERE a.FInterID=1791
--WHERE aa.FROB=-1
--WHERE FHeadSelfI0456='S110301-ZWH01'
--WHERE aa.FHeadSelfI0553 ='' AND aa.FHeadSelfI0456 =''
--WHERE a.FSourceInterId =0 OR a.FOrderInterID=0

--FHeadSelfI0456 

--SELECT DISTINCT FTranType FROM k3.AIS20130323140156.dbo.icsale a 

--SELECT COUNT(1)
--FROM k3.AIS20130323140156.dbo.icsaleentry a 
--LEFT JOIN  k3.AIS20130323140156.dbo.icsale aa ON a.FInterID=aa.FInterID 
--LEFT JOIN  k3.AIS20130323140156.dbo.t_icitem b ON a.FItemID=b.FItemID