1 2 3 4 5
| SELECT DISTINCT T_ETSE.RSEtse, T_ETSE.IdNIF, T_ETSE.BPEtse, T_ETSE.TelEtse, T_ETSE.FaxEtse, T_ETSE.VilleEtse, T_AN.LibAn, T_EMPLOYE.NIFEmpl, T_EMPLOYE.NomEmpl+" "+T_EMPLOYE.PreEmpl AS Employe, T_EMPLOYE.ProfEmpl, T_EMPLOYE.TelEmpl, T_EMPLOYE.BPEmpl, T_EMPLOYE.VilleEmpl, T_EMPLOYE.SitEmpl, T_EMPLOYE.EnfEmpl, T_EMPLOYE.Du, T_EMPLOYE.Au, Sum(T_ELTSAL.SalBrut)-Sum(T_ELTSAL.RetCNSS)-Sum(T_ELTSAL.RetCNAMGS) AS TotalImpos, Sum(T_ELTSAL.SalConge) AS TotalConge, exprs1=if(Sum(T_ELTSAL.IndLog)>(Sum(T_ELTSAL.SalBrut-T_ELTSAL.RetCNSS-T_ELTSAL.RetCNAMGS)*0.06),Sum(T_ELTSAL.IndLog)-Sum(T_ELTSAL.SalBrut-T_ELTSAL.RetCNSS-T_ELTSAL.RetCNAMGS)*0.06,0) AS LogImpos, exprs2=if(Sum(T_ELTSAL.IndEE)>(Sum(T_ELTSAL.SalBrut-T_ELTSAL.RetCNSS-T_ELTSAL.RetCNAMGS)*0.05),Sum(T_ELTSAL.IndEE)-Sum(T_ELTSAL.SalBrut-T_ELTSAL.RetCNSS-T_ELTSAL.RetCNAMGS)*0.05,0) AS EEImpos, exprs3=if(Sum(T_ELTSAL.IndDomes)>(Sum(T_ELTSAL.SalBrut-T_ELTSAL.RetCNSS-T_ELTSAL.RetCNAMGS)*0.05),Sum(T_ELTSAL.IndDomes)-Sum(T_ELTSAL.SalBrut-T_ELTSAL.RetCNSS-T_ELTSAL.RetCNAMGS)*0.05,0) AS DomesImpos, exprs4=if(Sum(T_ELTSAL.IndNour)>(Sum(T_ELTSAL.SalBrut-T_ELTSAL.RetCNSS-T_ELTSAL.RetCNAMGS)*0.25),Sum(T_ELTSAL.IndNour)-Sum(T_ELTSAL.SalBrut-T_ELTSAL.RetCNSS-T_ELTSAL.RetCNAMGS)*0.25,0) AS NourImpos, Sum(T_ELTSAL.IndResp)+Sum(T_ELTSAL.IndTransp)+Sum(T_ELTSAL.IndDeplac)+Sum(T_ELTSAL.IndCompens)+Sum(T_ELTSAL.IndDiv) AS IndNonImp, Sum(T_ELTSAL.RetTCS) AS TotalTCS, Sum(T_ELTSAL.RetIRPP) AS TotalIRPP, Round(Sum((T_ELTSAL.[CotPatro]/0.16)*0.02),0) AS TotalFNH, T_CONTRIB.Cat_a, T_CONTRIB.Cat_b, T_CONTRIB.Cat_c
FROM T_AN, T_MOIS, T_EMPLOYE, T_ELTSAL, ST_SAISIR, ST_COMPRENDRE, T_ETSE, T_CONTRIB, ST_VERSER
WHERE (((T_AN.liban)=ST_COMPRENDRE.liban) And ((ST_COMPRENDRE.libmois)=T_MOIS.libmois) And ((T_MOIS.libmois)=ST_SAISIR.libmois) And ((ST_SAISIR.IdElt)=T_ELTSAL.IdElt) And ((T_EMPLOYE.IdEmpl)=T_ELTSAL.IdEmpl) And ((T_ELTSAL.SalBrut)>80000) And ((T_ETSE.IdNIF)=T_EMPLOYE.IdNIF And (T_ETSE.IdNIF)=T_EMPLOYE.IdNIF And (T_ETSE.IdNIF)=ST_VERSER.IdNIF) And ((ST_VERSER.IdCont)=T_CONTRIB.IdCont))
GROUP BY T_ETSE.RSEtse, T_ETSE.IdNIF, T_ETSE.BPEtse, T_ETSE.TelEtse, T_ETSE.FaxEtse, T_ETSE.VilleEtse, T_AN.LibAn, T_EMPLOYE.NIFEmpl, T_EMPLOYE.NomEmpl+" "+T_EMPLOYE.PreEmpl, T_EMPLOYE.ProfEmpl, T_EMPLOYE.TelEmpl, T_EMPLOYE.BPEmpl, T_EMPLOYE.VilleEmpl, T_EMPLOYE.SitEmpl, T_EMPLOYE.EnfEmpl, T_EMPLOYE.Du, T_EMPLOYE.Au, T_CONTRIB.Cat_a, T_CONTRIB.Cat_b, T_CONTRIB.Cat_c
HAVING (((T_ETSE.RSEtse)=[INDIQUEZ LA RAISON SOCIALE ?]) AND ((T_AN.LibAn)=[L'ANNEE DE L'EXERCICE ?])); |
Partager