Previous page

Next page

Importing to Payroll - PayGlobal PTCSV format

Payroll | Payroll Import Types | Details tab | Import Type field

Summary

 

Comma-separated format.

Null values should contain no data between commas.

Field Number

Field Name

Format

Comment

1

EmployeeCode

Char 12

Mandatory

2

AwardCode

Char 12

Optional

3

CostCentreCode

Char 12

Optional

4

JobCode

Char 12

Optional

5

AllowanceCode

Char 12

Mandatory

6

ReasonCode

Char 12

Optional

7

Quantity

Double - Rounds to 2 decimal places

Mandatory

8

RateCode

Char 12

Optional

9

RateAmount

Double - Rounds to 4 decimal places

Optional - If supplied, then PayGlobal forces the rate code to be the first override rate.

10

Factor

Double - Rounds to 4 decimal places

Optional

11

TotalAmount

Double - Rounds to 2 decimal places

Optional

12

Recalculate

Logical - Y/N

Optional

13

Date

Date - yyyymmdd

Optional

14

WAPCode

Char 12

Optional - Will be added only if Company Settings | Transactions tab | Edit WAP Codes = "Yes".

Previous page

Next page