The ADP file should not be encrypted. The file consists of the following records:
Field |
Field Name |
Start |
End |
Value |
1 |
Header Indicator |
1 |
3 |
DPI |
2 |
Filler |
4 |
61 |
|
3 |
Encryption Flag |
62 |
64 |
000=Not encrypted |
4 |
Filler |
65 |
80 |
|
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 |
|
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. |
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 |
|
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
Copyright © 2018 Infor. All rights reserved. www.infor.com.