External File Format Requirements for Payroll
The table below contains the external file format requirements for Payroll if you do not have Job Cost installed.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Field Length2
 
Character Position
(Fixed-Length Format)3
 
Data Type
1
* Employee number4
 
25
1
Char-Caps
2
Transaction date
10
26
mm/dd/yyyy
3
* Pay rate code4
 
6
36
Char-Caps
4
Project code
10
42
Char-Caps
5
Regular units
12 (7.4)
52
Numeric
6
Other time 1 units
12 (7.4)
64
Numeric
7
Other time 2 units
12 (7.4)
76
Numeric
8
Vacation
12 (7.4)
88
Numeric
9
Sick
12 (7.4)
100
Numeric
10
PTO
12 (7.4)
112
Numeric
11
Holiday
12 (7.4)
124
Numeric
12
Compensation
12 (7.4)
136
Numeric
13
Other
12 (7.4)
148
Numeric
14
* End of Record
2
160
 

1 This number is for reference purposes only and will not appear in the text file.

2 If the file format is tab or semi-colon delimited, any characters over the specified length are cut off at the length limit. If the file format is fixed length (column position), each field must be the exact length shown in the Maximum Field Length column.

3 If the field doesn’t start in the character position specified, it will create an error and prohibit the units from being imported.

4 If this field is left blank, this employee will not import. To enable the import, the employee number must be set up in Denali before you import daily units.

The table below contains the external file format requirements for Payroll if you have Job Cost installed.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Field Length2
 
Character Position
(Fixed-Length Format)3
 
Data Type
1
* Employee number4
 
25
1
Char-Caps
2
Transaction date
10
26
mm/dd/yyyy
3
* Pay rate code4
 
6
36
Char-Caps
4
Job Number
20
42
Char-Caps
5
Phase Code
20
62
Char-Caps
6
Process Code
20
82
Char-Caps
7
Project code
10
102
Char-Caps
8
Regular units
12 (7.4)
112
Numeric
9
Other time 1 units
12 (7.4)
124
Numeric
10
Other time 2 units
12 (7.4)
136
Numeric
11
Equipment Units
12 (7.4)
148
Numeric
12
Units Produced
12 (7.4)
160
Numeric
13
Vacation
12 (7.4)
172
Numeric
14
Sick
12 (7.4)
184
Numeric
15
PTO
12 (7.4)
196
Numeric
16
Holiday
12 (7.4)
208
Numeric
17
Compensation
12 (7.4)
220
Numeric
18
Other
12 (7.4)
232
Numeric
19
* End of Record
2
244
 

1 This number is for reference purposes only and will not appear in the text file.

2 If the file format is tab or semi-colon delimited, any characters over the specified length are cut off at the length limit. If the file format is fixed length (column position), each field must be the exact length shown in the Maximum Field Length column.

3 If the field doesn’t start in the character position specified, it will create an error and prohibit the units from being imported.

4 If this field is left blank, this employee will not import. To enable the import, the employee number must be set up in Denali before you import daily units.

 
 
 
 
Published date: 06/04/2021