| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 90CA: CRM Foundation | ||||||||||
| 1 | F90CA020 | Person Table | 7 | TT | STSCOD | Status 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.
UDC 90CA / ST (Status Type) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | Blank | Y | ||
| 2 | ACT | Active | Y | |
| 3 | INA | Inactive | Y |