| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP76B: Brazil - Reporting System Only |
| 1 | F76B473 | Dynamic Formater Layouts Specification - 03B | 10 | DS | OWTP | Data Type - EnterpriseOne | String | UDC | 2 | 0 |
| TOP81: DREAM Writer |
| 2 | F81A122 | Dream Writer Processing Option Interim File F59012 - F81A122 | 13 | M4 | OWTP | Data Type - EnterpriseOne | String | UDC | 2 | 0 |
| TOP81A: DREAMWriter Conversion Tool |
| 3 | F81A01 | DW Master Parameters Conversion Table | 15 | M1 | OWTP | Data Type - EnterpriseOne | String | UDC | 2 | 0 |
| 4 | F81A11E | Migration Aid PO Value Validation Error log | 9 | ME | OWTP | Data Type - EnterpriseOne | String | UDC | 2 | 0 |
| TOP98: Technical Tools |
| 5 | F05WMM02 | Web Mail Merge Data Structure Detail | 5 | DD | OWTP | Data Type - EnterpriseOne | String | UDC | 2 | 0 |
| TOPH90: ONEWORLD TOOLS |
| 6 | F98861 | Workflow process instance data values | 5 | DV | OWTP | Data Type - EnterpriseOne | String | UDC | 2 | 0 |
| TOPH95: Tech Resources/Applications |
| 7 | F9210 | Data Field Specifications (OneWorld) | 27 | FR | OWTP | Data Type - EnterpriseOne | String | UDC | 2 | 0 |
| TOPH96U: Upgrade |
| 8 | F9760 | Change Table - OneWorld Data Field Specification | 22 | D$ | OWTP | Data Type - EnterpriseOne | 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 H98 / DT (Data Type (OneWorld)) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 1 | Character | | N |
| 2 | 11 | Date | | N |
| 3 | 15 | Integer | | N |
| 4 | 17 | Character (Blob) | | N |
| 5 | 18 | Binary (Blob) | | N |
| 6 | 2 | String | | N |
| 7 | 20 | Variable String | | N |
| 8 | 55 | JDE UTime | | N |
| 9 | 7 | Identifier (ID) | | N |
| 10 | 9 | Numeric | | N |
