Description

This view is created specifically for Norwegian customers that have Employers Fee, Leave Pay and Pension calculated.

...

FROM PW001P01 P
LEFT JOIN PW001PYH PAY ON PAY.PIN=P.PIN
LEFT JOIN PWORG ORG ON ORG.NUMORGID=PAY.ACCOUNTDIM2
LEFT JOIN PWORG CMP ON CMP.NUMORGID=pAY.ORGNUMID
LEFT JOIN PWORG EMP ON EMP.NUMORGID=pAY.EMPLOYER
LEFT JOIN PWORG CURCMP ON CURCMP.NUMORGID=p.CLIENT
LEFT JOIN PYETY001 EC on EC.ENTRYCODE=PAY.ENTRYCODE
WHERE PAY.PERIODEUSED>202100 AND PAY.PERIODEUSED<202200

Field Specification

...