| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP01: Address Book |
| 1 | F01301 | Activity Master | 4 | AM | CALTY | Calendar Type | String | UDC | 50 | 0 |
| 2 | F01301D | Activity Detail | 5 | AD | CALTY | Calendar Type | String | UDC | 50 | 0 |
| 3 | F01301W | Mobile Client Deleted Activities | 5 | AW | CALTY | Calendar Type | String | UDC | 50 | 0 |
| 4 | F01311 | Centralized Calendar Master | 3 | CC | CALTY | Calendar Type | String | UDC | 50 | 0 |
| 5 | F01315 | Calendar Associations | 3 | CC | CALTY | Calendar Type | String | UDC | 50 | 0 |
| TOP05: Time Accounting and HRM Base |
| 6 | F07315 | Employee Group Schedules Director | 4 | GS | CALTY | Calendar Type | String | UDC | 50 | 0 |
| TOP90CA: CRM Foundation |
| 7 | F90CA000 | CRM_Constants Table | 11 | CO | CALTY | Calendar Type | String | UDC | 50 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 01 / CY (Calendar Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | BANK | Bank Calendar | | N |
| 2 | CARRIER | Carrier Calendar | | N |
| 3 | CRM | CRM Calendar | | Y |
| 4 | CUSTOMER | Customer Calendar | | N |
| 5 | HOLIDAYS | Holidays | P01302 | Y |
| 6 | PERSONAL | Personal Calendar | | Y |
| 7 | RESOURCE | Resource Calendar | | N |
| 8 | ROUTE | Route Calendar | | N |
| 9 | SUPPLIER | Supplier Calendar | | N |
| 10 | WRKEXC | Employee Work Schedule | P01302 | Y |
| 11 | WRKSCH | Work Schedule | P01302 | Y |
