You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 3
Next »
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” |
|
Sample Import File
Import GL from csv sample.csv