ADP Transactions Import File Format

The ADP file should not be encrypted. The file consists of the following records:

ClosedDP1 Header Record

Field

Field Name

Start

End

Value

1

Header Indicator

1

3

DPI

2

Filler

4

61

 

3

Encryption Flag

62

64

000=Not encrypted
001=Encrypted

4

Filler

65

80

 

ClosedFile Identifier Record

Field

Field Name

Start

End

Value

1

Record Indicator

1

1

A

2

Version Number

2

6

01.00

3

File Type Identifier

7

8

G/L

4

Company Code

9

11

 

5

Year

12

15

 

6

Week Number

16

17

 

7

Payroll Number

18

18

 

8

Filler

19

19

 

9

Constant

20

21

00

10

Client Code

22

26

 

11

Accounting Period Date

27

33

MMMDDYY (MMM = the first 3 characters of the month, e.g. JAN, FEB)

12

Run Date

34

39

MMDDYY

13

Constant

40

79

GL DOWNLOAD DATA

14

Number of Fields

80

82

 

15

Record Size

83

86

 

ClosedField Identifier Record

This record starts with a B and helps identify the data record columns. It defines what the field is and what the size and data type of the field is.

Field

Field Name

Start

End

Value

1

Record Indicator

1

1

B

2

Field Name

2

39

See Data Record C Field Name for value.

3

Field Length

40

41

Length of field in C record.

ClosedData Record

Field

Field Name

Start

End

Value

1

Record Indicator

1

1

C

2

Client Code

2

6

 

3

G/L Account Number

7

30

The first 5 characters are the Entity ID and the remainder is the G/L Account Number.

4

Journal Source Code

31

32

PR

5

Date

33

37

MMDDY

6

Amount

38

48

Do not include the decimal point as this value is divided by 100 to compute the amount.

7

Reference-1

49

54

 

8

Description

55

74

 

9

Reference-2

75

80

 

10

Reference-3

81

86

 

11

Filler

87

94

 

12

Record Code

95

96

 

13

Filler

97

100

 

ClosedTrailer Record

Field

Field Name

Start

End

Value

1

Record Indicator

1

1

Z

2

Number of Records

2

7

Formatted as 00000N

See Also

Data Transfer File Formats Introduction

ADP Import Transactions Tab