| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP90CA: CRM Foundation |
| 1 | F90CA040 | Employee Table | 3 | EE | DPTCD | Department Code | Variable String | UDC | 5 | 0 |
| 2 | F90CA070 | Contact Table | 3 | CT | DPTCD | Department Code | Variable String | UDC | 5 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 90CA / DC (Department Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | CUST | Customer Service & Support | | N |
| 2 | EXEC | Executive | | N |
| 3 | FIN | Finance | | N |
| 4 | MFG | Manufacturing | | N |
| 5 | MIS | Information Systems | | N |
| 6 | MKTG | Marketing | | N |
| 7 | OPPR | Operations | | N |
| 8 | PUR | Purchasing | | N |
| 9 | SALE | Sales | | N |
| 10 | TRNG | Training | | N |
