| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 09: General Accounting | ||||||||||
| 1 | F0901 | Account Master | 40 | GM | CCT | Method of Computation | Character | UDC | 1 | 0 |
| 51: Job Costing | ||||||||||
| 2 | F5109 | Chart Type Master | 12 | GJ | CCT | Method of Computation | Character | UDC | 1 | 0 |
| 3 | F5111 | Forecast Detail | 125 | FD | CCT | Method of Computation | Character | UDC | 1 | 0 |
| 51F: Advanced Job Forecasting | ||||||||||
| 4 | F51F110 | Job Forecast Details | 6 | QG | CCT | Method of Computation | Character | UDC | 1 | 0 |
| 5 | F51F125 | Job Forecast Detail History | 7 | QI | CCT | Method of Computation | Character | UDC | 1 | 0 |
| 6 | F51F20W | Job Forecast Account Info Worktable | 6 | PA | CCT | Method of Computation | Character | UDC | 1 | 0 |
| 7 | F51F94 | User Defined MOC Definition | 1 | QU | CCT | Method of Computation | Character | UDC | 1 | 0 |
| 8 | F51F95 | User Defined MOC Rules | 1 | QT | CCT | Method of Computation | 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 51 / MC (Method Of Computation) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | A | Account Force | Y | |
| 2 | B | Buyout | Y | |
| 3 | C | Cost Code Percent Complete | Y | |
| 4 | D | Default | Y | |
| 5 | E | Estimate to Complete | Y | |
| 6 | F | Forced | Y | |
| 7 | G | Forced - Budget Default | Y | |
| 8 | H | Labor Quantity (Use w/ Mthd L) | Y | |
| 9 | I | Inclusion (Used with Method S) | Y | |
| 10 | L | Labor (Used with Method H) | Y | |
| 11 | N | No Projection | Y | |
| 12 | O | Override | Y | |
| 13 | P | Percent Complete | Y | |
| 14 | Q | Quantities | Y | |
| 15 | R | Revenue Unit Price | Y | |
| 16 | S | Summary (Used with Method I) | Y | |
| 17 | T | Totaling (Level of Detail) | Y | |
| 18 | U | Remaining Unit Rate | Y | |
| 19 | V | Revenue - Absolute Value | Y | |
| 20 | W | Forecast EAC | Y | |
| 21 | X | Budget Default - Forced | Y | |
| 22 | Y | Forecast Estimate To Complete | Y | |
| 23 | Z | Forecast Remaining Work | Y |