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
CASE
WHEN (MONTH(DO_Date) BETWEEN 1 AND 3) THEN '2em'
WHEN (MONTH(DO_Date) BETWEEN 4 AND 6) THEN '3em'
WHEN (MONTH(DO_Date) BETWEEN 7 AND 9) THEN '4em'
WHEN (MONTH(DO_Date) BETWEEN 10 AND 12) THEN '1er'
END AS TRIMESTRE,
CASE
WHEN MONTH(DO_Date) > 9 THEN (YEAR(DO_Date) + 1)
ELSE (YEAR(Do_Date))
END AS EXERCICE,
F_COMPTET.CT_Intitule AS FOURNISSEUR,
F_DOCLIGNE.DO_Piece AS DOC_NUM,
F_DOCLIGNE.DO_Date AS DOC_DATE,
F_DOCLIGNE.DO_Ref AS DOC_REF,
F_DOCLIGNE.AR_Ref AS ARTICLE,
F_ARTICLE.FA_CodeFamille AS FAMILLE,
F_DOCLIGNE.DL_Design AS DESIGNATION,
F_DOCLIGNE.DL_Qte AS QTE,
F_DOCLIGNE.DL_PrixUnitaire AS PU,
F_DOCLIGNE.DL_Qte * F_DOCLIGNE.DL_PrixUnitaire AS MONTANT
FROM F_DOCLIGNE
INNER JOIN F_COMPTET ON F_DOCLIGNE.CT_Num = F_COMPTET.CT_Num
INNER JOIN F_ARTICLE ON F_DOCLIGNE.AR_Ref = F_ARTICLE.AR_Ref
WHERE (F_DOCLIGNE.DO_Domaine = 1) AND
(F_DOCLIGNE.DO_Type IN (15, 16, 17)) AND
(EXERCICE = :PEXERCICE) |
Partager