| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP80D: Plant Manager Dashboard |
| 1 | F80D302 | Metric ID Time Dimension Cross Reference | 2 | CR | TIDEN | Time Dimension | Numeric | UDC | 1 | 0 |
| 2 | F80D304 | Variant Definition | 7 | VD | TIDEN | Time Dimension | Numeric | UDC | 1 | 0 |
| 3 | F80D305 | Hierarchy Definition | 4 | HD | TIDEN | Time Dimension | Numeric | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 00 / DD (Date Dimension) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 0 | Blank | | Y |
| 2 | 1 | Year | | Y |
| 3 | 2 | Quarter | | Y |
| 4 | 3 | Month | | Y |
| 5 | 4 | Week | | Y |
| 6 | 5 | Day | | Y |
