| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F00090 | Supplemental Database Setup | 1 | T1 | SDB | Supplemental Database Code | String | UDC | 4 | 0 |
| 2 | F00090D | Supplemental Database Language Preferences | 1 | T5 | SDB | Supplemental Database Code | String | UDC | 4 | 0 |
| 3 | F00091 | Supplemental Database Data Types | 1 | T2 | SDB | Supplemental Database Code | String | UDC | 4 | 0 |
| 4 | F00092 | Supplemental Data | 1 | T3 | SDB | Supplemental Database Code | String | UDC | 4 | 0 |
| TOP40R: Demand Scheduling |
| 5 | F40R31 | Additional Demand Label Data | 6 | AD | SDB | Supplemental Database Code | String | UDC | 4 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 00 / SD (Supplemental Database Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | A | Applicant | | |
| 2 | AM | Asset Management | | |
| 3 | AP | Acquired Products | | Y |
| 4 | BU | Business Units | | |
| 5 | DD | Demand Detail | | Y |
| 6 | DH | Demand Header | | Y |
| 7 | DL | Daily Logs | | |
| 8 | E | Employee | | |
| 9 | ECO | Engineering Change Orders | | |
| 10 | GR | Ground Conditions | | N |
| 11 | H | Injury/Illness Case Info. | | Y |
| 12 | I | Inventory by Item | | N |
| 13 | IB | Inventory by Item/Branch | | |
| 14 | IN | Incident Log | | N |
| 15 | J | Job | | |
| 16 | JC | Job Cost | | |
| 17 | LG | Legal Description | | N |
| 18 | P | Dependent/Beneficiary | | |
| 19 | PR | Precipitation | | N |
| 20 | R | Requisition | | |
| 21 | RM | General Remarks | | N |
| 22 | SO | Sales Order | | N |
| 23 | WI | Wind Conditions | | N |
| 24 | WO | Work Order | | |
