Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
title15.3 and below

CSV File Format

 

Column

Data

Required

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”

Sample Import File

Import GL from csv sample.csv