| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP51F: Advanced Job Forecasting |
| 1 | F51F90 | Formula Definition | 26 | QN | 51FCT12 | Formula Component Type 12 | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 51F / CT (Formula Component Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | Y |
| 2 | 1 | Ledger Type | | Y |
| 3 | 2 | Revised Budget Amount Ledgers | | Y |
| 4 | 3 | Revised Budget Units Ledgers | | Y |
| 5 | 4 | Billing Amount | | Y |
| 6 | 5 | Formula | | Y |
| 7 | 6 | Job Value | | Y |
| 8 | 7 | Numeric Value | | Y |
