| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 00: 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 |
| 40R: 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.
UDC 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 | CO | Contract | Y | |
| 6 | DD | Demand Detail | Y | |
| 7 | DH | Demand Header | Y | |
| 8 | DL | Daily Logs | ||
| 9 | E | Employee | ||
| 10 | ECO | Engineering Change Orders | ||
| 11 | GR | Ground Conditions | N | |
| 12 | H | Injury/Illness Case Info. | Y | |
| 13 | I | Inventory by Item | N | |
| 14 | IB | Inventory by Item/Branch | ||
| 15 | IN | Incident Log | N | |
| 16 | J | Job | ||
| 17 | JC | Job Cost | ||
| 18 | LG | Legal Description | N | |
| 19 | P | Dependent/Beneficiary | ||
| 20 | PR | Precipitation | N | |
| 21 | R | Requisition | ||
| 22 | RM | General Remarks | N | |
| 23 | SO | Sales Order | N | |
| 24 | WI | Wind Conditions | N | |
| 25 | WO | Work Order |