SYIC601 - User-Company Access ODBC | Prospr - Dynamics GP Table Reference

SYIC601 - User-Company Access ODBC

Query Builder

Select * from SYIC601

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
TRKUSER	Track User	Boolean	2	View
USERID	User ID	String	16	View
CMPANYID	Company ID	Integer	2	View
SRBCHSEC_1	Series Batch Security[1]	Long Integer	4	View
SRBCHSEC_2	Series Batch Security[2]	Long Integer	4	View
SRBCHSEC_3	Series Batch Security[3]	Long Integer	4	View
SRBCHSEC_4	Series Batch Security[4]	Long Integer	4	View
SRBCHSEC_5	Series Batch Security[5]	Long Integer	4	View
SRBCHSEC_6	Series Batch Security[6]	Long Integer	4	View
SRBCHSEC_7	Series Batch Security[7]	Long Integer	4	View
SRSFNSEC_1	Series Function Security[1]	Long Integer	4	View
SRSFNSEC_2	Series Function Security[2]	Long Integer	4	View
SRSFNSEC_3	Series Function Security[3]	Long Integer	4	View
SRSFNSEC_4	Series Function Security[4]	Long Integer	4	View
SRSFNSEC_5	Series Function Security[5]	Long Integer	4	View
SRSFNSEC_6	Series Function Security[6]	Long Integer	4	View
SRSFNSEC_7	Series Function Security[7]	Long Integer	4	View
MSCPRMIS	Misc Permissions	Long Integer	4	View