| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP42: Sales Management |
| 1 | F42140 | Customer Master Commission Information | 10 | CM | RTYPE | Role | Variable String | UDC | 5 | 0 |
| TOP90CA: CRM Foundation |
| 2 | F90CA05A | Partner_Employee Table | 3 | PA | RTYPE | Role | Variable String | UDC | 5 | 0 |
| 3 | F90CA08A | Customer_Employee Table | 7 | UA | RTYPE | Role | Variable String | UDC | 5 | 0 |
| TOP90CB: CRM Sales Force Automation |
| 4 | F90CB02E | Opportunity_Employee Table | 6 | OE | RTYPE | Role | 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 H42 / RT (Role Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | ACMGR | Account Manager | | N |
| 2 | CONS | Consultant | | N |
| 3 | CSR | Customer Service Rep | | N |
| 4 | INVAD | Investment Advisor | | N |
| 5 | SLS | Sales Representative | | N |
| 6 | SUP | Support | | N |
