| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP80D: Plant Manager Dashboard |
| 1 | F80D305 | Hierarchy Definition | 3 | HD | DDALU | Data Dictionary Alias Lookup | String | UDC | 5 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 00 / DA (Data Dictionary Lookup Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | AN8 | Customer/Supplier | | Y |
| 2 | BRND | Brand | | Y |
| 3 | CMD01 | Commodity Level 1 | | Y |
| 4 | CMD02 | Commodity Level 2 | | Y |
| 5 | CMD03 | Commodity Level 3 | | Y |
| 6 | CO | Company | | Y |
| 7 | DATE | Date | | Y |
| 8 | ECBR | Reason Code | | Y |
| 9 | ITM | Item | | Y |
| 10 | LNTY | Line Type | | Y |
| 11 | MCU | Branch Plant | | Y |
| 12 | MCU1 | Business Unit | | Y |
| 13 | PA8 | Parent Supplier | | Y |
| 14 | PRP4 | Product Family | | Y |
| 15 | SRP1 | Brand Category 1 | | Y |
| 16 | SRP2 | Brand Category 2 | | Y |
| 17 | SRP3 | Brand Category 3 | | Y |
| 18 | SRP4 | Brand Category 4 | | Y |
| 19 | SRP5 | Brand Category 5 | | Y |
