| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP90CB: CRM Sales Force Automation |
| 1 | F90CB010 | Lead Table | 20 | LD | LEADSRC | Lead Source | Variable String | UDC | 3 | 0 |
| 2 | F90CB020 | Opportunity Table | 29 | OT | LEADSRC | Lead Source | Variable String | UDC | 3 | 0 |
| 3 | F90CB06B | Opportunity_For_Forecast Table | 29 | OF | LEADSRC | Lead Source | Variable String | UDC | 3 | 0 |
| 4 | F90CB06Z | Opportunity for Forecast WTF | 30 | ZF | LEADSRC | Lead Source | Variable String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 90CB / LS (Lead Source) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 001 | Referral | | N |
| 2 | 002 | Advertising | | N |
| 3 | 003 | Event | | N |
| 4 | 004 | Personal Contact | | N |
| 5 | 005 | Web | | N |
| 6 | 006 | Purchased List | | N |
| 7 | 007 | OEM | | N |
| 8 | 008 | Trade Show | | N |
| 9 | 009 | Partner | | N |
| 10 | 010 | Other | | N |
