Payroll | Payroll Import Types | Details tab | Import Type field
Summary |
ADS ADT format |
Field Number |
Field Name |
Format |
Comment |
1 |
EmployeeCode |
Char 12 |
Mandatory |
2 |
AllowanceCode |
Char 12 |
Mandatory |
3 |
Quantity |
Double |
Mandatory |
4 |
Date |
Date |
Optional |
5 |
CostCentreCode |
Char 12 |
Optional |
6 |
JobCode |
Char 12 |
Optional |
7 |
AwardCode |
Char 12 |
Optional |
8 |
PositionCode |
Char 12 |
Optional |
9 |
RateCode |
Char 12 |
Optional |
10 |
RateAmount |
Double |
Optional |
11 |
Factor |
Double |
Optional |
12 |
TotalAmount |
Double |
Optional |
13 |
Recalculate |
Boolean |
Optional |
14 |
ReasonCode |
Char 12 |
Optional |
15 |
Rank |
Char 2 |
Optional |
16 |
Text |
Char 30 |
Optional |
17 |
ReduceQuantity |
Double - max of 999.99 |
Optional |