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