----------------------------------------------------------------------------- ----- CARTOFLEX_CONTACTS_CLIENT_V ----- ----- Ne contient pas de prospects ----- ----- Mieux que la table CLI ----- ----------------------------------------------------------------------------- SELECT * FROM CARTOFLEX_CONTACTS_CLIENT_V WHERE TIERS = 'C0011641' /* T2_ID 51809 DOSSIER 1 CLE_CONTACT_CLIENT 1 @C0011641 @TMAR TIERST2 C0011641 NOMTIERS SYSTECH CONTACT TMAR NOMABREGE MARTINEZTHOMAS NOMCOMTACT MARTINEZ PRENOM Thomas TITRE MR LIBELLECONTACT 2022 TELEPHONE 02 45 26 03 38 TELMOBILE EMAILCONTACT thomas.martinez@systech-ste.com TITRELIBELLE Monsieur FONCTION1 2 FONCTION2 ACH LIBELLEFONCTION1 Interlocuteur Secondaire LIBELLEFONCTION2 Achats CLI_ID 8740 TIERS C0011641 NOM SYSTECH RUE 6 ZA DE LA CROIX DE SAINT MATHIEU LOC VIL GALLARDON PAY FR CPOSTAL 28320 TEL 02 37 31 40 00 WEB EMAIL NAF 2612Z TIT VID REGL V30 SIRET 38038772000036 USERCRDH 2021-03-31 11:00:34.0000000 USERMODH 2023-05-02 17:40:32.0000000 CENOTE 2 JOINT 66875 STAT_0001 XSVELEC STAT_0002 SCE28 ORIGCOD RECOM REPR_0001 OC PRIOCOD 5 ARMTBTAG_0001 FAV ARMTBTAG_0002 ETQ ARMTBTAG_0003 ARMTBTAG_0004 ARMTBTAG_0005 PLQ ARMTBTAG_0006 ARMTBTAG_0007 ARMTBTAG_0008 CA MOIS 7141 CA 3 MOIS 18244 ANNEE N 25786 ANNEE N-1 65979 */ SELECT CARTOFLEX_CONTACTS_CLIENT_V.T2_ID, CARTOFLEX_CONTACTS_CLIENT_V.DOSSIER, CARTOFLEX_CONTACTS_CLIENT_V.CLE_CONTACT_CLIENT, CARTOFLEX_CONTACTS_CLIENT_V.TIERST2, CARTOFLEX_CONTACTS_CLIENT_V.NOMTIERS, CARTOFLEX_CONTACTS_CLIENT_V.CONTACT, CARTOFLEX_CONTACTS_CLIENT_V.NOMABREGE, CARTOFLEX_CONTACTS_CLIENT_V.NOMCOMTACT, CARTOFLEX_CONTACTS_CLIENT_V.PRENOM, CARTOFLEX_CONTACTS_CLIENT_V.TITRE, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLECONTACT, CARTOFLEX_CONTACTS_CLIENT_V.TELEPHONE, CARTOFLEX_CONTACTS_CLIENT_V.TELMOBILE, CARTOFLEX_CONTACTS_CLIENT_V.FAXCONTACT, CARTOFLEX_CONTACTS_CLIENT_V.EMAILCONTACT, CARTOFLEX_CONTACTS_CLIENT_V.CODESERVICE, CARTOFLEX_CONTACTS_CLIENT_V.TITRELIBELLE, CARTOFLEX_CONTACTS_CLIENT_V.DATEFINVALID, CARTOFLEX_CONTACTS_CLIENT_V.NUMERONOTE, CARTOFLEX_CONTACTS_CLIENT_V.PRESENCENOTE, CARTOFLEX_CONTACTS_CLIENT_V.CODEADRESSE, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION1, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION2, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION3, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION4, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION5, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION6, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION7, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION8, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION9, CARTOFLEX_CONTACTS_CLIENT_V.FONCTION10, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION1, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION2, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION3, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION4, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION5, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION6, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION7, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION8, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION9, CARTOFLEX_CONTACTS_CLIENT_V.LIBELLEFONCTION10, CARTOFLEX_CONTACTS_CLIENT_V.NUMEROJOINT, CARTOFLEX_CONTACTS_CLIENT_V.INDICJOINT, CARTOFLEX_CONTACTS_CLIENT_V.INDICATEURINTERCO, CARTOFLEX_CONTACTS_CLIENT_V."RAISON SOCIAL CLIENT", CARTOFLEX_CONTACTS_CLIENT_V.CLI_ID, CARTOFLEX_CONTACTS_CLIENT_V.CE1, CARTOFLEX_CONTACTS_CLIENT_V.CE2, CARTOFLEX_CONTACTS_CLIENT_V.CE3, CARTOFLEX_CONTACTS_CLIENT_V.CE4, CARTOFLEX_CONTACTS_CLIENT_V.CE5, CARTOFLEX_CONTACTS_CLIENT_V.CE6, CARTOFLEX_CONTACTS_CLIENT_V.CE7, CARTOFLEX_CONTACTS_CLIENT_V.CE8, CARTOFLEX_CONTACTS_CLIENT_V.CE9, CARTOFLEX_CONTACTS_CLIENT_V.CEA, CARTOFLEX_CONTACTS_CLIENT_V.DOS, CARTOFLEX_CONTACTS_CLIENT_V.TIERS, CARTOFLEX_CONTACTS_CLIENT_V.USERCR, CARTOFLEX_CONTACTS_CLIENT_V.USERMO, CARTOFLEX_CONTACTS_CLIENT_V.CONF, CARTOFLEX_CONTACTS_CLIENT_V.VISA, CARTOFLEX_CONTACTS_CLIENT_V.NOMABR, CARTOFLEX_CONTACTS_CLIENT_V.NOM, CARTOFLEX_CONTACTS_CLIENT_V.ADRCPL1, CARTOFLEX_CONTACTS_CLIENT_V.ADRCPL2, CARTOFLEX_CONTACTS_CLIENT_V.RUE, CARTOFLEX_CONTACTS_CLIENT_V.LOC, CARTOFLEX_CONTACTS_CLIENT_V.VIL, CARTOFLEX_CONTACTS_CLIENT_V.PAY, CARTOFLEX_CONTACTS_CLIENT_V.CPOSTAL, CARTOFLEX_CONTACTS_CLIENT_V.ZIPCOD, CARTOFLEX_CONTACTS_CLIENT_V.REGIONCOD, CARTOFLEX_CONTACTS_CLIENT_V.INSEECOD, CARTOFLEX_CONTACTS_CLIENT_V.TEL, CARTOFLEX_CONTACTS_CLIENT_V.FAX, CARTOFLEX_CONTACTS_CLIENT_V.WEB, CARTOFLEX_CONTACTS_CLIENT_V.EMAIL, CARTOFLEX_CONTACTS_CLIENT_V.NAF, CARTOFLEX_CONTACTS_CLIENT_V.TIT, CARTOFLEX_CONTACTS_CLIENT_V.REGL, CARTOFLEX_CONTACTS_CLIENT_V.DEV, CARTOFLEX_CONTACTS_CLIENT_V.LANG, CARTOFLEX_CONTACTS_CLIENT_V.CPT, CARTOFLEX_CONTACTS_CLIENT_V.CPTMSK, CARTOFLEX_CONTACTS_CLIENT_V.SELCOD, CARTOFLEX_CONTACTS_CLIENT_V.SIRET, CARTOFLEX_CONTACTS_CLIENT_V.ETB, CARTOFLEX_CONTACTS_CLIENT_V.USERCRDH, CARTOFLEX_CONTACTS_CLIENT_V.USERMODH, CARTOFLEX_CONTACTS_CLIENT_V.HSDT, CARTOFLEX_CONTACTS_CLIENT_V.NOTE, CARTOFLEX_CONTACTS_CLIENT_V.CENOTE, CARTOFLEX_CONTACTS_CLIENT_V.JOINT, CARTOFLEX_CONTACTS_CLIENT_V.CEJOINT, CARTOFLEX_CONTACTS_CLIENT_V.IDCONNECT, CARTOFLEX_CONTACTS_CLIENT_V.CLDCOD, CARTOFLEX_CONTACTS_CLIENT_V.GLN, CARTOFLEX_CONTACTS_CLIENT_V.TELCLE, CARTOFLEX_CONTACTS_CLIENT_V.ICPFL, CARTOFLEX_CONTACTS_CLIENT_V.TACOD, CARTOFLEX_CONTACTS_CLIENT_V.REMCOD, CARTOFLEX_CONTACTS_CLIENT_V.PROMOTACOD, CARTOFLEX_CONTACTS_CLIENT_V.PROMOREMCOD, CARTOFLEX_CONTACTS_CLIENT_V.TAFAM, CARTOFLEX_CONTACTS_CLIENT_V.TAFAMX, CARTOFLEX_CONTACTS_CLIENT_V.REFAM, CARTOFLEX_CONTACTS_CLIENT_V.REFAMX, CARTOFLEX_CONTACTS_CLIENT_V.REM_0001, CARTOFLEX_CONTACTS_CLIENT_V.REM_0002, CARTOFLEX_CONTACTS_CLIENT_V.REM_0003, CARTOFLEX_CONTACTS_CLIENT_V.REMTYP_0001, CARTOFLEX_CONTACTS_CLIENT_V.REMTYP_0002, CARTOFLEX_CONTACTS_CLIENT_V.REMTYP_0003, CARTOFLEX_CONTACTS_CLIENT_V.DOPDH, CARTOFLEX_CONTACTS_CLIENT_V.NBEX_0001, CARTOFLEX_CONTACTS_CLIENT_V.NBEX_0002, CARTOFLEX_CONTACTS_CLIENT_V.NBEX_0003, CARTOFLEX_CONTACTS_CLIENT_V.NBEX_0004, CARTOFLEX_CONTACTS_CLIENT_V.EDITTYP_0001, CARTOFLEX_CONTACTS_CLIENT_V.EDITTYP_0002, CARTOFLEX_CONTACTS_CLIENT_V.EDITTYP_0003, CARTOFLEX_CONTACTS_CLIENT_V.EDITTYP_0004, CARTOFLEX_CONTACTS_CLIENT_V.ETANO_0001, CARTOFLEX_CONTACTS_CLIENT_V.ETANO_0002, CARTOFLEX_CONTACTS_CLIENT_V.ETANO_0003, CARTOFLEX_CONTACTS_CLIENT_V.ETANO_0004, CARTOFLEX_CONTACTS_CLIENT_V.AXEMSK, CARTOFLEX_CONTACTS_CLIENT_V.AXENO, CARTOFLEX_CONTACTS_CLIENT_V.STLGTGAMCOD, CARTOFLEX_CONTACTS_CLIENT_V.WMAUDITFL, CARTOFLEX_CONTACTS_CLIENT_V.WMDOCEMP, CARTOFLEX_CONTACTS_CLIENT_V.WMRESAIMPFL, CARTOFLEX_CONTACTS_CLIENT_V.TRANSPLANCOD, CARTOFLEX_CONTACTS_CLIENT_V.TEXCOD_0001, CARTOFLEX_CONTACTS_CLIENT_V.TEXCOD_0002, CARTOFLEX_CONTACTS_CLIENT_V.TEXCOD_0003, CARTOFLEX_CONTACTS_CLIENT_V.TEXCOD_0004, CARTOFLEX_CONTACTS_CLIENT_V.TEXCOD_0005, CARTOFLEX_CONTACTS_CLIENT_V.TEXCOD_0006, CARTOFLEX_CONTACTS_CLIENT_V.TEXCOD_0007, CARTOFLEX_CONTACTS_CLIENT_V.TEXCOD_0008, CARTOFLEX_CONTACTS_CLIENT_V.AFFCLDCOD, CARTOFLEX_CONTACTS_CLIENT_V.IDENTITEEXT, CARTOFLEX_CONTACTS_CLIENT_V.STAT_0001, CARTOFLEX_CONTACTS_CLIENT_V.STAT_0002, CARTOFLEX_CONTACTS_CLIENT_V.STAT_0003, CARTOFLEX_CONTACTS_CLIENT_V.TPFT, CARTOFLEX_CONTACTS_CLIENT_V.TIERSGRP, CARTOFLEX_CONTACTS_CLIENT_V.ZONA, CARTOFLEX_CONTACTS_CLIENT_V.CAMT, CARTOFLEX_CONTACTS_CLIENT_V.SALNB, CARTOFLEX_CONTACTS_CLIENT_V.ENMAX_0001, CARTOFLEX_CONTACTS_CLIENT_V.ENMAX_0002, CARTOFLEX_CONTACTS_CLIENT_V.ESCP, CARTOFLEX_CONTACTS_CLIENT_V.ACP, CARTOFLEX_CONTACTS_CLIENT_V.ZONN, CARTOFLEX_CONTACTS_CLIENT_V.TVATIE, CARTOFLEX_CONTACTS_CLIENT_V.TARCOD, CARTOFLEX_CONTACTS_CLIENT_V.COFAM, CARTOFLEX_CONTACTS_CLIENT_V.TIERSNAT, CARTOFLEX_CONTACTS_CLIENT_V.ORIGCOD, CARTOFLEX_CONTACTS_CLIENT_V.REPR_0001, CARTOFLEX_CONTACTS_CLIENT_V.REPR_0002, CARTOFLEX_CONTACTS_CLIENT_V.REPR_0003, CARTOFLEX_CONTACTS_CLIENT_V.ADRTIERS_0001, CARTOFLEX_CONTACTS_CLIENT_V.ADRTIERS_0002, CARTOFLEX_CONTACTS_CLIENT_V.ADRTIERS_0003, CARTOFLEX_CONTACTS_CLIENT_V.ADRTIERS_0004, CARTOFLEX_CONTACTS_CLIENT_V.ADRTIERS_0005, CARTOFLEX_CONTACTS_CLIENT_V.ADRCOD_0001, CARTOFLEX_CONTACTS_CLIENT_V.ADRCOD_0002, CARTOFLEX_CONTACTS_CLIENT_V.ADRCOD_0003, CARTOFLEX_CONTACTS_CLIENT_V.ADRCOD_0004, CARTOFLEX_CONTACTS_CLIENT_V.ADRCOD_0005, CARTOFLEX_CONTACTS_CLIENT_V.TIERSSTAT, CARTOFLEX_CONTACTS_CLIENT_V.TIERSR3, CARTOFLEX_CONTACTS_CLIENT_V.RELCOD_0001, CARTOFLEX_CONTACTS_CLIENT_V.RELCOD_0002, CARTOFLEX_CONTACTS_CLIENT_V.RELCOD_0003, CARTOFLEX_CONTACTS_CLIENT_V.BLMOD, CARTOFLEX_CONTACTS_CLIENT_V.TVANO, CARTOFLEX_CONTACTS_CLIENT_V.TVAPAY, CARTOFLEX_CONTACTS_CLIENT_V.TVABLCOE, CARTOFLEX_CONTACTS_CLIENT_V.TVABLCD3, CARTOFLEX_CONTACTS_CLIENT_V.TVAMAXMT, CARTOFLEX_CONTACTS_CLIENT_V.TRANSJRNB, CARTOFLEX_CONTACTS_CLIENT_V.RFCCTRCOD, CARTOFLEX_CONTACTS_CLIENT_V.PROTOCOL, CARTOFLEX_CONTACTS_CLIENT_V.TIERSEXTERNE, CARTOFLEX_CONTACTS_CLIENT_V.FEU, CARTOFLEX_CONTACTS_CLIENT_V.RELLIGCOD, CARTOFLEX_CONTACTS_CLIENT_V.VALLIGCOD, CARTOFLEX_CONTACTS_CLIENT_V.DEMATCOD, CARTOFLEX_CONTACTS_CLIENT_V.ZONAPC, CARTOFLEX_CONTACTS_CLIENT_V.RELFAM, CARTOFLEX_CONTACTS_CLIENT_V.RELTIETYP, CARTOFLEX_CONTACTS_CLIENT_V.FAMOD, CARTOFLEX_CONTACTS_CLIENT_V.PERIOD, CARTOFLEX_CONTACTS_CLIENT_V.TOUR, CARTOFLEX_CONTACTS_CLIENT_V.TOURRG, CARTOFLEX_CONTACTS_CLIENT_V.BLJR, CARTOFLEX_CONTACTS_CLIENT_V.ADVCOD, CARTOFLEX_CONTACTS_CLIENT_V.PRIOCOD, CARTOFLEX_CONTACTS_CLIENT_V.WEBCDECOD, CARTOFLEX_CONTACTS_CLIENT_V.BPBASCOD, CARTOFLEX_CONTACTS_CLIENT_V.BPRUPTCOD, CARTOFLEX_CONTACTS_CLIENT_V.BLGENCOD, CARTOFLEX_CONTACTS_CLIENT_V.BPRELCOD, CARTOFLEX_CONTACTS_CLIENT_V.PORFRVAL, CARTOFLEX_CONTACTS_CLIENT_V.PORFRCOD, CARTOFLEX_CONTACTS_CLIENT_V.COEFFPOINT, CARTOFLEX_CONTACTS_CLIENT_V.NBPASSAGE, CARTOFLEX_CONTACTS_CLIENT_V.NBPOINT, CARTOFLEX_CONTACTS_CLIENT_V.CDLET, CARTOFLEX_CONTACTS_CLIENT_V.NUMCARTE, CARTOFLEX_CONTACTS_CLIENT_V.PANNO, CARTOFLEX_CONTACTS_CLIENT_V.BQCV, CARTOFLEX_CONTACTS_CLIENT_V.WMPREPMAX, CARTOFLEX_CONTACTS_CLIENT_V.RETNAT, CARTOFLEX_CONTACTS_CLIENT_V.IDCLIENT, CARTOFLEX_CONTACTS_CLIENT_V.CARTENO, CARTOFLEX_CONTACTS_CLIENT_V.TRANSICOD, CARTOFLEX_CONTACTS_CLIENT_V.LIEUINCT, CARTOFLEX_CONTACTS_CLIENT_V.SOURCE, CARTOFLEX_CONTACTS_CLIENT_V.SYSTEME, CARTOFLEX_CONTACTS_CLIENT_V.DOSEXTERNE, CARTOFLEX_CONTACTS_CLIENT_V.ETBEXTERNE, CARTOFLEX_CONTACTS_CLIENT_V.CATCLICOD, CARTOFLEX_CONTACTS_CLIENT_V.IMPLSTCOL, CARTOFLEX_CONTACTS_CLIENT_V.TIERSFOU, CARTOFLEX_CONTACTS_CLIENT_V.UNTYP, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0001, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0002, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0003, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0004, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0005, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0006, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0007, CARTOFLEX_CONTACTS_CLIENT_V.ARMTBTAG_0008, CARTOFLEX_CONTACTS_CLIENT_V."CA MOIS", CARTOFLEX_CONTACTS_CLIENT_V."CA 3 MOIS", CARTOFLEX_CONTACTS_CLIENT_V."ANNEE N", CARTOFLEX_CONTACTS_CLIENT_V."ANNEE N-1" FROM CARTOFLEX.dbo.CARTOFLEX_CONTACTS_CLIENT_V CARTOFLEX_CONTACTS_CLIENT_V WHERE (CARTOFLEX_CONTACTS_CLIENT_V.TIERS='C0011641')