| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP48S: Service Billing |
| 1 | F4812 | Billing Detail Workfile | 172 | WD | TKM2 | Key Type - Markup Table Type 2 | Character | UDC | 1 | 0 |
| 2 | F4812H | Billing Workfile History | 172 | WD | TKM2 | Key Type - Markup Table Type 2 | Character | UDC | 1 | 0 |
| 3 | F4812HS | Billing Workfile History Purged Save | 172 | WD | TKM2 | Key Type - Markup Table Type 2 | Character | UDC | 1 | 0 |
| 4 | F48SUI01 | Billing Detail Print Workfile | 172 | WD | TKM2 | Key Type - Markup Table Type 2 | 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 48 / TY (Key Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 1 | Work order | | Y |
| 2 | 2 | Work order class | | Y |
| 3 | 3 | Contract number | | Y |
| 4 | 4 | Parent contract number | | Y |
| 5 | 5 | Customer | | Y |
| 6 | 6 | Job or Business Unit | | Y |
| 7 | 7 | Job class | | Y |
| 8 | 8 | Company | | N |
| 9 | 9 | Default | | Y |
