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 TypeLength
1TECHID SearchTech IDSTR10_LBAUString10
2NAME SearchNameSTR30String30
3ADDRESS1 SearchAddress 1STR60String60
4ADDRESS2 SearchAddress 2STR60String60
5CITY SearchCitySTR35String35
6STATE SearchStateSTR30_StateString29
7ZIPCODE SearchZip CodeSTR10String10
8MANAGER SearchManagerSTR10String10
9OFFID SearchOffice IDSTR10_LBAUString10
10PHONE1 SearchPhone 1Phone_NumberString14
11PHONE2 SearchPhone 2Phone_NumberString14
12PAGER1 SearchPager1STR98String98
13PIN1 SearchPin1STR10String10
14PAGER2 SearchPager2STR98String98
15PIN2 SearchPin2STR10String10
16TECHEMAIL SearchTech emailSTR98String98
17TECHEMAIL2 SearchTech email2STR98String98
18WORKDYS SearchWork DaysCBBoolean0
19WORKDYS_1 SearchWork Days[1]CBBoolean0
20WORKDYS_2 SearchWork Days[2]CBBoolean0
21WORKDYS_3 SearchWork Days[3]CBBoolean0
22WORKDYS_4 SearchWork Days[4]CBBoolean0
23WORKDYS_5 SearchWork Days[5]CBBoolean0
24WORKDYS_6 SearchWork Days[6]CBBoolean0
25WORKDYS_7 SearchWork Days[7]CBBoolean0
26WORKSTRT SearchWork StartTM6Time6
27WORKSTRT_1 SearchWork Start[1]TM6Time6
28WORKSTRT_2 SearchWork Start[2]TM6Time6
29WORKSTRT_3 SearchWork Start[3]TM6Time6
30WORKSTRT_4 SearchWork Start[4]TM6Time6
31WORKSTRT_5 SearchWork Start[5]TM6Time6
32WORKSTRT_6 SearchWork Start[6]TM6Time6
33WORKSTRT_7 SearchWork Start[7]TM6Time6
34WORKEND SearchWork EndTM6Time6
35WORKEND_1 SearchWork End[1]TM6Time6
36WORKEND_2 SearchWork End[2]TM6Time6
37WORKEND_3 SearchWork End[3]TM6Time6
38WORKEND_4 SearchWork End[4]TM6Time6
39WORKEND_5 SearchWork End[5]TM6Time6
40WORKEND_6 SearchWork End[6]TM6Time6
41WORKEND_7 SearchWork End[7]TM6Time6
42DTEHIRE SearchDate HiredDT_DateDate6
43DTETERM SearchDate TermDT_DateDate6
44TECHSTAT SearchTech StatusSTR10_LBAUString10
45LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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_CodeString10
47NOTEINDX SearchNote IndexDLR14Currency14
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_LBAUString10
49IVRPassword SearchIVRPasswordSTR10String10
50IVROptions SearchIVROptionsSTR255String255
51IVRLoginDate SearchIVRLoginDateDATEDate6
52IVRPassDate SearchIVRPassDateDATEDate6
53IVRAccess SearchIVRAccesslongLong Integer8
54IVRGreet SearchIVRGreetSTR255String255
55ADDRESS3 SearchAddress 3STR60String60
56COUNTRY SearchCountrySTR60String60
57SVC_ItemSiteDelta SearchSVC ItemSiteDeltaCBBoolean0
58SVC_LastCommDate SearchSVC LastCommDateDTDate8
59VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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_IDString15
61DEX_ROW_ID Searchintint10

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 *