| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP07: Payroll |
| 1 | F0716701 | Employee Assignment T/E Template Information | 47 | EA | TYR | Type of Hours | Character | UDC | 1 | 0 |
| 2 | F0716709 | Employee Assignment T/E Template Info History | 47 | EA | TYR | Type of Hours | Character | UDC | 1 | 0 |
| TOP31: Shop Floor Control |
| 3 | F31122 | Work Order Time Transactions | 13 | WT | TYR | Type of Hours | Character | UDC | 1 | 0 |
| 4 | F31122S | Purge Work Order Time Transactions | 13 | WT | TYR | Type of Hours | Character | UDC | 1 | 0 |
| 5 | F31122Z1 | Work Order Time Transactions Unedited Transaction Table | 26 | SZ | TYR | Type of Hours | Character | UDC | 1 | 0 |
| TOPF31: Lean Transactions |
| 6 | FF31113 | Lean Transaction Labor Detail | 16 | LD | TYR | Type of Hours | Character | UDC | 1 | 0 |
| 7 | FF31113S | Purge - Lean Transaction Labor Detail | 16 | LR | TYR | Type of Hours | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 31 / TY (Type of Hours) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 1 | Run Labor Hours | | N |
| 2 | 2 | Setup Labor Hours | | N |
| 3 | 3 | Machine Hours | | N |
| 4 | 4 | Quantities Completed | | N |
| 5 | 5 | Quantities Scrapped | | N |
| 6 | 9 | Miscellaneous | | N |
