ZDHMD Les CTP URSSAF

Par AMO

CTP URSSAF-Liste (Windows)

select a.CDCODE, b.LIBLON, c.*
from HR.ZD00 a, HR.ZD01 b, HR.ZD7T c
where a.NUDOSS = b.NUDOSS and a.NUDOSS = c.NUDOSS
and a.CDSTCO = 'HMD'

CTP URSSAF-Liste

select a.cdcode, b.liblon, c.natu23
from zd00 a, zd01 b, zd7t c
where a.nudoss = b.nudoss
and a.nudoss= c.nudoss
and a.cdstco = 'HMD'
and b.cdlang = 'F'
order by a.cdcode
;