Office Master (SVC00902)

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

Product: FieldService (949)
Series:

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 TypeLength
1OFFID SearchOffice IDStringSTR10_LBAU10
2OFFNAME SearchOffice NameStringSTR2020
3ADDRESS1 SearchAddress 1StringSTR6060
4ADDRESS2 SearchAddress 2StringSTR6060
5CITY SearchCityStringSTR3535
6STATE SearchStateStringSTR30_State29
7ZIP SearchZipStringSTR1010
8COUNTRY SearchCountryStringSTR6060
9CNTCPRSN SearchContact PersonStringSTR6060
10PHONE1 SearchPhone 1StringPhone_Number14
11FAXNUMBR SearchFax NumberStringSTR14_FAX14
12TECHEMAIL SearchTech emailStringSTR9898
13MANAGER SearchManagerStringSTR1010
14TIMEZONE SearchTimeZoneStringSTR3_LBU3
15LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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 BackupStringSTR10_Location_Code10
17WORKDYS SearchWork DaysCBBoolean0
18WORKDYS_1 SearchWork Days[1]BooleanCB0
19WORKDYS_2 SearchWork Days[2]BooleanCB0
20WORKDYS_3 SearchWork Days[3]BooleanCB0
21WORKDYS_4 SearchWork Days[4]BooleanCB0
22WORKDYS_5 SearchWork Days[5]BooleanCB0
23WORKDYS_6 SearchWork Days[6]BooleanCB0
24WORKDYS_7 SearchWork Days[7]BooleanCB0
25WORKSTRT_1 SearchWork Start[1]TimeTM66
26WORKSTRT_2 SearchWork Start[2]TimeTM66
27WORKSTRT SearchWork StartTM6Time6
28WORKSTRT_3 SearchWork Start[3]TimeTM66
29WORKSTRT_4 SearchWork Start[4]TimeTM66
30WORKSTRT_5 SearchWork Start[5]TimeTM66
31WORKSTRT_6 SearchWork Start[6]TimeTM66
32WORKSTRT_7 SearchWork Start[7]TimeTM66
33WORKEND_1 SearchWork End[1]TimeTM66
34WORKEND_2 SearchWork End[2]TimeTM66
35WORKEND SearchWork EndTM6Time6
36WORKEND_3 SearchWork End[3]TimeTM66
37WORKEND_4 SearchWork End[4]TimeTM66
38WORKEND_5 SearchWork End[5]TimeTM66
39WORKEND_6 SearchWork End[6]TimeTM66
40WORKEND_7 SearchWork End[7]TimeTM66
41Return_Location_Code SearchReturn Location CodeStringSTR10_Location_Code10
42NOTEINDX SearchNote IndexCurrencyDLR1414
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 3StringSTR6060

Leave a Reply

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