1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| SELECT
IRIS_Format_G3_Def.SOCIETE as SOCIETE_FAC,
IRIS_Format_G3_Def.TYPE_GROUPE_CDE as GRP_CDE_FAC,
IRIS_Format_G3_Def.FAM_ART as FAM_ART_FAC,
IRIS_Format_G3_Def.NAT_ART as NATURE_FAC,
(cast (IRIS_Format_G3_Def.DANNEE as integer)+2000) as ANNEE_FAC,
(cast (IRIS_Format_G3_Def.DMOIS as integer)) as MOIS_FAC,
IRIS_Format_G3_Def.DDATE as DATE_FACTURE,
IRIS_Format_G3_Def.RESEAU,
Clients_01.CODE_PAYS,Clients_01.LIB_PAYS,
IRIS_Format_G3_Def.VRP_CLIENT as VRP_CLIENT,
IRIS_Format_G3_Def.QTE as QTE_FAC,
IRIS_Format_G3_Def.CA as CA_FAC
from IRIS_Format_G3_Def
left join CLients_01
on IRIS_Format_G3_Def.SOCIETE = CLients_01.SOCIETE
and IRIS_Format_G3_Def.CODE_CLIENT = CLients_01.CODE_CLIENT
where IRIS_Format_G3_Def.NAT_ART <> 'PRE'
and IRIS_Format_G3_Def.NAT_ART not like 'RF%'
and (cast (IRIS_Format_G3_Def.DANNEE as integer)+2000) in (!PARAM_ANNEE_N,!PARAM_ANNEE_N-1)
and (cast (IRIS_Format_G3_Def.DMOIS as integer)) <= !PARAM_MOIS_N
and IRIS_Format_G3_Def.SOCIETE = !PARAM_SOCIETE |
Partager