Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA003502
Product: Company Archive (1755)
Series: System
Display Name: PA - Registration
Physical Name: PA003502
Technical Name: paRegistrationSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 UNIQKEY 
Key STR1 String 1 2 paRegkey paRegkey STR20 String 20 3 Expiry_Date Expiry Date DATE Date 6 4 PA_Years PA_Years INT2 Integer 2 5 PA_Months PA_Months INT2 Integer 2 6 PA_RemoveOnlyAllowed PA_RemoveOnlyAllowed PA_RemoveOnlyAllowedCB Boolean 0 7 PA_BulkArchive PA_BulkArchive PA_BulkArchiveCB Boolean 0 8 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PA - Registration'].USERID AS 'PA - Registration-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PA003502 AS ['PA - Registration']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PA - Registration'].USERID = ['Users Master'].USERID9 DATEDONE Date Done DT Date 8 10 TRXSize TRXSize Long_10U Long Integer 10 11 NUMOFTRX Number Of TRX LI6_U0 Long Integer 6