| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 90CA: CRM Foundation | ||||||||||
| 1 | F90CA020 | Person Table | 2 | TT | CNLNID | Contact Line ID | Numeric | Generic Edit | 5 | 0 |
| 2 | F90CA070 | Contact Table | 2 | CT | CNLNID | Contact Line ID | Numeric | Generic Edit | 5 | 0 |
| 3 | F90CA07A | Contact_Event Table | 3 | CA | CNLNID | Contact Line ID | Numeric | Generic Edit | 5 | 0 |
| 4 | F90CA07B | Contact_Profile Table | 4 | CB | CNLNID | Contact Line ID | Numeric | Generic Edit | 5 | 0 |
| 5 | F90CA62E | Activity Contact Associative Table (FOR CRM UPGRADE) | 2 | AC | CNLNID | Contact Line ID | Numeric | Generic Edit | 5 | 0 |