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.

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

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