| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | YEAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 2 | YEDATE01 | Date 01 | Date | Generic Edit | 6 | 0 | |
| 3 | YEEV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 4 | YEFTC | Table Code | String | Generic Edit | 5 | 0 | Allow NULL? |
| 5 | YEP01 | Category Codes - Position 01 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 6 | YEP02 | Category Codes - Position 02 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 7 | YEP03 | Category Codes - Position 03 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 8 | YEP04 | Category Codes - Position 04 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 9 | YEP05 | Category Codes - Position 05 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 10 | YEADPLOCMI | EE Location Code Michigan | String | Generic Edit | 6 | 0 | Allow NULL? |
| 11 | YEADPLOCMN | EE Location Code Minnesota | String | Generic Edit | 6 | 0 | Allow NULL? |
| 12 | YEADPMISC1 | ADP Miscellaneous Field 1 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 13 | YEADPMISC2 | ADP Miscellaneous Field 2 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 14 | YEADPMISC3 | ADP Miscellaneous Field 3 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 15 | YEADPMISC4 | ADP Miscellaneous Field 4 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 16 | YEADPMISC5 | ADP Miscellaneous Field 5 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 17 | YEADPMISC6 | ADP Miscellaneous Field 6 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 18 | YEADPMISC7 | ADP Miscellaneous Field 7 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 19 | YEADPMISC8 | ADP Miscellaneous Field 8 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 20 | YEADPMISC9 | ADP Miscellaneous Field 9 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 21 | YEADPMISC0 | ADP Miscellaneous Field 10 | String | Generic Edit | 20 | 0 | Allow NULL? |