| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 00: Foundation Environment | ||||||||||
| 1 | F0013 | Currency Codes | 3 | CV | EC | Edit Code | Character | UDC | 1 | 0 |
| 2 | F5192 | Inquiry Columns | 8 | JC | EC | Edit Code | Character | UDC | 1 | 0 |
| 12: Fixed Assets | ||||||||||
| 3 | F12853 | Depreciation Formulas | 8 | LW | EC | Edit Code | Character | UDC | 1 | 0 |
| 4 | F12853D | Demo Depreciation Formulas | 8 | LW | EC | Edit Code | Character | UDC | 1 | 0 |
| 51X: In-Memory Project Management | ||||||||||
| 5 | F51X90 | Column Definition Table | 45 | X1 | EC | Edit Code | Character | UDC | 1 | 0 |
| H95: Object and Environment Tech | ||||||||||
| 6 | F82103 | World Writer Query Output Print Fields | 14 | A2 | EC | Edit Code | Character | UDC | 1 | 0 |
| 7 | F8304 | FASTR - Column Specifications Master File | 51 | R4 | EC | Edit Code | Character | UDC | 1 | 0 |
| 8 | F98301 | DREAM Writer Master Parameter | 27 | DE | EC | Edit Code | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 98 / EC (Edit Codes) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | Default Value | |||
| 2 | % | Trailing `%` - Zero Bal - `-` | ||
| 3 | * | Leading asterisks-commas- `-` | ||
| 4 | 1 | Commas - Zero Bal - No Sign | ||
| 5 | 2 | Commas - No Zero Bal - No Sign | ||
| 6 | 3 | No Commas - Zero Bal - No Sign | ||
| 7 | 4 | No Commas-No Zero Bal-No Sign | ||
| 8 | A | Commas - Zero Bal - `Cr` | ||
| 9 | B | Commas - No Zero Bal -`Cr` | ||
| 10 | C | No Commas - Zero Bal - `Cr` | ||
| 11 | D | No Comma - No Zero Bal - `Cr` | ||
| 12 | J | Commas - Zero Bal - `-` | ||
| 13 | K | Commas - No Zero Bal - `-` | ||
| 14 | L | No Commas - Zero Bal - `-` | ||
| 15 | M | No Commas - No Zero Bal - `-` | ||
| 16 | N | Commas - Zero Bal - float - | ||
| 17 | O | Commas - No Zero Bal - float - | ||
| 18 | P | No Commas - Zero Bal - float - | ||
| 19 | Q | No Commas - No 0 Bal - float - | ||
| 20 | R | Commas - Zero Bal - `<>` | ||
| 21 | S | Commas - No Zero Bal - `<>` | ||
| 22 | T | No Commas - Zero Bal - `<>` | ||
| 23 | U | No Commas - No Zero Bal - `<>` | ||
| 24 | W | Date (Store as Julian) | N | |
| 25 | X | Remove Plus Sign | ||
| 26 | Y | Date Field Edit | ||
| 27 | Z | Zero Suppress |