| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP48S: Service Billing |
| 1 | F48091 | Billing System Constants | 38 | WZ | DJOTY | Default Job Type | String | UDC | 6 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 06 / G (Job Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | #ALLOC | Allocated Tips record | | N |
| 3 | #SUMM | Summarized Tips record | | N |
| 4 | 0A-0 | Controller | | N |
| 5 | 0A-1 | Accounting Manager | | N |
| 6 | 0A-10 | Purchasing Agent | | N |
| 7 | 0A-2 | Senior Accountant | | N |
| 8 | 0A-3 | Financial Analyst | | N |
| 9 | 0A-4 | Accountant | | N |
| 10 | 0P-0 | Finance Director | | N |
| 11 | 0P-1 | Asst Finance Director | | N |
| 12 | 0P-2 | Accounts Payable Clerk | | N |
| 13 | 0P-3 | Accounts Receivable Clerk | | N |
| 14 | 1M-1 | MIS Manager | | N |
| 15 | 1M-2 | IT Manager | | N |
| 16 | 1M-3 | System Analyst | | N |
| 17 | 1M-4 | Programmer Analyst | | N |
| 18 | 1M-5 | Programmer | | N |
| 19 | 2H-1 | Human Resources Manager | | N |
| 20 | 2H-2 | Employment Representative | | N |
| 21 | 2H-3 | Compensation Specialist | | N |
| 22 | 2H-4 | Benefits Specialist | | N |
| 23 | 2H-5 | EEO Specialist | | N |
| 24 | 2H-6 | Instructor | | N |
| 25 | 3P-1 | Payroll Manager | | N |
| 26 | 3P-2 | Payroll Administrator | | N |
| 27 | 4A-1 | Administrative Assistant | | N |
| 28 | 4A-2 | Secretary | | N |
| 29 | 4A-3 | Clerk | | N |
| 30 | 50PE | Project Engineer | | N |
| 31 | 50PM | Project Manager | | N |
| 32 | 50SU | Superintendent | | N |
| 33 | 5J-1 | City Manager | | N |
| 34 | 5J-2 | County Supervisor | | N |
| 35 | 5J-3 | Purchasing Manager | | N |
| 36 | 5J-4 | Fire Fighter | | N |
| 37 | 5J-5 | Electrician | | N |
| 38 | 5J-6 | Junior Engineer | | N |
| 39 | 5J-7 | Nurse | | N |
| 40 | 5J-8 | Teacher | | N |
| 41 | 5J-9 | Journeyman | | N |
| 42 | 61 | Foreman | | N |
| 43 | 62 | Foreman | | N |
| 44 | 63 | Equipment Operator | | N |
| 45 | 64 | Engineer | | N |
| 46 | 64-1 | Designer | | N |
| 47 | 64-5 | Spec Typist | | N |
| 48 | 65 | Draftsperson | | N |
| 49 | 66 | Electrician | | N |
| 50 | 67 | Electrician | | N |
| 51 | 68 | Technician | | N |
| 52 | 69 | Driver | | N |
| 53 | 6G-1 | City Manager | | N |
| 54 | 6G-2 | Purchasing Manager | | N |
| 55 | 6G-3 | County Supervisor | | N |
| 56 | 6G-4 | Fire Fighter | | N |
| 57 | 6G-5 | Nurse | | N |
| 58 | 6S-1 | Security Supervisor | | N |
| 59 | 6S-3 | Security Screener | | N |
| 60 | 6S-5 | Security Guard | | N |
| 61 | 7H-0 | Hotel Manager | | N |
| 62 | 7H-1 | Waiter/Waitress | | N |
| 63 | 7H-2 | Hostess | | N |
| 64 | 7H-3 | Housekeeper | | N |
| 65 | 7H-4 | Service Worker (Bell Stand) | | N |
| 66 | 7H-5 | Bartender | | N |
| 67 | 7H-6 | Bus person | | N |
| 68 | 7H-7 | Chef | | N |
| 69 | 8M-1 | Maintenance Engineer | | N |
| 70 | 8M-2 | Distribution Manager | | N |
| 71 | 8M-3 | Clerk | | N |
| 72 | 8P-1 | Plant Manager | | N |
| 73 | 8P-2 | Foreman | | N |
| 74 | 8P-3 | Lathe Operator | | N |
| 75 | 8P-4 | Setup Person | | N |
| 76 | 8P-5 | Production Worker | | N |
| 77 | 8P-6 | QA Inspector | | N |
| 78 | 8P-7 | Press Operator | | N |
| 79 | 8R-1 | Maintenance Mechanic Junior | | N |
| 80 | 8R-2 | Maintenance Electrician App 2 | | N |
| 81 | 8R-3 | Maintenance Instruc. Junior | | N |
| 82 | 999 | Other | | N |
| 83 | 9S-1 | Sales Management | | N |
| 84 | 9S-2 | Sales Representative | | N |
| 85 | A0 | Chief Executive Officer | | N |
| 86 | A1 | President | | N |
| 87 | A2 | Vice President | | N |
| 88 | ADMASS | Administrative Assistant | | N |
| 89 | BOARD | Board of Directors | | N |
| 90 | CC200 | Corporate Controller | | N |
| 91 | CLERK | Clerk | | N |
| 92 | M1 | Manager | | N |
| 93 | M200 | Manager | | N |
| 94 | MX801 | Administrador | | N |
| 95 | MX802 | Jefe de Operaciones | | N |
| 96 | MX803 | Asistente Administrativa | | N |
| 97 | MX804 | Supervisor | | N |
| 98 | MX810 | Tecnico Especialista | | N |
| 99 | MX811 | Electricista | | N |
| 100 | MX812 | Mecanico | | N |
| 101 | MX813 | Trabajos Generales | | N |
| 102 | MX820 | Operario - Eventuales | | N |
| 103 | PB-1 | Planner/Buyer | | N |
| 104 | PRES | President | | N |
| 105 | PROG | Associate Programmer | | N |
| 106 | PROGRA | Programmer | | N |
| 107 | SALREP | Sales Representative | | N |
| 108 | SECRE | Secretary | | N |
| 109 | TRN1 | Trainer | | N |
| 110 | TRNER | Trainer | | N |
| 111 | TYPIST | Typist | | N |
| 112 | VICPRE | Vice President | | N |
