Technician Master (SVC00100)

azurecurve Products FieldService (949)ProjectTechnician Master (SVC00100)

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

Display Name: Technician Master
Physical Name: SVC00100
Technical Name: SVC_Tech_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	TECHID	Tech ID	String	STR10_LBAU	10
2	NAME	Name	String	STR30	30
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	ZIPCODE	Zip Code	String	STR10	10
8	MANAGER	Manager	String	STR10	10
9	OFFID	Office ID	String	STR10_LBAU	10
10	PHONE1	Phone 1	String	Phone_Number	14
11	PHONE2	Phone 2	String	Phone_Number	14
12	PAGER1	Pager1	String	STR98	98
13	PIN1	Pin1	String	STR10	10
14	PAGER2	Pager2	String	STR98	98
15	PIN2	Pin2	String	STR10	10
16	TECHEMAIL	Tech email	String	STR98	98
17	TECHEMAIL2	Tech email2	String	STR98	98
18	WORKDYS_1	Work Days[1]	Boolean	CB	0
19	WORKDYS	Work Days	CB	Boolean	0
20	WORKDYS_2	Work Days[2]	Boolean	CB	0
21	WORKDYS_3	Work Days[3]	Boolean	CB	0
22	WORKDYS_4	Work Days[4]	Boolean	CB	0
23	WORKDYS_5	Work Days[5]	Boolean	CB	0
24	WORKDYS_6	Work Days[6]	Boolean	CB	0
25	WORKDYS_7	Work Days[7]	Boolean	CB	0
26	WORKSTRT_1	Work Start[1]	Time	TM6	6
27	WORKSTRT_2	Work Start[2]	Time	TM6	6
28	WORKSTRT	Work Start	TM6	Time	6
29	WORKSTRT_3	Work Start[3]	Time	TM6	6
30	WORKSTRT_4	Work Start[4]	Time	TM6	6
31	WORKSTRT_5	Work Start[5]	Time	TM6	6
32	WORKSTRT_6	Work Start[6]	Time	TM6	6
33	WORKSTRT_7	Work Start[7]	Time	TM6	6
34	WORKEND_1	Work End[1]	Time	TM6	6
35	WORKEND_2	Work End[2]	Time	TM6	6
36	WORKEND	Work End	TM6	Time	6
37	WORKEND_3	Work End[3]	Time	TM6	6
38	WORKEND_4	Work End[4]	Time	TM6	6
39	WORKEND_5	Work End[5]	Time	TM6	6
40	WORKEND_6	Work End[6]	Time	TM6	6
41	WORKEND_7	Work End[7]	Time	TM6	6
42	DTEHIRE	Date Hired	Date	DT_Date	6
43	DTETERM	Date Term	Date	DT_Date	6
44	TECHSTAT	Tech Status	String	STR10_LBAU	10
45	LOCNCODE	Location Code	String	STR10_Location_Code	10
	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
46	LOCCODEB	Location Code Bad	String	STR10_Location_Code	10
47	NOTEINDX	Note Index	Currency	DLR14	14
	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
48	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
49	IVRPassword	IVRPassword	String	STR10	10
50	IVROptions	IVROptions	String	STR255	255
51	IVRLoginDate	IVRLoginDate	Date	DATE	6
52	IVRPassDate	IVRPassDate	Date	DATE	6
53	IVRAccess	IVRAccess	Long Integer	long	8
54	IVRGreet	IVRGreet	String	STR255	255
55	ADDRESS3	Address 3	String	STR60	60
56	COUNTRY	Country	String	STR60	60
57	SVC_ItemSiteDelta	SVC ItemSiteDelta	Boolean	CB	0
58	SVC_LastCommDate	SVC LastCommDate	Date	DT	8
59	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	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
60	EMPLOYID	Employee ID	String	STR15_Employee_ID	15

azurecurve Products FieldService (949)ProjectTechnician Master (SVC00100)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply