--	Aucun intérêt à lier la table MOUV et obtenir des infos clients car aucune liaison
--	Query à revoir


SELECT DISTINCT MOUV.MOUV_ID, MOUV.TIERS, MOUV.REF, MOUV.REPR_0001, MOUV.STATUS, MOUV.TICOD, MOUV.PICOD, CLI.EMAIL, CLI.EMAILCONTACT 
FROM MOUV MOUV, CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI 
WHERE MOUV.TIERS = CLI.TIERS 
AND (MOUV.DVDT>'2023-01-01' And MOUV.DVDT<'2023-03-02') 
UNION 
SELECT DISTINCT MOUV.MOUV_ID, MOUV.TIERS, MOUV.REF, MOUV.REPR_0001, MOUV.STATUS, MOUV.TICOD, MOUV.PICOD, PRO.EMAIL, PRO.EMAILCONTACT 
FROM MOUV MOUV, CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PRO 
WHERE MOUV.TIERS = PRO.TIERS 
AND (MOUV.DVDT>'2023-01-01' And MOUV.DVDT<'2023-03-02') 











SELECT DISTINCT MOUV.MOUV_ID, MOUV.TIERS, MOUV.REF, MOUV.REPR_0001, MOUV.STATUS, MOUV.TICOD, MOUV.PICOD, CLI.EMAIL, CLI.EMAILCONTACT 
FROM MOUV MOUV, CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI 
WHERE MOUV.TIERS = CLI.TIERS 
AND (MOUV.DVDT>'2022-08-01' And MOUV.DVDT<'2022-09-10') AND (MOUV.REPR_0001 = 'ACS')
UNION 
SELECT DISTINCT MOUV.MOUV_ID, MOUV.TIERS, MOUV.REF, MOUV.REPR_0001, MOUV.STATUS, MOUV.TICOD, MOUV.PICOD, PRO.EMAIL, PRO.EMAILCONTACT 
FROM MOUV MOUV, CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PRO 
WHERE MOUV.TIERS = PRO.TIERS 
AND (MOUV.DVDT>'2022-08-01' And MOUV.DVDT<'2022-09-10') AND (MOUV.REPR_0001 = 'ACS')







/*	Codification
TICOD	P = Prospect | C = Client
PICOD	1 = Devis | 2 = Commande | 3 = BL | 4 = Facture
*/

DOS
TIERS
DVDT	Date de devis
FADT	Date de la facture
BLDT	Date du BL
CDDT	Date de la commande
USERMODH	2014-01-30 11:07:26.0000000


ce1
ce2
ce3
ce4	inutile dans cette table
ce5
ce6
ce7
ce8
ce9
cea
ceb
cec
ced
cee
cef
dos
sref
sref1
sref2
prefdvno
dvno
dvdt
dvlg
dvslg
dvce4
prefcdno
cdno
cddt
cdlg
cdslg
cdce4
cdenrno
prefbln
blno
bldt
bllg
usercr
usermo
usercrdh
usermodh

SELECT MOUV.TIERS, MOUV.MOUV_ID, MOUV.REF, MOUV.PICOD, MOUV.TICOD, MOUV.DVNO, MOUV.DVDT 
FROM CARTOFLEX.dbo.MOUV MOUV
WHERE MOUV.TIERS LIKE 'P%' 
AND (MOUV.DVDT>'2023-01-01' And MOUV.DVDT<'2023-03-02') 

SELECT MOUV.TIERS, MOUV.MOUV_ID, MOUV.REF, MOUV.PICOD, MOUV.TICOD, MOUV.DVNO, MOUV.DVDT 
FROM CARTOFLEX.dbo.MOUV MOUV
WHERE MOUV.TIERS LIKE 'P%' 
AND (MOUV.DVDT>'2023-01-01' And MOUV.DVDT<'2023-03-02') 


SELECT 
CLI.TIERS, 
CLI.EMAIL, 
CLI.EMAILCONTACT, 
CLI.RUE, 
CLI.LOC, 
CLI.CPOSTAL, 
CLI.VIL, 
CLI."RAISON SOCIAL CLIENT", 
CLI.NOM, 
CLI.ORIGCOD, 
CLI.PAY, 
CLI.TITRELIBELLE, 
CLI.PRENOM, 
CLI.NOMCOMTACT, 
CLI.REPR_0001, 
CLI.NAF 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI 
WHERE CLI.DOS='1' 
AND CLI.REPR_0001 = 'ACS' 
AND CLI.TIERS='C0003000' 


SELECT 
PRO.TIERS, 
PRO.EMAIL, 
PRO.EMAILCONTACT, 
PRO.RUE, 
PRO.LOC, 
PRO.CPOSTAL, 
PRO.VIL, 
PRO."RAISON SOCIAL PROSPECT", 
PRO.NOM, 
PRO.ORIGCOD, 
PRO.PAY, 
PRO.TITRELIBELLE, 
PRO.PRENOM, 
PRO.NOMCOMTACT, 
PRO.REPR_0001, 
PRO.NAF 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PRO, CARTOFLEX.dbo.ENT ENT, CARTOFLEX.dbo.T2 T2 
WHERE PRO.DOS='1' 
AND ENT.TIERS = PRO.TIERS 
AND T2.DOS = PRO.DOS 
AND T2.TIERS = PRO.TIERS 
AND ((PRO.DOS='1') AND (ENT.PIDT>'2021-12-31') AND (ENT.CE4='1') AND (PRO.REPR_0001 = 'ACS')) 




SELECT DISTINCT 
CLI.TIERS, 
CLI.EMAIL, 
CLI.EMAILCONTACT, 
CLI.RUE, 
CLI.LOC, 
CLI.CPOSTAL, 
CLI.VIL, 
CLI."RAISON SOCIAL CLIENT", 
CLI.NOM, 
CLI.TITRELIBELLE, 
CLI.PRENOM, 
CLI.NOMCOMTACT, 
MOUV.PICOD, 
MOUV.TICOD, 
MOUV.DVNO, 
MOUV.DVDT, 
CLI.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLI, CARTOFLEX.dbo.MOUV MOUV 
WHERE CLI.DOS='1' 
AND MOUV.TIERS = CLI.TIERS 
AND CLI.REPR_0001 = 'ACS' 
AND (MOUV.DVDT>'2023-01-01' And MOUV.DVDT<'2023-03-02') 




SELECT 
PROSPECT.TIERS, 
PROSPECT.NOMTIERS, 
PROSPECT.VIL, 
PROSPECT.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_PROSPECT_V PROSPECT, MOUV MOUV 
WHERE PROSPECT.REPR_0001 = 'ACS' 
AND PROSPECT.TIERS = MOUV.TIERS 
AND (MOUV.DVDT>'2023-01-01' And MOUV.DVDT<'2023-03-02') 
UNION 
SELECT 
CLIENT.NOMTIERS, 
CLIENT.TIERS, 
CLIENT.VIL, 
CLIENT.REPR_0001 
FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CLIENT, MOUV MOUV 
WHERE CLIENT.REPR_0001 = 'ACS'