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” |