This file is in comma separated format (CSV).
GL Transactions Import File Format — CSV
|
Field |
Field Name |
Type |
Length |
Description |
|
1 |
EntityCompany ID |
|
10 |
The EntityCompany ID. |
|
2 |
Leave blank |
|
|
Leave this field blank. Note that the comma must still appear for comma separated. |
|
3 |
Transaction Type |
|
2 |
JE = Journal Entry |
|
4 |
Transaction Date |
|
8 |
Use the format YYYYMMDD. |
|
5 |
Journal/Check Number |
|
6 |
The journal entry number or check number. |
|
6 |
Description |
|
30 |
This description is the transaction line description. |
|
7 |
GL Account |
|
10 |
Enter the general ledger account number with no formatting or account mask. |
|
8 |
Leave blank |
|
|
Leave this field blank. Note that the comma must still appear for comma separated. |
|
9 |
Leave blank |
|
|
Leave this field blank. Note that the comma must still appear for comma separated. |
|
10 |
Amount |
|
12 |
Enter transaction amount. Use negative for credit amounts. |
|
11 |
Leave blank |
|
|
Leave this field blank. Note that the comma must still appear for comma separated. |
|
12 |
Posting period |
|
6 |
Use the format YYYYMM. |
|
13 |
Batch period |
|
6 |
Use the format YYYYMM, which is the same as posting period. |
|
14 |
Reversal flag |
|
1 |
Blank = no reversal. |
See Also
Data Transfer File Formats Introduction
GL Transactions Import File Format SDF
GL Transactions XML File Format
GL Intercompany Transactions Overview
Copyright © 2018 Infor. All rights reserved. www.infor.com.