| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 09: General Accounting | ||||||||||
| 1 | F0901 | Account Master | 11 | GM | BILL | Billable (Y/N) | Character | UDC | 1 | 0 |
| 17: Customer Service Management | ||||||||||
| 2 | F3111Z2 | Warranty Claim/Supplier Recovery processing | 116 | WP | BILL | Billable (Y/N) | Character | UDC | 1 | 0 |
| 3 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 121 | WL | BILL | Billable (Y/N) | Character | UDC | 1 | 0 |
| 4 | F31171 | Parts List - Extension | 17 | WS | BILL | Billable (Y/N) | Character | UDC | 1 | 0 |
| 5 | F31171S | Purge Parts List - Extension | 17 | WS | BILL | Billable (Y/N) | Character | UDC | 1 | 0 |
| 6 | F31172 | Routing Instructions - Extension | 6 | WS | BILL | Billable (Y/N) | Character | UDC | 1 | 0 |
| 7 | F31172S | Purge Routing Instructions - Extension | 6 | WS | BILL | Billable (Y/N) | Character | UDC | 1 | 0 |
| 17C: Call Management | ||||||||||
| 8 | F1755 | Case Master | 92 | ZA | BILL | Billable (Y/N) | Character | UDC | 1 | 0 |
| 9 | F1760 | Time Entry | 23 | ZB | BILL | Billable (Y/N) | Character | UDC | 1 | 0 |
| 51: Job Costing | ||||||||||
| 10 | F5109 | Chart Type Master | 19 | GJ | BILL | Billable (Y/N) | 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 H00 / BI (BILL) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | No, it should not be billed. | N | ||
| 2 | 1 | Eligible only for invoicing. | N | |
| 3 | 2 | Elig. only for rev. recognitio | N | |
| 4 | 4 | Eligible only for cost. | N | |
| 5 | N | No, it should not be billed. | N | |
| 6 | Y | Yes, account should be billed. | N |