Office Master (SVC00902)

azurecurve Products FieldService (949)ProjectOffice Master (SVC00902)

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

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

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	OFFID	Office ID	String	STR10_LBAU	10
2	OFFNAME	Office Name	String	STR20	20
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	ZIP	Zip	String	STR10	10
8	COUNTRY	Country	String	STR60	60
9	CNTCPRSN	Contact Person	String	STR60	60
10	PHONE1	Phone 1	String	Phone_Number	14
11	FAXNUMBR	Fax Number	String	STR14_FAX	14
12	TECHEMAIL	Tech email	String	STR98	98
13	MANAGER	Manager	String	STR10	10
14	TIMEZONE	TimeZone	String	STR3_LBU	3
15	LOCNCODE	Location Code	String	STR10_Location_Code	10
	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
16	LOCCODBK	Location Code Backup	String	STR10_Location_Code	10
17	WORKDYS_1	Work Days[1]	Boolean	CB	0
18	WORKDYS	Work Days	CB	Boolean	0
19	WORKDYS_2	Work Days[2]	Boolean	CB	0
20	WORKDYS_3	Work Days[3]	Boolean	CB	0
21	WORKDYS_4	Work Days[4]	Boolean	CB	0
22	WORKDYS_5	Work Days[5]	Boolean	CB	0
23	WORKDYS_6	Work Days[6]	Boolean	CB	0
24	WORKDYS_7	Work Days[7]	Boolean	CB	0
25	WORKSTRT_1	Work Start[1]	Time	TM6	6
26	WORKSTRT_2	Work Start[2]	Time	TM6	6
27	WORKSTRT	Work Start	TM6	Time	6
28	WORKSTRT_3	Work Start[3]	Time	TM6	6
29	WORKSTRT_4	Work Start[4]	Time	TM6	6
30	WORKSTRT_5	Work Start[5]	Time	TM6	6
31	WORKSTRT_6	Work Start[6]	Time	TM6	6
32	WORKSTRT_7	Work Start[7]	Time	TM6	6
33	WORKEND_1	Work End[1]	Time	TM6	6
34	WORKEND_2	Work End[2]	Time	TM6	6
35	WORKEND_3	Work End[3]	Time	TM6	6
36	WORKEND	Work End	TM6	Time	6
37	WORKEND_4	Work End[4]	Time	TM6	6
38	WORKEND_5	Work End[5]	Time	TM6	6
39	WORKEND_6	Work End[6]	Time	TM6	6
40	WORKEND_7	Work End[7]	Time	TM6	6
41	Return_Location_Code	Return Location Code	String	STR10_Location_Code	10
42	NOTEINDX	Note Index	Currency	DLR14	14
	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
43	ADDRESS3	Address 3	String	STR60	60

azurecurve Products FieldService (949)ProjectOffice Master (SVC00902)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply