| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F05100 | Resource Competency | 1 | CM | RRTY | Resource Type | String | UDC | 2 | 0 |
| 2 | F05100Z1 | Resource Competencies Unedited Transactions File | 8 | CU | RRTY | Resource Type | String | UDC | 2 | 0 |
| 3 | F05112 | Skills/Resources | 1 | ST | RRTY | Resource Type | String | UDC | 2 | 0 |
| 4 | F05114 | Certifications | 1 | CT | RRTY | Resource Type | String | UDC | 2 | 0 |
| 5 | F05116 | Languages | 1 | LT | RRTY | Resource Type | String | UDC | 2 | 0 |
| 6 | F05120 | Competency History | 1 | MM | RRTY | Resource Type | String | UDC | 2 | 0 |
| TOP13R: Resource Assignments |
| 7 | F48307 | Resource Working Hours | 6 | RH | RRTY | Resource Type | String | UDC | 2 | 0 |
| 8 | F48310 | Resource Master | 1 | RM | RRTY | Resource Type | String | UDC | 2 | 0 |
| 9 | F48311 | Resource Assignments | 20 | RA | RRTY | Resource Type | String | UDC | 2 | 0 |
| 10 | F48311S | Purge - Resource Assignments | 20 | RA | RRTY | Resource Type | String | UDC | 2 | 0 |
| 11 | F48316 | Maintenance Rescheduling Metrics | 10 | RS | RRTY | Resource Type | String | UDC | 2 | 0 |
| TOP87: JDE Internal |
| 12 | F1811 | Task Resource | 8 | TK | RRTY | Resource Type | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 05 / RT (Record Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 01 | Employee | | N |
| 2 | 02 | Asset | | N |
