The GLFILEMGSI report, GL ASCII Output File, creates formatted fixed-length records of general ledger information that can be saved as an ASCII text file for importing into financial software systems.
The structure of output records appears in the chart: "GLFILEMGSI Output Record Format."
GLFILEMGSI Output Record Format
Position |
Length |
Format |
Description |
---|---|---|---|
1-10 |
10 |
Alphanumeric |
GL account code (determines record sort order) |
11-40 |
30 |
Alphanumeric |
GL account description |
41-41 |
1 |
C or D |
Credit or debit account type |
42-51 |
10 |
Alphanumeric |
Labor segment 1 code |
52-61 |
10 |
Alphanumeric |
Labor segment 2 code |
62-71 |
10 |
Alphanumeric |
Labor segment 3 code |
72-81 |
10 |
Alphanumeric |
Labor segment 4 code |
82-91 |
10 |
01/01/2009 |
Payroll check date |
92-101 |
10 |
Alphanumeric |
GL account miscellaneous information |
102-113 |
12 |
999999.99 |
General ledger dollars |
114-123 |
10 |
999.99 |
General ledger hours |
124-124 |
1 |
Y or N |
Accrual record (Y) or non-accrual record (N) |