| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| H91: Design Tools | ||||||||||
| 1 | F984052 | Table Conversion - History Log | 12 | SH | CNVTYP | Conversion Type | String | UDC | 5 | 0 |
| H96U: Upgrade | ||||||||||
| 2 | F98405 | Table Conversion Scheduler | 7 | ST | CNVTYP | Conversion Type | String | UDC | 5 | 0 |
| 3 | F9843 | Table Conversion - JDE Scheduler | 4 | JS | CNVTYP | Conversion Type | String | UDC | 5 | 0 |
| 4 | F9843T | TC Schedule - Tag File | 4 | JS | CNVTYP | Conversion Type | 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 H90 / TC (Type of Conversion) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | 1 | Control Table Merge | N | |
| 2 | 10 | Exclude Table Actions | N | |
| 3 | 100 | Remote Location Repl Load | N | |
| 4 | 101 | Remote Location Package Push | N | |
| 5 | 11 | Exclude Index Actions | N | |
| 6 | 2 | Application Control Table | N | |
| 7 | 20 | Initial Tasks Workbench | N | |
| 8 | 3 | Application Table | N | |
| 9 | 31 | Alter Table TC API | N | |
| 10 | 32 | Merge Table TC API | N | |
| 11 | 33 | Original Alter Table API | N | |
| 12 | 4 | Indexes Only | N | |
| 13 | 5 | Manual Conversion | N | |
| 14 | 6 | Specification Table Merge | N | |
| 15 | 7 | Table Generation | N | |
| 16 | 8 | Euro Conversion | N | |
| 17 | 9 | New Table Generation | N | |
| 18 | 90 | Data Load Parameters | N | |
| 19 | 91 | Index Creation Parameters | N | |
| 20 | 95 | Environment / Path Code Copy | N |