General Ledger CSV format

Column

Data

Length

Special Processing Notes:

A

Year

4

i.e. 2009    If column A and/or column B are left blank, the program

will use the date in column G to get the Year and determine

the Period.

B

Period

2

i.e. 04

C

G/L Account Number

17

Must be formatted as 99999999.99999999 or cross referenced in

the Account Translation Maintenance program.

D

Source System

3

If blank, the program will use “GJE” as the Source System.

E

Source Number

5

Numeric

F

Line Number

6

Numeric

G

Date

8

Formatted as YYYYMMDD

H

Time

8

Numeric, formatted as HH:MM:SS   If blank, the program will use

the system time.

I

Reference

25

Alphabetic

J

Document

25

Alphabetic

K

Comments

25

Alphabetic

L

Debit/Credit

1

The value must be either “D” or “C”.

M

Amount

13

Formatted as 9(10).99

N

Units

17

Formatted as 9(12).9999

O

Correction

1

The value must be either “Y” or “N”