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.
 DP1 Header Record
DP1 Header Record