Page Comparison

SELECT pay.PIN,
       p01.Name,
       persorg.name               AS Organization,
       pay.accountdim2            AS VesOrgID,
       ISNULL(ves.name, 'N/A')    AS 'Vessel Name',
       CASE 
            WHEN pay.ACCOUNTDIM3 IS NULL OR pay.ACCOUNTDIM3 = '' THEN 'N/A'
            ELSE pay.ACCOUNTDIM3
       END 'Department',
       ISNULL(CAT.NAME, 'Other')  AS 'Category',
       pay.CALCULATEDAMOUNT1      AS 'Amount',
       pay.periodeused            AS Period,
       CONVERT(VARCHAR, PAY.ENTRYCODE) + ' ' + EC.TEXT AS 'Entry Code',
       CASE 
            WHEN pay.ACCOUNTNOOFCALCAMOUNT1 <> '' THEN pay.ACCOUNTNOOFCALCAMOUNT1 + ' - ' + acc.ACCOUNTTEXT
            WHEN pay.ACCOUNTNOOFCALCAMOUNTCREDIT1 <> '' THEN pay.ACCOUNTNOOFCALCAMOUNTCREDIT1 + ' - ' + acc.ACCOUNTTEXT
       END 'Account No',
       CASE 
            WHEN pay.ACCOUNTNOOFCALCAMOUNT1 <> '0' THEN 'DEBIT'
            WHEN pay.ACCOUNTNOOFCALCAMOUNTCREDIT1 <> '0' THEN 'CREDIT'
            ELSE                     'N/A'
       END 'Account type',
       pay.rank                   AS RANK,
       pay.currencyforpayment     AS 'Payment Currency ',
       p01.client                    numorgid,
       p01.employmentstartdate,
       p01.employmentenddate
FROM   pw001pay pay
       LEFT JOIN pw001p01 p01
            ON  p01.pin = pay.pin
            AND CALCULATEDAMOUNT1 <> 0
       LEFT JOIN pworg ves
            ON  ves.numorgid = pay.accountdim2
       LEFT JOIN pyety001 ec
            ON  ec.entrycode = pay.entrycode
       LEFT JOIN pworg persorg
            ON  persorg.numorgid = p01.client
       LEFT JOIN PW001C117 CAT
            ON  ec.CATEGORY = CAT.SEQUENCENO
            AND pay.ENTRYCODE = ec.ENTRYCODE
       LEFT JOIN PY001ACC ACC
            ON  (ACC.ACCOUNTNO = pay.ACCOUNTNOOFCALCAMOUNT1) OR (acc.ACCOUNTNO = pay.ACCOUNTNOOFCALCAMOUNTCREDIT1)
WHERE  CALCULATEDAMOUNT1 <> 0