| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | WACO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | WAFY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 3 | WAPN | Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 4 | WAR021 | Category Code - G/L 021 | String | UDC (09 21) | 10 | 0 | Allow NULL? |
| 5 | WAR022 | Category Code - G/L 022 | String | UDC (09 22) | 10 | 0 | Allow NULL? |
| 6 | WAR023 | Category Code - G/L 023 | String | UDC (09 23) | 10 | 0 | Allow NULL? |
| 7 | WADOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | WADCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 9 | WADGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 10 | WAEXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 11 | WAEXR | Name - Remark Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 12 | WASBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | WASBLT | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 14 | WALT | Ledger Types | String | UDC (09 LT) | 2 | 0 | Allow NULL? |
| 15 | WAPOST | G/L Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | WABGBL | Amount - Beginning Balance | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | WACREE | Credits Entered | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | WADEBE | Debits Entered | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | WAOBJ | Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 20 | WASUB | Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 21 | WAR2 | Reference 2 | String | Generic Edit | 8 | 0 | Allow NULL? |
| 22 | WARCND | Reconciled Code | Character | UDC (09 RC) | 1 | 0 | Allow NULL? |
| 23 | WAMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 24 | WARE | Reverse or Void (R/V) | Character | UDC (H09 RE) | 1 | 0 | Allow NULL? |
| 25 | WAICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 26 | WAICUT | Batch Type | String | UDC (98 IT) | 2 | 0 | Allow NULL? |
| 27 | WAREG# | Registration Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | WACRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
