| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP90CB: CRM Sales Force Automation |
| 1 | F90CB020 | Opportunity Table | 3 | OT | OPTYCD | Opportunity Type Code | Variable String | UDC | 5 | 0 |
| 2 | F90CB060 | Forecast | 23 | FC | OPTYCD | Opportunity Type Code | Variable String | UDC | 5 | 0 |
| 3 | F90CB06B | Opportunity_For_Forecast Table | 4 | OF | OPTYCD | Opportunity Type Code | Variable String | UDC | 5 | 0 |
| 4 | F90CB06Z | Opportunity for Forecast WTF | 5 | ZF | OPTYCD | Opportunity Type 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 90CB / TC (Type Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | DIR | Direct | | N |
| 2 | OEM | OEM | | N |
| 3 | PART | Partner | | N |
| 4 | REFE | Referral Commission | | N |
