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

L22l

Activity Leave days in auto entry time range. It returns the leave days based on the auto entry’s FromDate and ToDate

L22f

Activity Leave days in auto entry time range regarding Signoff day as leave used:

• If the linked activity is a sea service, then it checks if there is a continuous sea service after it. If not, and the auto entry ToDate is the End-date of the activity, then the Signoff day should be decreased by 1 day.

• If the linked activity is a leave activity, then checks if it is the first leave activity after the previous sea service activity. If yes, then the result should be increased by 1 day (Sign Off) of the prior sea service activity.

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

. 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.

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

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

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

1. 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.

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

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

1. 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 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) -

Rate

XA

XAn (XA1) -

Rate column A

XB

XBn (XB1) -

Rate column B etc.

Xs

Xns (X1s, X2s) -

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.

P23s

Code A

P23a

Text

P23z

Code - Sort Code

P28

Seniority Start Date

P28a

Sea Service Seniority Start date

P33

Automatic Pay Rise Code

P38

Comments

P46a

Leave Pay Accounting Factor

P213

Period lock for payroll

P48

Pay Slip Layout No

P49

Comments

P50

Tax Region No

P50a

Company Region Code

P50b

Company Region Tax Zone

P50c

Company Rate for region, after year 2007 P50c=P50d from Company Rate 90 if equal to a1 check Global rate 1 = 14,1%

P50d

New Company Rate for region

P50y

Company Region Code + Region Detail

P54

Tax Table NO

P55

Tax

Percentage NO/FI

P58

Seaman's Deduction

: N/Y

P60

transfer balance (balance action)

P61

Bank Account No

P63

Personal Account No

P47

Currency Code

P69

Alternative LTO-code

P197

Person Group

P143

Options for Wages table

P101

Marital Status Code

P62

Days Employed This Year

P73

Additional Accounting Information

P75

Default relief (PIN)

P85

ADDRESS_COUNTRY

P86

Contract Type: String10, code + name

P86a

Contract Type Code

P87

Seniority End Date

P87a

Sea Service Seniority End Date

P93

AutoTax : Byte (0: None, 1: Norwegian)

P94

TaxExemption (0: Full Deduction, 1:Half, 2:No)

P95

TaxComment:String100

P172

Pre-earned Payroll Seniority Years

P172a

Pre-earned Sea Service Seniority Years

P198

Position Fraction

P128

Mobile Phone No

P157

Division

P223

User name last updated record

P224

Time for last updated record ("yymmddttmm")

P154

Marital Status Code TRANSFERRED TO P101

P102

Relationship Next of Kin

P103

Name Next of Kin

P104

Address Next of Kin

P105

Text special date

P106

Home Airport

P107

Picture no

P108

Family comments

P109

Visa, No

P110

Visa, Expiry Date

P111

Passport, No

P112

Passport, Date of Issue

P113

Passport, Place of Issue

P114

Passport, Authority of Issue

P115

Passport, Date of Expiry

P118

Height

P119

Weight

P120

Passport Comments

P132

Place of Birth

P133

Date of Death

P144

Date of Birth

P144a

Age in years

P144d

Date of Birth in days

P144f

Date of Birth (YYYYMMDD format)

P147

Union Code

P159

