Début 20241030 14593697
PASSER PROLOGUE
20241030 14593697	Début gproc_NewConnecte
20241030 14593736	Fin gproc_NewConnecte

gproc_GET_CommandeHA
SELECT 
hcdid AS nidCde,
caso AS sCodeSte,
caag AS sCodeAgence,
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,
hsrvid AS sService,
hcdmtr AS rMttReceptionne,
hcdmtf AS rMttFacture,
anoma AS sNomAgence
FROM 
chdev.hacde 
LEFT JOIN chdev.agence ON acaag = caag
WHERE
1=1  AND hcddal BETWEEN '2024-10-28' and '2024-11-03' AND caag='BM' AND caso='SD' AND hcdsec in ('BMC24911') AND hcdtyp in ('CO','CF') AND hcdsta IN ('COI')