L1

PIN

L2

Seq No

L3

Source ("S" - Payroll Module Auto Entry, <blank> Payroll Module manual entry,

"T" - Timecard module, "E" - from another Entry code, "I" - from APP, “G” - Gratuities plugin)

L4

From Vessel

L5

Changed By

L6

Create Time

L7

Changed By

L8

Change Time

L9

Calculated By

L10

Calculate Time

L11

Is Back Pay Entry (Y/N)

L15

From Period

L16

To Period

L17

Reference (Ref)

L18

Entry Code number

L18a

Entry Code text

L19

L19a

L19d

From Date

From Date (yyyymmdd)

From Date (nr of days)

L20

L20a

L20d

To Date

To Date (yyyymmdd)

To Date (nr of days)

L21

Entry Field [1]

L22

Entry Field [2]

L22a

With Hours Sign ON/ OFF

L22d

Activity Leave days in current period

L22h

Holiday counter in current period

L22w

Business Days counter of activity in current period

L22y

Activity days in current period

L23

Entry Field [3]

L24

Entry Field [4]

L25

Entry Field [5]

L26

Entry Field [6]

L30

Category Code

L30a

Category Name

L31

AccountNo Dim [1]

L32

Account Dim [2]

L33

Account Dim [3]

L34

Account Dim [4]

L35

Account Dim [5]

L36

Account Dim [6]

L37

LTO Ref

L38

Info PAYNAME

L47

Account Dim [7]

L48

Account Dim [8]

L49

Account Dim [9]

L40

Account Dim [10]

L41

Account Dim [11]

L42

Account Dim [12]

L43

Contract PW001P20.SEQUENCENO

L50

Period Used

L50a

Period within year (Period Used mod 100)

L51

Credit Entry

L52

Currency Code for calculation

L53

Currency Code

L54

Currency rate for calculation

L55

Currency Rate

L56

Current Currency

L57

Calculation Priority

L58

Department

L59

County No

L61

Calculated Amount 1

L62

Calculated Amount 2

L63

Calculated Amount 3

L64

Calculated Amount 4

L65

Calculated Amount 5

L66

Calculated Amount 6

L67

Calculated Amount 7

L68

Calculated Amount 8

L69

Calculated Amount 9

L70

Calculated Amount 10

L71

Calculated Amount 11

L72

Payscale Table

L73

Payscale Code

L74

Seniority Year

L78a

Payroll Seniority years at Payroll period Start

L78b

Payroll Seniority months at Payroll period Start

L78c

Payroll Seniority days at Payroll period Start

L79a

Payroll Seniority years at Payroll period end

L79b

Payroll Seniority months at Payroll period end

L79c

Payroll Seniority days at Payroll period end

L80

Rank

L80a

Rank name

L80y

Rank code + name

L80z

Rank group No

L80s

Rank code specification

L81a

Org code of the first company over Accdim2

L81b

Name of the first company over Accdim2

L81c

Numorgid of the first company over Accdim2

L83

Currency Code for Payment

L84

Currency Rate for Payment

L85

Real SignOn date (sea service activity)

L85: in the same date format as selected on the computer;

L85a: In the format YYYYMMDD;

L85d: In the real data format;

L85h: P03.SONTIME hour value;

L86

Date from of activity (sea service activity)

L86a

Date from of activity (sea service activity) in format YYYYMMDD

L86d

Date from of activity (sea service activity) in real data format

L86n

Date from of activity (regardless limitation of sea service option) in format YYYYMMDD

L86m

Date from of activity (regardless limitation of sea service option) in real data format

L87

Real days onboard up to end of current period (sea service activity)

L88

Employer fee rate

L89

Count of period for this entry code in this year

L90b

Leave days balance B/F of auto payroll entry

L90c

Leave days balance C/F of auto payroll entry

L91

Giving number of Sundays in the activity period within the current period.

L92

Giving number of Saturdays in the activity period within the current period.

L93

Giving number of holidays in the activity period within the current period.

