| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP01: Address Book |
| 1 | F0115 | Address Book - Phone Numbers | 5 | WP | PHTP | Phone Number Type | String | UDC | 4 | 0 |
| 2 | F0115Z1 | Phones - Interoperability | 19 | PI | PHTP | Phone Number Type | String | UDC | 4 | 0 |
| TOP08: Human Resources |
| 3 | F054115 | Employee Phone Number History Table | 6 | HP | PHTP | Phone Number Type | String | UDC | 4 | 0 |
| 4 | F054115W | Employee Phone Number Work Table | 6 | PN | PHTP | Phone Number Type | String | UDC | 4 | 0 |
| TOP08AD: ADP Integration |
| 5 | F05137 | ADP Employee Master Information | 49 | AD | PHTP | Phone Number Type | String | UDC | 4 | 0 |
| TOP90CA: CRM Foundation |
| 6 | F90CA000 | CRM_Constants Table | 10 | CO | PHTP | Phone Number Type | String | UDC | 4 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 01 / PH (Phone Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Business | | N |
| 2 | CAR | Car or Mobile | | N |
| 3 | FAX | FAX | | N |
| 4 | HEMG | Home - Emergency contact | | N |
| 5 | HOM | Home | | N |
| 6 | WEMG | Work - Emergency contact | | N |