Finnish Tax Type ('A' for ALLMÄN, ‘B' for BEGRÄNSAD, 'K’ for KÄLLSKATT

P187

Seaman's Book, Number

P188

Seaman's Book, Issued By

P189

Seaman's Book, Expiry Date

P190

Contract Expiry Date

P196

Contract start date (dd/mm/yyyy)

P251-P270

Accumulators of this period, akk 21-40

P271

Akk 21

P272

Akk 22

P273

Akk 23

P274

Akk 24

P275

Akk 25

P276

Akk 26

P277

Akk 27

P278

Akk 28

P279

Akk 29

P280

Akk 30

P281

Akk 31

P282

Akk 32

P283

Monthly Deduction For Tax At Source (FI tax)

P284

Akk 34

P100

Address 3

P100d

Address 3, or Blank

P142

Person Leave Days Factor

P142a

Leave Days Factor from

override

P148

Airport travel time

P213

Period lock for payroll

P226

Payroll Status

P227

Payroll Type

P228

Crew Pool

P229

Employment Seniority Years

P230

Alternative AS Code

P231

Onboard Days in the current payroll year

P231p

Onboard Days in the PREVIOUS payroll year

P231c

Onboard Days in the current period

P232

Leave Days Balance for the last date of previous payroll month (fetched from the Leave Days Accumulator set on company period)

P232c

Leave Days Balance for the last date of current payroll month (fetched from the Leave Days Accumulator set on company period)

P236

Working Spouse (Y/N)

P237

No of Dependants:

P238

Rotation

P239

Shift Start

P240

Shift Vessel

P241

Currency Payment

P242

Cost Place

P243

PayBankNo

P245

SRC Nummer

P246

Leave Days Deducted Factor

P247

Allowances Claimed

P248

PayrollVessel

P248a

PayrollVessel Name

P248c

 First Company Org code over Payroll Vessel

P248f

PayrollVessel Short Name

P248g

PayrollVessel Org Code

P248y

PayrollVessel NumOrgId ":" Name

P249

TaxInfo

P250

Tax Code for UK Tax

P251

Month Week Basis for UK Tax

P252

Payroll Seniority Years Per Current

Perio

P252a

Payroll Seniority Years Per Current Period Without include Pre Year Seniority

P252s

Payroll Seniority Years Per Sea service

P253

NI Number

P254

UK PayRate

P255

UK PayCategory

P256

Tax Code Number (UK)

P257

Num Period (UK)

P258

Period No (UK)

P259

Use Current

Until: (From V2.31)

P260

Person Region Code

P260y

Company Region Code + Region Detail

P261

Distinct Number of History periods in the

P264

Payroll Vessel Cost Group Code.

P265

US Tax ITIN

P266

US Tax SSN

P267

LEAVEPAY_DEDUC_FACT1

P268

LEAVEPAY_DEDUC_FACT2

P269

First day of the first activity in the current period

P269d

First date (in real date value) of the first activity in the current period

P270

Last day of the last activity in the

curr

P270

d Last date (in real date value) of the

la

P271

Last day of the current period

P271d

Last date (in real date value) of the current period

P272

Transaction Type (Alternantive receiver)

P273

PHONE (Alternative receiver)

P274

GENDER (Alternative receiver)

P275

BRANCHNAME (Alternative receiver)

P276

BIRTHDATE (Alternative receiver)

P280

Tax Card TYpe

P281

Tax Card Date

P282

TAXPERCENTAGEEXTRA

P283

MONTHLYDEDUCTION

P284

COMPENSATION

P285

Address_Country (Alternative

Address in Other folder in PD)

P293

Lifeboat Instruction

P363

ACC63 for the UK Tax year initial (Period 03)

P364

ACC64 for the UK Tax year initial (Period 03)

P367

Income-based Pension Scheme ( Payroll | Constants)

P293

Lifeboat Instruction

P301

Current Promotion Rank Seniority

P302

Returns number of weeks worked per activity, inside a payroll period. A week is not count twice if there are 2 activities in the same week. A week is not count if Monday of that week started in the previous month. If a person gets 65 years old inside period - weeks are count only before 65 years. Related activity should belong under vessel where flag ='MT'. If the Datefrom of payroll entry = First date of the week, then this week is count. 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.
For weeks after the first week, payroll entry will count each Monday it covers. For the first week of period, if an entry with DateFrom middle in this week, this week is NOT counted.

P303

Alternative Address line 1

P304

Alternative Address line 2

P305

Alternative Address line 3

P306

Alternative Address Country

P307

Alternative Address ZIP/Place

P308

Port Sign On

P309

Port Sign Off

P311

Marital Status for tax

P312

Exempt from income tax (Y/N)

P313

 Additional Tax Amount

P315

401(K) - Pre Tax

P316

401(K) -Post Tax

P317

401(K) -PreTax Catch Up

P318

401(K) -Roth

P319

Last activity vessel in current period

P319a

Name of the last vessel in current period

P320

NUMORGID of the vessel from Current activity (or latest historical when no current) but only if activity linked to department or position

P320a

Name of the vessel from Current activity (or latest historical when no current) but only if activity linked to department or position

P321

Department’s Org. ID from Current activity (or latest historical when no current)

P321a

Name of the department from Current activity (or latest historical when no current)

P321b

Department’s Org.Code from Current activity (or latest historical

when no current)

P322a

The vessel from last activity in current payroll period. Activity can be Planned, Historical or Current. If there is no activity in current period, then the vessel will be fetched from previous period.

P323

Table of Person

P338

Shift Code

P499

Person Age dynamic value

P500

Average number of children for all active persons on all ships in the company

P501

Leave 1 Balance pr leave balance date in previous period. If it is blank,pr. den 1. i current period(from calendar,or from period register).

P502

Leave 1 Balance pr. leave balance date in current period. If it is blank, den 31. i current period (evt. 28. eller 30., from calendar, or from period register).

Note: Days "settled via payroll" for current payroll period are not included.

P503

Leave 2 Balance pr. leave balance date in previous period. If it is blank,pr. den 1. i current period (from calendar,or from period register).

P504

Leave 2 Balance pr. leave balance date in current period. If it is blank, den 31. i current period (evt. 28. eller 30., from calendar,or from period register).

P505

Leave 1 days within Leave balance date in previous period to the current period, if leave balance date is blank, get the period from calendar.

P506

Leave 2 days within Leave balance date in previous period to the current period, if leave balance date is blank, get the period from calendar.

P507

Leave days balance per today

P600

To Date from Activity from current period

P600d

To Date from Activity på current periode in real date value

P601

Payroll last date for current period

P601d

Payroll last date for current

period in real date value

P602

Is today payroll day ? "Y"/"N"

P603

Startdate of current period

P603a

Startdate of current period in YYYYMMDD

P603d

StartDate of current period - in days

P604

Enddate of current period

P604a

Enddate of current period in YYYYMMDD

P604d

EndDate of current period - in days

P610

Advance Payment Date for current period

P610d

Advance Payment Date på current

peridoe in real date value

P401-P410

Person User defined Field 1-10

P411

Person Payroll Period First date (in real date value) from period register

P411a

Last date before

P411 in real date value

P411b

Leave days balance date in the last

period in real date value

P411c

Next day of P411c in the last

period in real date value

P411e

Person period First

day in format YYYYMMDD

P411f

Last date before P411 in format YYYYMMDD

P411g

Leave days balance date in the last

period in format YYYYMMDD

P411h

Next day of P411c in the last

period in format YYYYMMDD

P412

Person Payroll period Last date (in real date value) from period register

P412a

Last date before

P412 in real date value

P412b

Leave days balance date in the current

period in real date value

P412e

Person period last

day in format YYYYMMDD

P412f

Last date before P412 in format YYYYMMDD

P412g

Leave days balance date in the current period in format YYYYMMDD

P413

Actual days in period

P415

First Saturday in current period (Windows date format)

P415e

First Saturday in current period (real date format)

P701

Total Activity Days for Activity Group 1 in the current payroll year

P701p

Total Activity Days for Activity Group 1 in the PREVIOUS payroll year

P702

Total Activity Days for Activity Group 2 in the current payroll year

P702p

Total Activity Days for Activity Group 2 in the PREVIOUS payroll year

P710

Total Activity Days for Activity Group 10 in the current payroll year

P710p

Total Activity Days for Activity Group 10 in the PREVIOUS payroll year

P990

Date of today (default format)

P990d

Date of today in real date format

P990e

Today in format YYYYMMDD

P991d

Payment date of current

period in real date value

P991e

Payment date of current period in format YYYYMMDD

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

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

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

returns count of pre-holiday days based on dates of activity

H256c

This field returns count of pre-holiday days during Current Payroll Period based on the dates of the 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

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

Image Modified

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 (MAIN, SUB, AMENDMENT)

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
*added from APM 2023.40.2.1

C38

Contract Rank Code

*added from APM 2024.30

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