| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | WNAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 2 | WNIDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 3 | WNAT1 | Search Type | String | UDC (01 ST) | 3 | 0 | Allow NULL? |
| 4 | WNCCAI | Active/Inactive Flag | Character | UDC (11 AI) | 1 | 0 | Allow NULL? |
| 5 | WNEFTW | Effective Date for Address | Date | Generic Edit | 6 | 0 | |
| 6 | WNNTYP | Contact Type | String | UDC (01 CT) | 3 | 0 | Allow NULL? |
| 7 | WNNICK | Nickname | String | Generic Edit | 40 | 0 | Allow NULL? |
| 8 | WNGEND | Gender (Male/Female) | Character | UDC (01 GD) | 1 | 0 | Allow NULL? |
| 9 | WNDDATE | Day of Birth | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 10 | WNDMON | Month of Birth | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 11 | WNDYR | Year of Birth | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 12 | WNWN001 | Category Code - Contact 01 | String | UDC (01 N1) | 3 | 0 | Allow NULL? |
| 13 | WNWN002 | Category Code - Contact 02 | String | UDC (01 N2) | 3 | 0 | Allow NULL? |
| 14 | WNWN003 | Category Code - Contact 03 | String | UDC (01 N3) | 3 | 0 | Allow NULL? |
| 15 | WNWN004 | Category Code - Contact 04 | String | UDC (01 N4) | 3 | 0 | Allow NULL? |
| 16 | WNWN005 | Category Code - Contact 05 | String | UDC (01 N5) | 3 | 0 | Allow NULL? |
| 17 | WNWN006 | Category Code - Contact 06 | String | UDC (01 N6) | 3 | 0 | Allow NULL? |
| 18 | WNWN007 | Category Code - Contact 07 | String | UDC (01 N7) | 3 | 0 | Allow NULL? |
| 19 | WNWN008 | Category Code - Contact 08 | String | UDC (01 N8) | 3 | 0 | Allow NULL? |
| 20 | WNWN009 | Category Code - Contact 09 | String | UDC (01 N9) | 3 | 0 | Allow NULL? |
| 21 | WNWN010 | Category Code - Contact 10 | String | UDC (01 NA) | 3 | 0 | Allow NULL? |
| 22 | WNUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | WNPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | WNUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 25 | WNJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | WNUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |