| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 48S: Service Billing | ||||||||||
| 1 | F4812 | Billing Detail Workfile | 74 | WD | TCLS | Transaction Classification | Character | UDC | 1 | 0 |
| 2 | F4812H | Billing Workfile History | 74 | WD | TCLS | Transaction Classification | Character | UDC | 1 | 0 |
| 3 | F4812HS | Billing Workfile History Purged Save | 74 | WD | TCLS | Transaction Classification | Character | UDC | 1 | 0 |
| 4 | F48S910 | Billing Detail Journal Workfile | 76 | W2 | TCLS | Transaction Classification | Character | UDC | 1 | 0 |
| 5 | F48SUI01 | Billing Detail Print Workfile | 74 | WD | TCLS | Transaction Classification | 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 48 / TC (Transaction Classification) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | Adhoc entry | Y | ||
| 2 | 0 | Components | Y | |
| 3 | 1 | Labor entry | Y | |
| 4 | 2 | Burden entry | Y | |
| 5 | 3 | Equipment entry | Y | |
| 6 | 4 | Inventory entry | Y | |
| 7 | 5 | Inventory entry | Y | |
| 8 | 6 | Journal entry | Y | |
| 9 | 7 | Manual entry | Y | |
| 10 | 8 | System generated control rec | Y | |
| 11 | 9 | Future | Y | |
| 12 | A | Contract Revenue non-T&M rec | Y | |
| 13 | B | NTE Place Holder | Y | |
| 14 | C | Contracts | Y | |
| 15 | D | Service orders | Y | |
| 16 | E | Claims | Y | |
| 17 | F | Calls | Y | |
| 18 | G | Retro Reversal Record | Y | |
| 19 | H | Retro Adjustment Record | Y | |
| 20 | I | Cost Limit Exceeded | Y | |
| 21 | J | Fee Limit Exceeded | Y | |
| 22 | K | Award Fee Limit Exceeded | Y | |
| 23 | L | Total Limit Exceeded | Y | |
| 24 | R | Retainage | Y |