SVC00100 - Technician Master | Prospr - Dynamics GP Table Reference

SVC00100 - Technician Master

Query Builder

Select * from SVC00100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
TECHID	Tech ID	String	12	View
NAME	Name	String	32	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
MANAGER	Manager	String	12	View
OFFID	Office ID	String	12	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PAGER1	Pager1	String	100	View
PIN1	Pin1	String	12	View
PAGER2	Pager2	String	100	View
PIN2	Pin2	String	12	View
TECHEMAIL	Tech email	String	100	View
TECHEMAIL2	Tech email2	String	100	View
WORKDYS_1	Work Days[1]	Boolean	2	View
WORKDYS_2	Work Days[2]	Boolean	2	View
WORKDYS_3	Work Days[3]	Boolean	2	View
WORKDYS_4	Work Days[4]	Boolean	2	View
WORKDYS_5	Work Days[5]	Boolean	2	View
WORKDYS_6	Work Days[6]	Boolean	2	View
WORKDYS_7	Work Days[7]	Boolean	2	View
WORKSTRT_1	Work Start[1]	Time	4	View
WORKSTRT_2	Work Start[2]	Time	4	View
WORKSTRT_3	Work Start[3]	Time	4	View
WORKSTRT_4	Work Start[4]	Time	4	View
WORKSTRT_5	Work Start[5]	Time	4	View
WORKSTRT_6	Work Start[6]	Time	4	View
WORKSTRT_7	Work Start[7]	Time	4	View
WORKEND_1	Work End[1]	Time	4	View
WORKEND_2	Work End[2]	Time	4	View
WORKEND_3	Work End[3]	Time	4	View
WORKEND_4	Work End[4]	Time	4	View
WORKEND_5	Work End[5]	Time	4	View
WORKEND_6	Work End[6]	Time	4	View
WORKEND_7	Work End[7]	Time	4	View
DTEHIRE	Date Hired	Date	4	View
DTETERM	Date Term	Date	4	View
TECHSTAT	Tech Status	String	12	View
LOCNCODE	Location Code	String	12	View
LOCCODEB	Location Code Bad	String	12	View
NOTEINDX	Note Index	Currency	10	View
PRCLEVEL	PriceLevel	String	12	View
IVRPassword	IVRPassword	String	12	View
IVROptions	IVROptions	String	256	View
IVRLoginDate	IVRLoginDate	Date	4	View
IVRPassDate	IVRPassDate	Date	4	View
IVRAccess	IVRAccess	Long Integer	4	View
IVRGreet	IVRGreet	String	256	View
ADDRESS3	Address 3	String	62	View
COUNTRY	Country	String	62	View
SVC_ItemSiteDelta	SVC ItemSiteDelta	Boolean	2	View
SVC_LastCommDate	SVC LastCommDate	Date	4	View
VENDORID	Vendor ID	String	16	View
EMPLOYID	Employee ID	String	16	View

SVC00100 - Technician Master

Query Builder

Customer Service

Information

My Account

Contact Us