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.
...
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, “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:
|
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: |
L104 | 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 |
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 |
...
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 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 |
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) |
H466 | Disembarkation Reason Code |
...