| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 90CA: CRM Foundation | ||||||||||
| 1 | F90CA12A | Industry Grouping Industry | 2 | IA | INDTRY | Industry Drky | String | UDC | 10 | 0 |
| 2 | F90CA130 | Industry Buying Issues | 1 | BI | INDTRY | Industry Drky | String | UDC | 10 | 0 |
| 90CB: CRM Sales Force Automation | ||||||||||
| 3 | F90CB010 | Lead Table | 9 | LD | INDTRY | Industry Drky | String | UDC | 10 | 0 |
| 4 | F90CB060 | Forecast | 20 | FC | INDTRY | Industry Drky | String | UDC | 10 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 01 / SC (Standard Industry Code) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | 0100 | Agricul. Products/Crops (APC) | N | |
| 2 | 0700 | Agricultural Services (AS) | N | |
| 3 | 0800 | Forestry Products | N | |
| 4 | 1000 | Metal Mining (MM) | N | |
| 5 | 1500 | General Bldg. Contractors(GBC) | N | |
| 6 | 1521 | GBC/Single Family Housing | N | |
| 7 | 2000 | Manufacturing, Food Prod (MFP) | N | |
| 8 | 2032 | MFP/Canned Specialties | N | |
| 9 | 5000 | Wholesale Trade | N | |
| 10 | 5200 | Retail Trade | N | |
| 11 | 6000 | Finance, Insurance, RealEstate | N | |
| 12 | 7000 | Services | N | |
| 13 | 9000 | Government/Public Admin | N |