Summary	The view is used for accounting purposes. It gives an overview of the current period payments split by accounts debit and credit.
Keywords	Payroll, Accounting
Category	Analytical View

Description

The view is used for accounting purposes. It gives an overview of the current period payments split by accounts debit and credit.

Main Data Selection

All the crew members have some payments this month. Only calculatedamount1 is considered by this view.

Setup and Configuration

SQL statement

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

Fields Definition

View Configuration (Column/Raw/Data Fields)

Rows/ Columns Specification

Row/Column	Description/ Location in APM
PIN	The PIN from the Personal Details.
Name	The Full Name from the Personal Details.
Organization	The Employment Organization from the Personal Details.
VesOrgID	The ID of the vessel linked to the payment entry in Account Dim 2.
Vessel Name	The Name of the vessel linked to the payment entry Account Dim 2.
Department	The Code of the department linked to the payment entry Account Dim 3.
Category	The category of the payment entry.
Amount	The Amount (Entry Field 1) value of the payment entry.
Period	The Period of the payment entry.
Entry Code	The Code of payment entry.
Account No	The account number of calculatedamount1 on the payment entry.
Account Type	The account type of calculatedamount1 on the - either debit or credit.
Rank	The Name of the rank linked to the payment entry.
Payment Currency	The payment currency of the payment entry.
numorgid	The emplyment organization ID from the Personal Details.
employmentstratdate	The emplyment start date from the Personal Details.
employmentenddate	The emplyment end date from the Personal Details.

Other

N/A

Accounting Summary (current period)