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
| SELECT fdl.do_piece
, fdl.do_date
, ct_num
, dl_ligne
, ar_ref
, ar_refcompose
, dl_design
, dl_qte
, dl_montantht / dl_qte AS pu
, co_nom
, case
when (ar_ref = ar_refcompose AND ar_refcompose <> '')
OR ar_refcompose IS NULL
OR ar_refcompose = ''
then dl_montantht
else 0
end
, case when ar_ref = ar_refcompose AND ar_refcompose <> '' then dl_montantht else 0 end
, case when ar_ref <> ar_refcompose AND ar_refcompose <> '' then dl_montantht else 0 end
, pa
, cr
, comintermediaire
, fdl.margepcent
, fdl.marge
, ajustpa
, pa_rectifie
FROM f_docligne AS fdl
LEFT OUTER JOIN f_collaborateur RepDoc
ON fdl.CO_No = Repdoc.co_no
INNER JOIN f_docentete AS fde
ON fde.do_piece = fdl.do_piece
INNER JOIN bor_view_docligne_ctrl AS bvd
ON bvd.do_piece = fde.do_piece
AND bvd.do_type = fde.do_type
AND bvd.do_domaine = fde.do_domaine
WHERE dl_qte <> 0
AND bvd.total_ht_from_composant - bvd.total_ht NOT BETWEEN -0.5 AND 0.5
AND fde.do_date >= convert(datetime, '20090101', 112)
AND fde.do_type < 7 |
Partager