| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | CBEDUS | EDI - User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | CBEDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | CBEDTN | EDI - Transaction Number | String | Generic Edit | 22 | 0 | Allow NULL? |
| 4 | CBEDLN | EDI - Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 5 | CBEDCT | EDI - Document Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | CBTYTN | Type - Transaction | String | UDC (00 TT) | 8 | 0 | Allow NULL? |
| 7 | CBEDFT | EDI - Translation Format | String | Generic Edit | 10 | 0 | Allow NULL? |
| 8 | CBEDDT | EDI - Transmission Date | Date | Generic Edit | 6 | 0 | |
| 9 | CBDRIN | Direction Indicator | Character | UDC (00 DN) | 1 | 0 | Allow NULL? |
| 10 | CBEDDL | EDI - Detail Lines Processed | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | CBEDSP | EDI - Successfully Processed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | CBPNID | Trading Partner ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | CBTNAC | Transaction Action | String | UDC (00 TA) | 2 | 0 | Allow NULL? |
| 14 | CBAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | CBIDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 16 | CBDSS5 | Display Sequence- 5.2 | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 17 | CBMLNM | Name - Mailing | String | Generic Edit | 40 | 0 | Allow NULL? |
| 18 | CBMLN1 | Secondary Mailing Name | String | Generic Edit | 40 | 0 | Allow NULL? |
| 19 | CBATTL | Professional Title | String | Generic Edit | 40 | 0 | Allow NULL? |
| 20 | CBREM1 | Remark 1 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 21 | CBSLNM | Salutation Name | String | Generic Edit | 40 | 0 | Allow NULL? |
| 22 | CBALPH | Name - Alpha | String | Generic Edit | 40 | 0 | Allow NULL? |
| 23 | CBALP1 | Secondary Alpha Name | String | Generic Edit | 40 | 0 | Allow NULL? |
| 24 | CBDC | Description - Compressed | String | Generic Edit | 40 | 0 | Allow NULL? |
| 25 | CBGNNM | Name - Given | String | Generic Edit | 25 | 0 | Allow NULL? |
| 26 | CBMDNM | Name - Middle | String | Generic Edit | 25 | 0 | Allow NULL? |
| 27 | CBSRNM | Name - Surname | String | Generic Edit | 25 | 0 | Allow NULL? |
| 28 | CBTYC | Type Code | Character | UDC (01 W0) | 1 | 0 | Allow NULL? |
| 29 | CBNICK | Nickname | String | Generic Edit | 40 | 0 | Allow NULL? |
| 30 | CBGEND | Gender (Male/Female) | Character | UDC (01 GD) | 1 | 0 | Allow NULL? |
| 31 | CBAT1 | Search Type | String | UDC (01 ST) | 3 | 0 | Allow NULL? |
| 32 | CBCCAI | Active/Inactive Flag | Character | UDC (11 AI) | 1 | 0 | Allow NULL? |
| 33 | CBEFTW | Effective Date for Address | Date | Generic Edit | 6 | 0 | |
| 34 | CBNTYP | Contact Type | String | UDC (01 CT) | 3 | 0 | Allow NULL? |
| 35 | CBDDATE | Day of Birth | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 36 | CBDMON | Month of Birth | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 37 | CBDYR | Year of Birth | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 38 | CBW001 | Category Code - Who's Who 001 | String | UDC (01 W1) | 3 | 0 | Allow NULL? |
| 39 | CBW002 | Category Code - Who's Who 002 | String | UDC (01 W2) | 3 | 0 | Allow NULL? |
| 40 | CBW003 | Category Code - Who's Who 003 | String | UDC (01 W3) | 3 | 0 | Allow NULL? |
| 41 | CBW004 | Category Code - Who's Who 004 | String | UDC (01 W4) | 3 | 0 | Allow NULL? |
| 42 | CBW005 | Category Code - Who's Who 005 | String | UDC (01 W5) | 3 | 0 | Allow NULL? |
| 43 | CBW006 | Category Code - Who's Who 006 | String | UDC (01 W6) | 3 | 0 | Allow NULL? |
| 44 | CBW007 | Category Code - Who's Who 007 | String | UDC (01 W7) | 3 | 0 | Allow NULL? |
| 45 | CBW008 | Category Code - Who's Who 008 | String | UDC (01 W8) | 3 | 0 | Allow NULL? |
| 46 | CBW009 | Category Code - Whos Who 009 | String | UDC (01 W9) | 3 | 0 | Allow NULL? |
| 47 | CBW010 | Category Code - Who's Who 010 | String | UDC (01 WT) | 3 | 0 | Allow NULL? |
| 48 | CBWN001 | Category Code - Contact 01 | String | UDC (01 N1) | 3 | 0 | Allow NULL? |
| 49 | CBWN002 | Category Code - Contact 02 | String | UDC (01 N2) | 3 | 0 | Allow NULL? |
| 50 | CBWN003 | Category Code - Contact 03 | String | UDC (01 N3) | 3 | 0 | Allow NULL? |
| 51 | CBWN004 | Category Code - Contact 04 | String | UDC (01 N4) | 3 | 0 | Allow NULL? |
| 52 | CBWN005 | Category Code - Contact 05 | String | UDC (01 N5) | 3 | 0 | Allow NULL? |
| 53 | CBWN006 | Category Code - Contact 06 | String | UDC (01 N6) | 3 | 0 | Allow NULL? |
| 54 | CBWN007 | Category Code - Contact 07 | String | UDC (01 N7) | 3 | 0 | Allow NULL? |
| 55 | CBWN008 | Category Code - Contact 08 | String | UDC (01 N8) | 3 | 0 | Allow NULL? |
| 56 | CBWN009 | Category Code - Contact 09 | String | UDC (01 N9) | 3 | 0 | Allow NULL? |
| 57 | CBWN010 | Category Code - Contact 10 | String | UDC (01 NA) | 3 | 0 | Allow NULL? |
| 58 | CBTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 59 | CBTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 60 | CBUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 61 | CBPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 62 | CBUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 63 | CBJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 64 | CBUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |