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 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
| SELECT
FACTURE_PROFORMA.IDFACTURE_PROFORMA AS IDFACTURE_PROFORMA,
FACTURE_PROFORMA.Type_Facture AS Type_Facture,
FACTURE_PROFORMA.Type_Vehicule AS Type_Vehicule,
FACTURE_PROFORMA.Numero_Facture AS Numero_Facture,
FACTURE_PROFORMA.Date_Facture AS Date_Facture,
FACTURE_PROFORMA.CLIENT AS CLIENT,
FACTURE_PROFORMA.COMMERCIAL AS COMMERCIAL,
FACTURE_PROFORMA.MARQUE AS MARQUE,
FACTURE_PROFORMA.MODELE AS MODELE,
FACTURE_PROFORMA.Puissance_Fiscale AS Puissance_Fiscale,
FACTURE_PROFORMA.Equipement AS Equipement,
FACTURE_PROFORMA.Airsi AS Airsi,
FACTURE_PROFORMA.Taux_Airsi AS Taux_Airsi,
FACTURE_PROFORMA.Quantite AS Quantite,
FACTURE_PROFORMA.Prix_Unitaire AS Prix_Unitaire,
FACTURE_PROFORMA.Remise AS Remise,
FACTURE_PROFORMA.Montant_Remise AS Montant_Remise,
FACTURE_PROFORMA.Prix_Net AS Prix_Net,
FACTURE_PROFORMA.Frais_Immat AS Frais_Immat,
FACTURE_PROFORMA.Prix_Total_HTVA AS Prix_Total_HTVA,
FACTURE_PROFORMA.TVA AS TVA,
FACTURE_PROFORMA.Montant_TVA AS Montant_TVA,
FACTURE_PROFORMA.Prix_Total_TVA AS Prix_Total_TVA,
FACTURE_PROFORMA.Vignette AS Vignette,
FACTURE_PROFORMA.Frais_WW AS Frais_WW,
FACTURE_PROFORMA.Montant_Airsi AS Montant_Airsi,
FACTURE_PROFORMA.Prix_Total_TTC AS Prix_Total_TTC,
FACTURE_PROFORMA.Note AS Note,
LEFT(FACTURE_PROFORMA.Date_Facture,6) AS Mois,
LEFT(FACTURE_PROFORMA.Date_Facture,4) AS Annee,
FACTURE_PROFORMA.Annule AS Annule,
FACTURE_PROFORMA.Enregistre_Par AS Enregistre_Par,
FACTURE_PROFORMA.Modifie_Par AS Modifie_Par,
FACTURE_PROFORMA.Annule_Par AS Annule_Par
FROM
FACTURE_PROFORMA
WHERE
FACTURE_PROFORMA.Numero_Facture = {parametre_numero_facture}
AND LEFT(FACTURE_PROFORMA.Date_Facture,6) = {parametre_mois}
AND LEFT(FACTURE_PROFORMA.Date_Facture,4) = {parametre_annee}
AND FACTURE_PROFORMA.Annule = {parametre_annule}
ORDER BY
Numero_Facture DESC |
Partager