Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/paDBLog
Product: Company Archive (1755)
Series: Company
Display Name: PA Database Tool Log
Physical Name: paDBLog
Technical Name: paDBLogSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TYPEID 
Type ID INT Integer 0 2 MESSAGE Message STR50 String 50 3 LSTCHKDT Last Check Date DT Date 8 4 TIME1 Time TM6 Time 6 5 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PA Database Tool Log'].USERID AS 'PA Database Tool Log-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
paDBLog AS ['PA Database Tool Log']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PA Database Tool Log'].USERID = ['Users Master'].USERID6 Count1 Count Long Int Long Integer 8 7 DATE1 Date DT6 Date 6 8 Script_Name Script Name STR80 String 80 9 ADINFTXT Added Info Text TX32000 Text 32000