| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | GLPOST | G/L Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 2 | GLUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | GLANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 | Allow NULL? |
| 4 | GLCTRY | Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 5 | GLFY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | GLCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 7 | GLLT | Ledger Types | String | UDC (09 LT) | 2 | 0 | Allow NULL? |
| 8 | GLSBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | GLAM | Account Mode - G/L | Character | UDC (H09 AM) | 1 | 0 | Allow NULL? |
| 10 | GLR1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | GLR2 | Reference 2 | String | Generic Edit | 8 | 0 | Allow NULL? |
| 12 | GLDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 13 | GLAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 14 | GLASID | Serial Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 15 | GLDGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 16 | GLPN | Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 17 | GLEXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 18 | GLEXR | Name - Remark Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 19 | GLAA | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | GLU | Units | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | GLJELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 | Allow NULL? |
| 22 | GLMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 23 | GLOBJ | Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 24 | GLSUB | Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 25 | GLSBLT | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 26 | GLWR01 | Categories - Work Order 01 | String | UDC (00 W1) | 4 | 0 | Allow NULL? |
| 27 | GLJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 28 | GLJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 29 | GLHMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 30 | GLCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 31 | GLCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 32 | GLPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | GLUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 34 | GLKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 35 | GLICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 36 | GLLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 37 | GLCRDC | Currency Code - To | String | Generic Edit | 3 | 0 | Allow NULL? |
| 38 | GLACR | Amount - Currency | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 39 | GLCRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |