Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00100
Product: FieldService (949)
Series:
Display Name: Technician Master Group Display Name: Service Table Group
Physical Name: SVC00100
Technical Name: SVC_Tech_MSTR
Group Technical Name: Service
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | TECHID | Tech ID | String | STR10_LBAU | 10 | |
2 | NAME | Name | String | STR30 | 30 | |
3 | ADDRESS1 | Address 1 | String | STR60 | 60 | |
4 | ADDRESS2 | Address 2 | String | STR60 | 60 | |
5 | CITY | City | String | STR35 | 35 | |
6 | STATE | State | String | STR30_State | 29 | |
7 | ZIPCODE | Zip Code | String | STR10 | 10 | |
8 | MANAGER | Manager | String | STR10 | 10 | |
9 | OFFID | Office ID | String | STR10_LBAU | 10 | |
10 | PHONE1 | Phone 1 | String | Phone_Number | 14 | |
11 | PHONE2 | Phone 2 | String | Phone_Number | 14 | |
12 | PAGER1 | Pager1 | String | STR98 | 98 | |
13 | PIN1 | Pin1 | String | STR10 | 10 | |
14 | PAGER2 | Pager2 | String | STR98 | 98 | |
15 | PIN2 | Pin2 | String | STR10 | 10 | |
16 | TECHEMAIL | Tech email | String | STR98 | 98 | |
17 | TECHEMAIL2 | Tech email2 | String | STR98 | 98 | |
18 | WORKDYS_1 | Work Days[1] | Boolean | CB | 0 | |
19 | WORKDYS | Work Days | CB | Boolean | 0 | |
20 | WORKDYS_2 | Work Days[2] | Boolean | CB | 0 | |
21 | WORKDYS_3 | Work Days[3] | Boolean | CB | 0 | |
22 | WORKDYS_4 | Work Days[4] | Boolean | CB | 0 | |
23 | WORKDYS_5 | Work Days[5] | Boolean | CB | 0 | |
24 | WORKDYS_6 | Work Days[6] | Boolean | CB | 0 | |
25 | WORKDYS_7 | Work Days[7] | Boolean | CB | 0 | |
26 | WORKSTRT_1 | Work Start[1] | Time | TM6 | 6 | |
27 | WORKSTRT_2 | Work Start[2] | Time | TM6 | 6 | |
28 | WORKSTRT | Work Start | TM6 | Time | 6 | |
29 | WORKSTRT_3 | Work Start[3] | Time | TM6 | 6 | |
30 | WORKSTRT_4 | Work Start[4] | Time | TM6 | 6 | |
31 | WORKSTRT_5 | Work Start[5] | Time | TM6 | 6 | |
32 | WORKSTRT_6 | Work Start[6] | Time | TM6 | 6 | |
33 | WORKSTRT_7 | Work Start[7] | Time | TM6 | 6 | |
34 | WORKEND_1 | Work End[1] | Time | TM6 | 6 | |
35 | WORKEND_2 | Work End[2] | Time | TM6 | 6 | |
36 | WORKEND | Work End | TM6 | Time | 6 | |
37 | WORKEND_3 | Work End[3] | Time | TM6 | 6 | |
38 | WORKEND_4 | Work End[4] | Time | TM6 | 6 | |
39 | WORKEND_5 | Work End[5] | Time | TM6 | 6 | |
40 | WORKEND_6 | Work End[6] | Time | TM6 | 6 | |
41 | WORKEND_7 | Work End[7] | Time | TM6 | 6 | |
42 | DTEHIRE | Date Hired | Date | DT_Date | 6 | |
43 | DTETERM | Date Term | Date | DT_Date | 6 | |
44 | TECHSTAT | Tech Status | String | STR10_LBAU | 10 | |
45 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Technician Master'].LOCNCODE AS 'Technician Master-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SVC00100 AS ['Technician Master']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Technician Master'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
46 | LOCCODEB | Location Code Bad | String | STR10_Location_Code | 10 | |
47 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Technician Master'].NOTEINDX AS 'Technician Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SVC00100 AS ['Technician Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Technician Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
48 | PRCLEVEL | PriceLevel | String | STR10_LBAU | 10 | |
49 | IVRPassword | IVRPassword | String | STR10 | 10 | |
50 | IVROptions | IVROptions | String | STR255 | 255 | |
51 | IVRLoginDate | IVRLoginDate | Date | DATE | 6 | |
52 | IVRPassDate | IVRPassDate | Date | DATE | 6 | |
53 | IVRAccess | IVRAccess | Long Integer | long | 8 | |
54 | IVRGreet | IVRGreet | String | STR255 | 255 | |
55 | ADDRESS3 | Address 3 | String | STR60 | 60 | |
56 | COUNTRY | Country | String | STR60 | 60 | |
57 | SVC_ItemSiteDelta | SVC ItemSiteDelta | Boolean | CB | 0 | |
58 | SVC_LastCommDate | SVC LastCommDate | Date | DT | 8 | |
59 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['Technician Master'].VENDORID AS 'Technician Master-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
SVC00100 AS ['Technician Master']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Technician Master'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
60 | EMPLOYID | Employee ID | String | STR15_Employee_ID | 15 |