| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 48S: Service Billing | ||||||||||
| 1 | F4812 | Billing Detail Workfile | 79 | WD | HLD | Hold Code - Service Billing Transaction | Character | UDC | 1 | 0 |
| 2 | F4812H | Billing Workfile - History | 79 | WD | HLD | Hold Code - Service Billing Transaction | Character | UDC | 1 | 0 |
| 3 | F4812HS | Billing Workfile History Purged Save | 79 | WD | HLD | Hold Code - Service Billing Transaction | Character | UDC | 1 | 0 |
| 4 | F48SUI01 | Billing Detail Print Workfile | 79 | WD | HLD | Hold Code - Service Billing Transaction | Character | UDC | 1 | 0 |
| 52: Contract Billing | ||||||||||
| 5 | F5280W | Contract Revenue Summary Work File | 41 | GY | HLD | Hold Code - Service Billing Transaction | 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 / HL (Hold Code) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | Not on hold | Y | ||
| 2 | * | Do not process for NTE | Y | |
| 3 | 1 | Hold for invoice, revenue, cos | Y | |
| 4 | 2 | Hold for invoice, revenue | Y | |
| 5 | 3 | Hold for invoice | Y | |
| 6 | 4 | Hold for revenue | Y | |
| 7 | A | Hold for invoice, revenue, cos | Y | |
| 8 | B | Hold for invoice, revenue | Y | |
| 9 | E | Errors, hold for processing | Y | |
| 10 | I | Hold for invoice | Y | |
| 11 | R | Hold for revenue | Y |