Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TA60100
Product: Technical Service Tools (1838)
Series:
Display Name: User-Company Access
Physical Name: TA60100
Technical Name: TA_User_Company_AccessSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TRKUSER 
Track User Boolean CB 0 2 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['User-Company Access'].USERID AS 'User-Company Access-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
TA60100 AS ['User-Company Access']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['User-Company Access'].USERID = ['Users Master'].USERID3 CMPANYID Company ID Integer INT5 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['User-Company Access'].CMPANYID AS 'User-Company Access-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
TA60100 AS ['User-Company Access']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['User-Company Access'].CMPANYID = ['Company Master'].CMPANYID4 SRBCHSEC_1 Series Batch Security[1] Long Integer ML_Posting_Permissions 0 5 SRBCHSEC_2 Series Batch Security[2] Long Integer ML_Posting_Permissions 0 6 SRBCHSEC_3 Series Batch Security[3] Long Integer ML_Posting_Permissions 0 7 SRBCHSEC_4 Series Batch Security[4] Long Integer ML_Posting_Permissions 0 8 SRBCHSEC_5 Series Batch Security[5] Long Integer ML_Posting_Permissions 0 9 SRBCHSEC_6 Series Batch Security[6] Long Integer ML_Posting_Permissions 0 10 SRBCHSEC_7 Series Batch Security[7] Long Integer ML_Posting_Permissions 0 11 SRSFNSEC_1 Series Function Security[1] Long Integer ML_Series_Functions_Permissions 0 12 SRSFNSEC_2 Series Function Security[2] Long Integer ML_Series_Functions_Permissions 0 13 SRSFNSEC_3 Series Function Security[3] Long Integer ML_Series_Functions_Permissions 0 14 SRSFNSEC_4 Series Function Security[4] Long Integer ML_Series_Functions_Permissions 0 15 SRSFNSEC_5 Series Function Security[5] Long Integer ML_Series_Functions_Permissions 0 16 SRSFNSEC_6 Series Function Security[6] Long Integer ML_Series_Functions_Permissions 0 17 SRSFNSEC_7 Series Function Security[7] Long Integer ML_Series_Functions_Permissions 0 18 MSCPRMIS Misc Permissions Long Integer ML_Misc_Permissions 0 19 BUYERACTIVE Buyer Active Boolean CB 0