gproc_Receptions_DuJour SELECT hcdid AS nidCde, caso AS sCodeSte, caag AS sCodeAgence, hsrvid AS scodeService, hcdnum AS nNumCde, hcddat AS dCommande, hcdref AS sRefCommande, tgid AS nidFournisseur, fousuf AS sSufFournisseur, hcdlib AS sLibelle, hcdfrf AS sRefFou, hcdfcl AS sClientFou, hcddal AS dLivraison, hcdsec AS sSection, hcdmtt AS rMontant, hcdenv AS sModeEnvoi, hcdimo AS sImmo, hcdsld AS sSoldee, hcdfac AS sFacturee, hcdann AS sAnnulee, hcdfor AS sForcee, hcdsta AS sStatut, hcddav AS dValidation, hcdhev AS hValidation, hcdprv AS pValidation, hcdiln AS nNoteInfoLegale, hcdild AS dInfolegale, hcdilp AS sProfilInfolegale, dcrt AS nDateCrea, hcrt AS nHeureCrea, pcrt AS sUtilCrea, pgcrt AS sProgCrea, dmaj AS nDateMAJ, hmaj AS nHeureMAJ, pmaj AS sUtilMAJ, pgmaj AS sProgMAJ, hcdbni AS sBlocNoteInterne, hcdbne AS sBlocNoteImpression, hcdtyp AS sTypeCommande, hcddev AS sNDevis FROM chdev.hacde WHERE hcddal=current date AND hcdsta IN ('COE','COI') AND caag = 'CS' AND hcdsec IN (SELECT hfcsec FROM chdev.hafavc WHERE hfcusr='CFINSB')