HTMT	Hors taxe
TTCMT	TTC





-----------------------------------------------------------------------------
-----	CLI																-----
-----------------------------------------------------------------------------
CLI.USERCRDH	Date de création d'un dossier
CLI.USERMODH	Date de modification d'un dossier

-----------------------------------------------------------------------------
-----	CARTOFLEX_CONTACTS_CLIENT_V										-----
-----------------------------------------------------------------------------

CARTOFLEX_CONTACTS_CLIENT_V.NOM
CARTOFLEX_CONTACTS_CLIENT_V.NOMTIERS, 
CARTOFLEX_CONTACTS_CLIENT_V.TIERS, 
CARTOFLEX_CONTACTS_CLIENT_V.VIL, 
CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH, 
CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD 


-----------------------------------------------------------------------------
-----	T2																-----
-----------------------------------------------------------------------------
T2.TIERS,  
T2.CONTACT
T2.FCTCOD_0001, 
T2.FCTCOD_0002, 
T2.FCTCOD_0003
T2.EMAIL, 
T2.TIT, 
T2.NOM, 
T2.PRENOM

	WHERE (T2.TIERS Like 'C001%')


-----------------------------------------------------------------------------
-----	ENT																-----
-----------------------------------------------------------------------------

ENT.TIERS
ENT.STATUS, 
ENT.CONTACT, 
ENT.HTMT, 
ENT.TTCMT, 
ENT.PIDT, 
ENT.PINO, 
ENT.PINOTIERS, 
ENT.PIREF, 
	
	WHERE (ENT.PIDT Between '2023-01-01' And '2023-03-02')