Description

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

...

SELECT
P.PIN,
1 AS COUNT,
P.NAME,
PAY.PERIODEUSED as 'PERIOD',
PAY.ENTRYCODE 'EC NUMBER',
CONVERT(VARCHAR,pay.ENTRYCODE)+' '+EC.TEXT AS 'ENTRY CODE',
PAY.CALCULATEDAMOUNT1 AS AMOUNT,
PAY.CALCULATEDAMOUNT2 as 'EMPLOYERS FEE',
PAY.CALCULATEDAMOUNT3 as 'LEAVE PAY',
PAY.CALCULATEDAMOUNT4 as 'EMP. FEE LP',
PAY.CALCULATEDAMOUNT6 as 'PENSION FEE',

PAY.CURRENCYFORPAYMENT AS 'PAYMENT CURRENCY',
Pay.PAID,
PAY.DATE_OF_PAYMENT,
PAY.TEXT,
convert(float, case when entryfield2='' then '0' else replace(entryfield2, ',', '.') end) as QUANTITY,
ORG.NAME AS VESSEL,
P.CLIENT NUMORGID,
P.EMPLOYMENTSTARTDATE,
P.EMPLOYMENTENDDATE,
CMP.NAME as COMPANY,
EMP.NAME as EMPLOYER,
CURCMP.NAME as 'CURRENT COMPANY LINK'

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

...