Technician Master (SVC00100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00100

Product: FieldService (949)
Series: Project

Display Name: Technician Master
Physical Name: SVC00100
Technical Name: SVC_Tech_MSTR

Group Display Name: Service Table Group
Group Technical Name: Service

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1TECHID SearchTech IDSTR10_LBAUString1210
2NAME SearchNameSTR30String3230
3ADDRESS1 SearchAddress 1STR60String6260
4ADDRESS2 SearchAddress 2STR60String6260
5CITY SearchCitySTR35String3635
6STATE SearchStateSTR30_StateString3029
7ZIPCODE SearchZip CodeSTR10String1210
8MANAGER SearchManagerSTR10String1210
9OFFID SearchOffice IDSTR10_LBAUString1210
10PHONE1 SearchPhone 1Phone_NumberString2214
11PHONE2 SearchPhone 2Phone_NumberString2214
12PAGER1 SearchPager1STR98String10098
13PIN1 SearchPin1STR10String1210
14PAGER2 SearchPager2STR98String10098
15PIN2 SearchPin2STR10String1210
16TECHEMAIL SearchTech emailSTR98String10098
17TECHEMAIL2 SearchTech email2STR98String10098
18WORKDYS SearchWork DaysCBBoolean20
19WORKDYS_1 SearchWork Days[1]CBBoolean20
20WORKDYS_2 SearchWork Days[2]CBBoolean20
21WORKDYS_3 SearchWork Days[3]CBBoolean20
22WORKDYS_4 SearchWork Days[4]CBBoolean20
23WORKDYS_5 SearchWork Days[5]CBBoolean20
24WORKDYS_6 SearchWork Days[6]CBBoolean20
25WORKDYS_7 SearchWork Days[7]CBBoolean20
26WORKSTRT SearchWork StartTM6Time46
27WORKSTRT_1 SearchWork Start[1]TM6Time46
28WORKSTRT_2 SearchWork Start[2]TM6Time46
29WORKSTRT_3 SearchWork Start[3]TM6Time46
30WORKSTRT_4 SearchWork Start[4]TM6Time46
31WORKSTRT_5 SearchWork Start[5]TM6Time46
32WORKSTRT_6 SearchWork Start[6]TM6Time46
33WORKSTRT_7 SearchWork Start[7]TM6Time46
34WORKEND SearchWork EndTM6Time46
35WORKEND_1 SearchWork End[1]TM6Time46
36WORKEND_2 SearchWork End[2]TM6Time46
37WORKEND_3 SearchWork End[3]TM6Time46
38WORKEND_4 SearchWork End[4]TM6Time46
39WORKEND_5 SearchWork End[5]TM6Time46
40WORKEND_6 SearchWork End[6]TM6Time46
41WORKEND_7 SearchWork End[7]TM6Time46
42DTEHIRE SearchDate HiredDT_DateDate46
43DTETERM SearchDate TermDT_DateDate46
44TECHSTAT SearchTech StatusSTR10_LBAUString1210
45LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['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
46LOCCODEB SearchLocation Code BadSTR10_Location_CodeString1210
47NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['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
48PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
49IVRPassword SearchIVRPasswordSTR10String1210
50IVROptions SearchIVROptionsSTR255String256255
51IVRLoginDate SearchIVRLoginDateDATEDate46
52IVRPassDate SearchIVRPassDateDATEDate46
53IVRAccess SearchIVRAccesslongLong Integer48
54IVRGreet SearchIVRGreetSTR255String256255
55ADDRESS3 SearchAddress 3STR60String6260
56COUNTRY SearchCountrySTR60String6260
57SVC_ItemSiteDelta SearchSVC ItemSiteDeltaCBBoolean20
58SVC_LastCommDate SearchSVC LastCommDateDTDate48
59VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['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
60EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
61DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *