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 |