1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
LOAD "BSINUM_0" as "Clé_liste_chantiers",
Hash128("BSINUM_0",Text(Date("ZPERIOD_0",'YYYYMMDD'))) as "Clé_salaires",
Text(Date("ZPERIOD_0",'YYYYMMDD')) as "Clé_calendrier",
'SALAIRES BUDGET' as "TYPE_LIGNE",
'SALAIRES CIBLE' as "CODE_LIGNE",
Sum("ZSALMS_0")-Sum("ZSECUDG_0")*Sum("ZCAMS_0") as "MONTANT",
// "ZPERIOD_0",
Text(Date("ZPERIOD_0",'YYYYMM')) as "PERIODE",
'' as COMMENTAIRE,
'' as SENS;
SQL SELECT Sum("ZSALMS_0")-Sum("ZSECUDG_0")*Sum("ZCAMS_0") as "MONTANT",
"FCY_0",
"BSINUM_0",
"ZPERIOD_0"
FROM SISPRO.ZBUDGETCL
GROUP BY "ZPERIOD_0"
WHERE TO_CHAR(ZPERIOD_0,'YYYYMM')>='201201'; |
Partager