Version 106
Version 1
Rubriques Inutilisées
UPDATE RHRUBRIQUE
SET RUBISNOTUSED = 1
WHERE (RUBBPID = 0)
AND RUBALIAS IN (
'BHRSFILLON',
'B_COT_CRDS',
'B_COT_CSG',
'COT_AUBFIFILL',
'ASSEDIC1M',
'ASSEDIC3MA',
'ASSEDIC3MU',
'COT_EXCEPINF',
'COT_EXCEP2018',
'FILLONNREG',
'PENIBILITEBASE',
'PENIBILITEPOLY',
'PENIBILITESPEC',
'TAXESAL4',
'BC_BRUT_ASS1M',
'BC_BRUT_ASS3MA',
'BC_GMP_MED30',
'BC_GMP_RET_C',
'BC_PEXCEPT2018',
'BC_REG042016',
'BC_REGTRI2016',
'BC_REGPRORATA',
'BC_TAXE_SAL4',
'PL_GMP',
'PL_MENSTAXE4',
'IJN_MALNIM_CSG',
'IJN_PREV_CSG',
'IJN_PREV_INC',
'IJN_PREV_BRUT',
SET RUBISNOTUSED = 1
WHERE (RUBBPID = 0)
AND RUBALIAS IN (
'BHRSFILLON',
'B_COT_CRDS',
'B_COT_CSG',
'COT_AUBFIFILL',
'ASSEDIC1M',
'ASSEDIC3MA',
'ASSEDIC3MU',
'COT_EXCEPINF',
'COT_EXCEP2018',
'FILLONNREG',
'PENIBILITEBASE',
'PENIBILITEPOLY',
'PENIBILITESPEC',
'TAXESAL4',
'BC_BRUT_ASS1M',
'BC_BRUT_ASS3MA',
'BC_GMP_MED30',
'BC_GMP_RET_C',
'BC_PEXCEPT2018',
'BC_REG042016',
'BC_REGTRI2016',
'BC_REGPRORATA',
'BC_TAXE_SAL4',
'PL_GMP',
'PL_MENSTAXE4',
'IJN_MALNIM_CSG',
'IJN_PREV_CSG',
'IJN_PREV_INC',
'IJN_PREV_BRUT',
'CSGECRETND',
'CSGECRTD');