Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

There are several fields from the record in payroll, that can be used or set in FAQ Payroll Script. Below is an overview of all these fields.

...

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

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 for customized view

H152

Additional field2 for customized view

H153

Additional field3 for customized view

H154

Additional field4 for customized view

H155

Additional field5 for customized view

H156

Additional field6 for customized view

H157

Additional field7 for customized view

H158

Additional field8 for customized view

H159

Additional field9 for customized view

H160

Additional field10 for customized view

H161

Additional field11 for customized view

H162

Additional field12 for customized view

H163

Additional field13 for customized view

H164

Additional field14 for customized view

H165

Additional field15 for customized view

H166

Additional field16 for customized view

H167

Additional field17 for customized view

H168

Additional field18 for customized view

H169

Additional field19 for customized view

H170

Additional field20 for customized view

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)

...

Organization and Vessel Fields - G, C, V

All unitsd

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

...