SVC00902 - Office Master | Prospr - Dynamics GP Table Reference

SVC00902 - Office Master

Query Builder

Select * from SVC00902

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
OFFID	Office ID	String	12	View
OFFNAME	Office Name	String	22	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIP	Zip	String	12	View
COUNTRY	Country	String	62	View
CNTCPRSN	Contact Person	String	62	View
PHONE1	Phone 1	String	22	View
FAXNUMBR	Fax Number	String	22	View
TECHEMAIL	Tech email	String	100	View
MANAGER	Manager	String	12	View
TIMEZONE	TimeZone	String	4	View
LOCNCODE	Location Code	String	12	View
LOCCODBK	Location Code Backup	String	12	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
Return_Location_Code	Return Location Code	String	12	View
NOTEINDX	Note Index	Currency	10	View
ADDRESS3	Address 3	String	62	View