| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | G1CO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | G1TOR | Type of Return - 1099 Work File | String | UDC (04 TR) | 2 | 0 | Allow NULL? |
| 3 | G1TAX | Tax ID | String | Generic Edit | 20 | 0 | Allow NULL? |
| 4 | G1AN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | G1AA | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 6 | G1AT1 | Search Type | String | UDC (01 ST) | 3 | 0 | Allow NULL? |
| 7 | G1AT2 | AR/AP Netting Indicator | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 8 | G1AT3 | HRM Records Exist | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 9 | G1AT4 | Address Type - 4 | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 10 | G1AT5 | Address Type - 5 | Character | UDC (H01 AV) | 1 | 0 | Allow NULL? |
| 11 | G1AC01 | Category Code - Address Book 01 | String | UDC (01 01) | 3 | 0 | Allow NULL? |
| 12 | G1AC02 | Category Code - Address Book 02 | String | UDC (01 02) | 3 | 0 | Allow NULL? |
| 13 | G1AC03 | Category Code - Address Book 03 | String | UDC (01 03) | 3 | 0 | Allow NULL? |
| 14 | G1AC04 | Category Code - Address Book 04 | String | UDC (01 04) | 3 | 0 | Allow NULL? |
| 15 | G1AC05 | Category Code - Address Book 05 | String | UDC (01 05) | 3 | 0 | Allow NULL? |
| 16 | G1AC06 | Category Code - Address Book 06 | String | UDC (01 06) | 3 | 0 | Allow NULL? |
| 17 | G1AC07 | Category Code - Address Book 07 | String | UDC (01 07) | 3 | 0 | Allow NULL? |
| 18 | G1AC08 | Category Code - Address Book 08 | String | UDC (01 08) | 3 | 0 | Allow NULL? |
| 19 | G1AC09 | Category Code - Address Book 09 | String | UDC (01 09) | 3 | 0 | Allow NULL? |
| 20 | G1AC10 | Category Code - Address Book 10 | String | UDC (01 10) | 3 | 0 | Allow NULL? |
| 21 | G1DOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 22 | G1DCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 23 | G1DGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 24 | G1CN | Payment Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 25 | G1DKJ | Date - Check - Julian | Date | Generic Edit | 6 | 0 | |
| 26 | G1EXR | Name - Remark Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 27 | G1EIN | Tax ID - Federal | String | Generic Edit | 20 | 0 | Allow NULL? |
| 28 | G1ST | 1099 State Code | String | UDC (04 ST) | 2 | 0 | Allow NULL? |