L93a

Giving number of holidays in the activity period within the current period, excluding Sundays (if it corresponds to a holiday)

L93b

Returns the number of Public Holidays excluding Saturdays

L93c

Returns the number of Public Holidays excluding Saturdays and Sundays

L93t

Number of weekend days + holidays in the payroll period. The days are calculated based on the calendar linked to the person's payscale. If no link exists, the calendar in the person's client (organization) will be used.

L94

Giving number of Monday in the activity period within the current period.

L96

First two characters of vessel location name for a auto entry (split by vessel location)

L96a

Vessel location code for a auto entry (split by vessel location)

L97

Auto Entry (Y/N)

L98

Balance action of additional info

L99

Leave days of activity on Fromdate and Todate of payroll entry

L100

Returns the number of Mondays for current period

L101

Quantity1

L102

Quantity2

L103 

Returns number of weeks worked per activity, inside a payroll period.

Calculation rules:
1) A week is not count twice if there are 2 activities in the same week.
2) If a person gets 65 years old inside period - weeks are count only before 65 years.
3) Related activity should belong under vessel where flag ='MT'. 
4) Week should be counted when at least one day covered(doesn`t matter in the middle of the week or not) if this week was not counted earlier. For example in previous period or with other auto-entry in current period.(APM-4374)

L104

Returns number of weeks worked per activity, inside a payroll period.

Calculation rules:

1. It returns number of weeks worked per activity, inside a payroll period.

2. A week is not count twice if there are 2 activities in the same week.

3. A week is not count if Monday of that week started in the previous month.

4. If a person gets 65 years old inside period - weeks are count only before 65 years.

5. If the Datefrom of payroll entry = First date of the week, then this week is count.

6. If Datefrom starts in a middle-week, then check if exists any other auto entry in the current period which covers the week, if yes, then not count the week this time. If it doesn't exist such auto entry, then count the week.

7. For weeks after the first week, payroll entry will count each Monday it covers.

8. For the first week of period, if an entry with DateFrom middle in this week, this week is NOT count;

L107

Counts all the holidays (from Monday to Friday) between the FromDate and ToDate of the payroll entry.

L107a

Locates all the weeks that intersect the FromDate - ToDate of the payroll entry, and counts all the holidays (from Monday to Friday) within those weeks.

L111

Account No of calculated Amount 1

L112

Account No of calculated Amount 2

L113

Account No of calculated Amount 3

L114

Account No of calculated Amount 4

L115

Account No of calculated Amount 5

L116

Account No of calculated Amount 6

L117

Account No of calculated Amount 7

L118

Account No of calculated Amount 8

L119

Account No of calculated Amount 9

L120

Account No of calculated Amount 10

L121

Account No of calculated Amount 11

L131

Flag of calculated amount 1

L132

Flag of calculated amount 2

L133

Flag of calculated amount 3

L134

Flag of calculated amount 4

L135

Flag of calculated amount 5

L136

Flag of calculated amount 6

L137

Flag of calculated amount 7

L138

Flag of calculated amount 8

L139

Flag of calculated amount 9

L140

Flag of calculated amount 10

L141

Flag of calculated amount 11

L151

Account No of calculated amount credit 1

L152

Account No of calculated amount credit 2

L153

Account No of calculated amount credit 3

L154

Account No of calculated amount credit 4

L155

Account No of calculated amount credit 5

L156

Account No of calculated amount credit 6

L157

Account No of calculated amount credit 7

L158

Account No of calculated amount credit 8

L159

Account No of calculated amount credit 9

L160

Account No of calculated amount credit 10

L161

Account No of calculated amount credit 11

L162

Activity Code (overwritten input of activity code by validity check)

L163

Activity date to --In current Windows format (string)

L163d

Activity date to -- in days

L164

Indicating real sign off date on the same vessel. If no DateTo, then fetch EED. (works with Current and Historical activities)

L164: in the same date format as selected on the computer;

L164a: in YYYYMMDD format;
L164e: in real date format;
L164d: in real date format;
L164h: P03.SOFFTIME hour value;

L165

Indicating real sign off date regardless of the vessel. If no DateTo, then fetch EED. (works with Current and Historical activities)

L165: in the same date format as selected on the computer;

L165a: in YYYYMMDD format
L165d: in real date format with 2 decimals
L165e: in real date format with 8 decimals
L165h: P03.SOFFTIME hour value;

L166

Date to or Estimated end date of last historical payroll entry.

L166: in the same date format as selected on the computer;

L166a : in YYYYMMDD format;
L166e: in real date format;

L167

Indicating real sign off date on same vessel (for open activity also)

L167: in the same date format as selected on the computer;

L167a : in YYYYMMDD format;
L167e: in real date format;
L167h: P03.SOFFTIME hour value;

L168

Indicating real sign off date regardless vessel (for open activity also)

L168: in the same date format as selected on the computer;

L168a : in YYYYMMDD format;
L168e: in real date format;
L168h: P03.SOFFTIME hour value;

L169

Indicating real sign off date by employer(if DateTo empty, EED will be used)

L169: in the same date format as selected on the computer;
L169a: in YYYYMMDD format;
L169e: in a real date format;
L169h: P03.SOFFTIME hour value;

L178a

Seaservice Seniority years at Payroll period Start

L178b

Seaservice Seniority months at Payroll period Start

L178c

Seaservice Seniority days at Payroll period Start

L179a

Seaservice Seniority years at Payroll period end

L179b

Seaservice Seniority months at Payroll period end

L179c

Seaservice Seniority days at Payroll period end

L180

Allowance or Deduction? 'A' or 'D'

L181

Last activity vessel in current period under the employer of entry record.

L182

to fetch Sign On extra days from pw001p01

L183

to fetch Sign Off extra days from pw001p01

L185

to fetch Payroll additional info, bank account nr

L186

to fetch the Plan rate of Benefit record covering current period for a person

L187

Payment bank ID

L187a

Payment bank account No.

L187b

Payment bank code

L187c

Payment bank currency code

L191 - L195

Return number of weekday calendar days that are not public holidays in the activity period within the current payroll period.

L191 – for number of Mondays

L192 - for number of Tuesdays

L193 - for number of Wednesdays

L194 - for number of Thursdays

L195 - for number of Fridays

L196

Returns the Holiday Name, if the payroll entry’s FromDate (L19) corresponds to a holiday from a calendar linked to the entry Payscale Table/Code

L991

Numorgid of employer of pw001p01.client.

L992

Numorgid of employer above vessel in (DIM2) and

L990

the field employer of entry (PAY or PYH), default is L991

L1101

Calculated Amount 1 used for back pay

L1102

Calculated Amount 2 used for back pay

L1103

Calculated Amount 3 used for back pay

L1104

Calculated Amount 4 used for back pay

L1105

Calculated Amount 5 used for back pay

L1106

Calculated Amount 6 used for back pay

L1107

Calculated Amount 7 used for back pay

L1108

Calculated Amount 8 used for back pay

L1109

Calculated Amount 9 used for back pay

L1110

Calculated Amount 10 used for back pay

L1111

Calculated Amount 11 used for back pay

PR

(PR1, PR2 etc) - Personal Rate

X

Xn (X1, X2 etc) - Payscale Rate

XA

XAn (XA1) - Payscale Rate column A

XB

XBn (XB1) - Payscale Rate column B etc.

Xs

Xns (X1s, X2s) - Payscale Rate by sea-service seniority

P1

PIN

P2a

Family Name

P2b

Christian Name

P2f

First Name

P2m

Middle Name

P2l

Last Name

P2s

Name Suffix

P2t

Title Name

P3

Address 1

P4

Address 2

P5

Postal Code

P5c

Council code to post ZIP code

P5y

Postal Code + Name

P5e

If Post Code is blank, return Address3

P6

Nationality Code

P6a

Nationality Name

P6b

Nationality Leave Time Factor

P6y

Nationality Code+Name

P6z

Nationality Code Group

P7

Home Telephone Number

P8

Sex: M/K/F

P9

Yrkesgruppe Department (previously P152 )

P9a

Department Name

P9y

Department Code+Name

P9z

Department Code Group

P10

Org unit NumorgId where person is linked to in Personal Details

P10a

Org unit Name where person is linked to

P10c

First Company Code

P10y

Org unit No+Name

P10d

Department Code

P10e

Department Name

P10f

Position Org Code

P10g

Position Name

P10h

Vessel Code

P10i

Vessel Name

P10m

Mother Company Org Code

P10n

Mother Company Name

P10o

Mother Company Org Nr ID

P11

Category A

P11a

Category A Name

P12

Category B

P13

Category C

P14h

P14a

Person Id No

P15

P15d

Employment Start Date

Employment Start Date in format yyyymmdd

P15f

Days employed to today

P15g

Days employed to the end of period

P15e

Employement Start date in real date value

P16

Employment End Date

P16e

Employment End date in real date value

P17

Comments

P18

Rank Code

P18a

Rank Name

P18s

Rank Code Specification

P18x

Rank Category

P18y

Rank Code + Name

P18z

Rank Group No.

H0

Data Group Type (=3 for activities)

H1

Activity Code

H1a

Code Text

H1y

Code + Text

H1c

Code Group

H2

Code Group

H3

Date From

H4

Date To

H5

Date From

H6

Date To

H7

Date To

H30

Number of days

H31

Leave days

H31a

Leave days in current period

H31g

Leave Days with 2 decimals only

H32

Place from

H33

Place to

H34

Vessel No

H34a

Vessel Name

H34b

First Company's name

H34c

First Company's Org code

H34d

First Department's Org code

H34e

First Department's name

H34f

First Position's Org code

H34g

Position's name

H34j

Position's Org code without colon and number

H34y

First Vessel's Org nummer ID + Name

H35

Rank

H35a

Rank Name

H35b

Payscale for the Rank

H35c

Leave Factor for the Rank

H35p

Activity Rank category from Position

H35x

Activity Rank category

H35y

Rank Code + Name

H35z

Code Group for the Rank

H36

Comments

H37

Relief

H38

Payscale Code

H39

Gammel båtkode, konvertert fra PERMA

H54a

Company accounting code

H54b

Vessel accounting code

H54c

Department accounting code

H54d

Position accounting code

H95

Returns number of Monday for the whole activity

H95s

Number of Sundays in the activity

H96

Number of holidays for an activity based on its payscale calendar

H97

Number of Saturdays in the activity

H131

Flag Code

H132

Vessel Type

H133

Vessel Tonnage

H134

Vessel Engine Type

H135

Vessel Operator

H136

Planned

H137

Seniority

H138

Estimated End date

H142

Department code for activity. Returns department even if activity is linked to a position below department

H151

Additional field1 in Activity

H152

Additional field2 in Activity

H153

Additional field in Activity

H154

Additional field4 in Activity

H155

Additional field5 in Activity

H156

Additional field6 in Activity

H157

Additional field7 in Activity

H158

Additional field8 in Activity

H159

Additional field9 in Activity

H160

Additional field10 in Activity

H161

Additional field11 in Activity

H162

Additional field12 in Activity

H163

Additional field13 in Activity

H164

Additional field14 in Activity

H165

Additional field15 in Activity

H166

Additional field16 in Activity

H167

Additional field17 in Activity

H168

Additional field18 in Activity

H169

Additional field19 in Activity

H170

Additional field20 in Activity

H239

Project Code

H239a

Project Name

H239b

Project Code + Name

H238

Cost Place

H237

Cost Group

H337

Activity Class

H234

Markup Amount

H235

Markup %

H236

Management Fee

H256

The field that return count of pre-holiday days based on dates of activity

H257

Returns Sign Off date (Sea service activity) before the leave activity

H258

Indicating real sign off date regardless of the vessel.

H258a: in YYYYMMDD format
H258d: in real date format with 2 decimals (If no date to, then fetch Estimated date)
H258e: in real date format with 8 decimals (If no date to, then fetch Estimated date)

H259

Indicating real sign off on the same vessel.

H259a: in YYYYMMDD format
H259d: in real date format with 2 decimals (If no date to, then fetch Estimated date)
H259e: in real date format with 2 decimals (If no date to, then fetch Estimated date)

H260

Indicating Date to or Estimated end date of last historical (HISTORICAL.PW001P03=T) activity.

H260a : in YYYYMMDD format
H260e: in real date format with 2 decimals (If no date to, then fetch Estimated date)

H261

Indicating real sign off date on the same vessel (for open activity also);

H261a: in YYYYMMDD format

H261e: in real date format with 2 decimals (If no date to, then fetch EED)

H262

Indicating real sign off date regardless of the vessel (for open activity also)

H262a: in YYYYMMDD format

H262e: in real date format with 2 decimals (If no date to, then fetch EED)

H263

Indicating real sign off date by employer(if DateTo empty, EED will be used)

H263: in the same date format as selected on the computer;
H263a: in YYYYMMDD format;
H263e: in a real date format;

H298

Extra Activity Sign On Code

H298a

Extra Activity Sign On Text

H299

Extra Activity Sign Off Code

H299a

Extra Activity Sign Off Text

H330

PayScale Table

H336

Pension fund Class

H338

Vessel Cost Group

H339

Vessel Cost Place

H333

Status

H430

Person Notified

H431

Competence Checked

H432

Manning agent Informed

H433

Master Informed

H434

Crew Change Completed

H248

Sign On Extra Days (from activity details)

H249

Sign Off Extra Days (from activity details)

H466

Disembarkation Reason Code

H40

Issued by

H41

Issued place

H42

Comments

H43

Marks

H44

Rank

H44a

Rank Name

H44b

Payscale Code for the Rank

H44c

Leave Factor for the Rank

H44y

Rank Code + Name

H44z

Code Group for the Rank

H45

Vessel No

H45a

Vessel Name

H45y

Vessel No + Name

H50

Issued by

H51

Issued place

H52

Comments

H53

No

H54

Expiry date

H60

Priority ("1".."9")

H61

Name

H62

Address (lines are separated by comma)

H63

Relationship code

H63a

Relationship text

H63y

Relationship code + text (separated by colon)

H63z

Relationship code group

H64

Phone

H65

Comments

H66

Birth date

H67

Birth Place

H68

Sex

H77

Occupation

H70

Issuing Authority

H71

Country

H72

Date issued

H73

Expiring date

H74

Comments

H80

Visa No

H81

Date Visa applied for

H82

Time delay for issue of Visa

H83

Comments

All units

G1

Code

G2

Name

G3

Superior code

Concern

GA

Concern Rate A

GB

Concern Rate B

GM

Concern Rate M

GN

Concern Rate N

CM

Company overridable Rate M

CN

Company overridable Rate N

Company

CA

Company Rate A

CB

Company Rate B

CM

Company Rate M

CN

Company Rate N

C1

Code

C2

Name

C3

Superior code

Vessel

VA

Vessel Rate A

VB

Vessel Rate B

V1

Name

V2

Org Code

V3

OrgId Above

V4

Short Name

V20

Call Sign

V21

Trade Type

V22

Valid From

V23

Port Of Registry

V24

Satcom/Selcal No.

V25

Built Year

V26

Built Place

V27

Built Hull No.

V30

Currency Code

V31

Pension Fund No

V32

Provident Fund No

V33

Bank Account For Net Pay : Bank Name1

V34

Bank Account For Net Pay : Bank Name2

V35

Bank Account For Net Pay : Bank Name3

V36

Bank Account For Net Pay : Bank Name4

V37

Bank Account For Net Pay : Bank Name5

V70

Vessel Register Code

V70a

Vessel Register Text

V70y

Vessel Register Code : Text

V70z

Vessel Register Group No

V72

Register Flag Code

V72a

Register Flag Text

V72y

Register Flag Code : Text

V72z

Register Flag Group No

V73

Register Date

V74

Vessel Type Code

V74a

Vessel Type Text

V74y

Vessel Type Code : Text

V74z

Vessel Type Group No

V75

Pension Fund no

V76

Category A Code

V76a

Category A Text

V76y

Category A Code : Text

V76z

Category A Group No

V76

Category B Code

V76a

Category B Text

V76y

Category B Code : Text

V76z

Category B Group No

V76

Category C Code

V76a

Category C Text

V76y

Category C Code : Text

V76z

Category C Group No

V81

DWT

V82

GRT

V83

NRT

V84

Length

V85

Breadth

V86

Draught

V87

Offical Ship No

V88

DPS Type

V89

Class. Society

V90

Vessel IMO

V112

Vessel Cost Group Code

V112a

Vessel Cost Group Text

V112y

Vessel Cost Group Code : Text

V112z

Vessel Cost Group Group No

V113

Vessel Cost Place Code

V113a

Vessel Cost Place Text

V113y

Vessel Cost Place Code : Text

V113z

Vessel Cost Place Group No

V114

Pension Fund Class Code

V114a

Pension Fund Class Text

V114y

Pension Fund Class Code : Text

V114z

Pension Fund Class Group No

V200

Vessel Owner Number - Pick up and return the Client/Debitor No of the Shipowner as it is set under vessel management

V200a

Vessel Owner Name - Pick up and return the Shipowner name as it is set under Vessel Management

C21

Contract ID

C22

Contract kind

C23

Contract start date

C24

Contract end date

C25

Payroll seniority start date

C26

Payroll seniority end date

C27

Payroll seniority prev years

C28

Payroll seniority up to this period

C29

Sea service seniority start date

C30

Sea service seniority end date

C31

Sea service seniority prev years

C32

Sea service seniority up to this period

C33

Contract payscale table

C34

Contract payscale code

С35

Contract type: code + name

С35a

Contract type: code

CRn

CR => Contract Personal Rates

n => identifies the rate number RATENO in the contract
personal rates table. The rate nr is defined in the general code
table defining the rate fields.

C36

Real End Date for the Contract.

Means if Main contract has Amendment and even few Amendments,
this field will fetch the End Date of the last Amendment related to the
Main Contract.

For Sub Contracts this field will just fetch it`s End Date.

C37

Payroll Vessel in Contract

Note: All date fields can have suffix:

a : YYYYMMDD format

d : Real date format

IncDateBy(Date: String; Type: String; NumberOf: Integer): DateTime

The function converts the date calculations into a real date text format. 

Returns a date shifted by a specified number of days or months or years.
IncDateBy returns the value of the Date parameter, incremented by NumberOf days or months or years according to Type option. NumberOf can be negative.

• Date - it should be as "YYYYMMDD" format.

• Type - "d" day, "m" - month, "y" - year.

• NumberOf - number of days or months or years.

• Result - new date in real date format.

L25=IncDateBy (P603a,"d",W1) - can be used to show the date that corresponds to Current period start date (P603a) + nr of days ("d") defined by internal accumulator W1.

E.g.:

P603a=20210101

W1=14

L25=20210101+14=44211

DateToString(Date : DateTime) : string

Converts a DateTime value into a string.

• Date - it should be as date in DateTime format.

• Result - date in "YYYYMMDD" format.

Can be used if some field or expression needs to be converted from real date format to string.

e.g. L167e=44429

DateToString(L167e) will return 20210821

StringToDate(Date : string) : DateTime

Converts a string to a DateTime value.

• Date - it should be as "YYYYMMDD" format.

• Result - date in TDateTime format.

Can be used if some field or expression needs to be converted from string format to real date.

e.g. L167a=20210821

StringToDate (L167a) will return 44429