This format is a fixed length format (SDF) file that creates new accounts or overwrites existing ones. This file is designed for interfacing with legacy applications.
GL Transactions Import File Format — SDF
|
Field |
Field Name |
Type |
Length |
Description |
|
1 |
Company # |
Character |
2 |
|
|
2 |
Project # |
Character |
3 |
|
|
3 |
Tran Type |
Character |
2 |
JE = Journals |
|
4 |
Tran Date |
Numeric |
6 |
Use the format YYMMDD. |
|
5 |
Journal/Check# |
Numeric |
6 |
|
|
6 |
Description |
Numeric |
30 |
|
|
7 |
GL Acct Major |
Numeric |
4 |
|
|
8 |
GL Acct Minor |
Numeric |
3 |
|
|
9 |
GL Acct Sub |
Numeric |
3 |
|
|
10 |
Amount |
Numeric |
12 |
|
|
11 |
Reference |
Numeric |
15 |
|
|
12 |
Posting Period |
Numeric |
4 |
Use the format YYMM. |
|
13 |
Batch Period |
Numeric |
4 |
Use the format YYMM. |
|
14 |
Reversal Flag |
Numeric |
1 |
Blank = No reversal. |
|
15 |
CR/LF |
Numeric |
2 |
This field is a carriage return/line feed. |
See Also
Data Transfer File Formats Introduction
GL Transactions Import File Format CSV
GL Transactions XML File Format
Copyright © 2018 Infor. All rights reserved. www.infor.com.