Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/XLVerAct
Product: Excel-Based Budgeting (1878)
Series:
Display Name: XLVerifyAccounts
Physical Name: XLVerAct
Technical Name: XLVerifyAccountsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['XLVerifyAccounts'].USERID AS 'XLVerifyAccounts-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
XLVerAct AS ['XLVerifyAccounts']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['XLVerifyAccounts'].USERID = ['Users Master'].USERID2 ACTNUMBR_1 Account Number:Account_Segment_Pool1 String Account_Segment_Pool1 6 3 ACTNUMBR_2 Account Number:Account_Segment_Pool2 String Account_Segment_Pool2 6 4 ACTNUMBR_3 Account Number:Account_Segment_Pool3 String Account_Segment_Pool3 6 5 ACTNUMBR_4 Account Number:Account_Segment_Pool4 String Account_Segment_Pool4 6 6 ACTNUMBR_5 Account Number:Account_Segment_Pool5 String Account_Segment_Pool5 6 7 ACTNUMBR_6 Account Number:Account_Segment_Pool6 String Account_Segment_Pool6 6 8 ACTNUMBR_7 Account Number:Account_Segment_Pool7 String Account_Segment_Pool7 6 9 ACTNUMBR_8 Account Number:Account_Segment_Pool8 String Account_Segment_Pool8 6 10 ACTNUMBR_9 Account Number:Account_Segment_Pool9 String Account_Segment_Pool9 6 11 ACTNUMBR_10 Account Number:Account_Segment_Pool10 String Account_Segment_Pool10 6 12 ACTDESCR Account Description String STR50 50 13 INCLUDED Included Boolean CB 0