Office Master (SVC00902)

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

Product: FieldService (949)
Series: Project

Display Name: Office Master
Physical Name: SVC00902
Technical Name: SVC_Office_MSTR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1OFFID SearchOffice IDSTR10_LBAUString1210
2OFFNAME SearchOffice NameSTR20String2220
3ADDRESS1 SearchAddress 1STR60String6260
4ADDRESS2 SearchAddress 2STR60String6260
5CITY SearchCitySTR35String3635
6STATE SearchStateSTR30_StateString3029
7ZIP SearchZipSTR10String1210
8COUNTRY SearchCountrySTR60String6260
9CNTCPRSN SearchContact PersonSTR60String6260
10PHONE1 SearchPhone 1Phone_NumberString2214
11FAXNUMBR SearchFax NumberSTR14_FAXString2214
12TECHEMAIL SearchTech emailSTR98String10098
13MANAGER SearchManagerSTR10String1210
14TIMEZONE SearchTimeZoneSTR3_LBUString43
15LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Office Master'].LOCNCODE AS 'Office Master-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC00902 AS ['Office Master']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Office Master'].LOCNCODE = ['Site Setup'].LOCNCODE
16LOCCODBK SearchLocation Code BackupSTR10_Location_CodeString1210
17WORKDYS SearchWork DaysCBBoolean20
18WORKDYS_1 SearchWork Days[1]CBBoolean20
19WORKDYS_2 SearchWork Days[2]CBBoolean20
20WORKDYS_3 SearchWork Days[3]CBBoolean20
21WORKDYS_4 SearchWork Days[4]CBBoolean20
22WORKDYS_5 SearchWork Days[5]CBBoolean20
23WORKDYS_6 SearchWork Days[6]CBBoolean20
24WORKDYS_7 SearchWork Days[7]CBBoolean20
25WORKSTRT SearchWork StartTM6Time46
26WORKSTRT_1 SearchWork Start[1]TM6Time46
27WORKSTRT_2 SearchWork Start[2]TM6Time46
28WORKSTRT_3 SearchWork Start[3]TM6Time46
29WORKSTRT_4 SearchWork Start[4]TM6Time46
30WORKSTRT_5 SearchWork Start[5]TM6Time46
31WORKSTRT_6 SearchWork Start[6]TM6Time46
32WORKSTRT_7 SearchWork Start[7]TM6Time46
33WORKEND SearchWork EndTM6Time46
34WORKEND_1 SearchWork End[1]TM6Time46
35WORKEND_2 SearchWork End[2]TM6Time46
36WORKEND_3 SearchWork End[3]TM6Time46
37WORKEND_4 SearchWork End[4]TM6Time46
38WORKEND_5 SearchWork End[5]TM6Time46
39WORKEND_6 SearchWork End[6]TM6Time46
40WORKEND_7 SearchWork End[7]TM6Time46
41Return_Location_Code SearchReturn Location CodeSTR10_Location_CodeString1210
42NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Office Master'].NOTEINDX AS 'Office Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC00902 AS ['Office Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Office Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
43ADDRESS3 SearchAddress 3STR60String6260
44DEX_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 *