Description
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.
Payroll Record Fields - L
| Field | Description |
|---|---|
| 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) |
| 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 |
| 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; |
| 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) |
| 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: |
| 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; |
| 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 |
| 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; |
| 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; |
| 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; |
| 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; |
| 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 |
Personal Information Fields - P
| Field | Description |
|---|---|
| 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. |
P301 Current Promotion Rank Seniority
P23 579 14 0P Payscales Code A
P23a Payscale Text
P23z Payscale Code - Sort Code
P28 221 4 25 Seniority Start Date
P28a Sea Service Seniority Start date
P33 241 2 1PR Automatic Pay Rise Code
P38 251 20 0U Comments
P46a 299 2 12 Leave Pay Accounting Factor
P213 301 1 0U Period lock for payroll
P48 302 2 10 Pay Slip Layout No
P49 304 20 0U Comments
P50 324 2 1K Tax Region No
P50a Company Region Code
P50b Company Region Tax Zone
P50c Company Rate for region, after year 2007 P50c=P50d
P50d New Company Rate for region
P50y Company Region Code + Region Detail
P54 332 2 10 Tax Table NO
P55 334 2 10 Tax % NO
P58 341 1 0U Seaman's Deduction: N/Y
P60 364 1 0U Transfer Balance to next month: Y/N
P61 365 22 01 Bank Account No
P63 387 10 0A Personal Account No
P47 447 3 915 Currency Code
P69 450 2 10 Alternative LTO-code
P197 452 10 922 Person Group
P143 462 12 0U1 Options for Wages table
P101 474 10 804 Marital Status Code
P62 484 3 01 Days Employed This Year
P73 487 12 0AE Additional Accounting Information
P75 342 2 1IX Default relief (PIN)
P85 ADDRESS_COUNTRY
P86 Contract Type: String10, code + name
P86a Contract Type Code
P87 221 4 25 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 519 6 01 Pre-earned Payroll Seniority Years
P172a Pre-earned Sea Service Seniority Years
P198 549 6 0R Position Fraction
P23 579 14 0P Payscales Code A
P128 649 15 0U Mobile Phone No
P157 664 2 10 Division
P223 666 6 0U User name last updated record
P224 672 4 26 Time for last updated record ("yymmddttmm")
P154 701 2 804 Marital Status Code TRANSFERRED TO P101
*P102 703 2 907 Relationship Next of Kin
*P103 705 25 0U Name Next of Kin
*P104 730 50 0U Address Next of Kin
*P105 780 15 0U Text special date
P106 795 20 0U Home Airport
P107 815 4 20 Picture no
P108 819 20 0U Family comments
*P109 839 20 0U Visa, No
*P110 859 4 25 Visa, Expiry Date
P111 863 20 0U Passport, No
P112 883 4 25 Passport, Date of Issue
P113 887 20 0U Passport, Place of Issue
P114 907 10 0U Passport, Authority of Issue
P115 917 4 25 Passport, Date of Expiry
P118 923 1 30 Height
P119 924 1 30 Weight
P120 925 20 0U Passport Comments
P132 1034 20 0U Place of Birth
P133 1054 4 25 Date of Death
P144 1163 4 25 Date of Birth
P144a Age in years
P144d Date of Birth in days
P144f Date of Birth (YYYYMMDD format)
P147 1186 10 921 Union Code
P14 1255 20 00 Personal Id No
P187 1504 8 0U Seaman's Book, Number
P188 1512 30 0U Seaman's Book, Issued By
P189 1542 4 25 Seaman's Book, Expiry Date
P190 1546 4 25 Contract Expiry Date
P251-270 1801 80 22 Accumulators of this period, akk 21-40
P271 1881 4 22 Akk 21
P272 1885 4 22 Akk 22
P273 1889 4 22 Akk 23
P274 1893 4 22 Akk 24
P275 1897 4 22 Akk 25
P276 1901 4 22 Akk 26
P277 1905 4 22 Akk 27
P278 1909 4 22 Akk 28
P279 1913 4 22 Akk 29
P280 1917 4 22 Akk 30
P281 1921 4 22 Akk 31
P282 1925 4 22 Akk 32
P283 1929 4 22 Akk 33
P284 1933 4 22 Akk 34
P100 2119 50 0U Address 3
P100d Address 3, or Blank
P142 2169 12 0F Person Leave Days Factor
P142a Leave Days Factor from payscale override
P148 2181 12 0U Airport travel time
P213 301 1 0U 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 Period
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 Payscale Until: (From V2.31)
P260 Person Region Code
P260y Company Region Code + Region Detail
P261 Distinct Number of History periods in the year
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 current period, if it is a opened activity and activity payscale with option "", it return the day of estimated enddate
P270d Last date (in real date value) of the last activity in the current period
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 Receiver)
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
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)
P323 Payscale Table of Person
P338 Shift Code
P363 ACC63 for the UK Tax year initial (Period 03)
P364 ACC64 for the UK Tax year initial (Period 03)
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
Available field nrs: P271- P314-P322 P328-362 P368-P400 P413-P498 P507-P599 P603- P609 P610- 699 711- 989 991
Activity Record Fields - H
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 |
| H259 | Indicating real sign off on the same vessel. H259a: in YYYYMMDD format |
| H260 | Indicating Date to or Estimated end date of last historical (HISTORICAL.PW001P03=T) activity. H260a : in YYYYMMDD format |
| 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; |
| 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) |
Appraisal Record Fields - H
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 |
Competence Record Fields - H
H50 | Issued by |
H51 | Issued place |
H52 | Comments |
H53 | No |
H54 | Expiry date |
Family Record Fields - H
| 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 |
Medical Record Fields - H
| H70 | Issuing Authority |
| H71 | Country |
| H72 | Date issued |
| H73 | Expiring date |
| H74 | Comments |
Travel Record Fields - H
| H80 | Visa No |
| H81 | Date Visa applied for |
| H82 | Time delay for issue of Visa |
| H83 | Comments |
Organization and Vessel Fields - G, C, V
| 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 |
Contract Datagroup fields - C
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. |
Note: All date fields can have suffix: a : YYYYMMDD format d : Real date format |
Functions that can be used in Payroll scripts
| Function | Description | Example |
|---|---|---|
| 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.
| 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.
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.
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 |