1 2
|
UPDATE (essai LEFT JOIN F_EcritureC ON essai.[Code ACH] = F_EcritureC.CT_Num) LEFT JOIN F_compteT ON essai.[Code ACH] = F_compteT.CT_Num SET essai.[Code ACH] = alphamois(2,[Code ACH],15), essai.Dateecrit = converDate([dateecrit]), essai.Catecrit = ConverCat([catecrit]), essai.Refecrit = alpha([refecrit],14), essai.catach = " ", essai.ntva = " ", essai.siren = Alpha0([CT_Siret],9), essai.Libecrit = alpha([Libecrit],20), essai.sens = RemplaceSens([sens],1), essai.Echecrit = converDate([Echecrit]), essai.Nom = alpha([EC_Intitule],20), essai.Devise = alpha("EUR",3), essai.Montant = Sum((((([EC_Sens]-1)*2)+1)*[EC_Montant])*-1), essai.blanc1 = " ", essai.datepos = converDate(Date()), essai.blanc2 = " ", essai.mntini = Sum((((([EC_Sens]-1)*2)+1)*[EC_Montant])*-1), essai.blanc3 = " ", essai.[Num Clt] = alpha("47932",5), essai.TypAct = alpha("D",1), essai.blanc4 = " "; |
Partager