Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME142802
Product: Electronic Reconcile (1428)
Series:
Display Name: ME AutoRec Download MSTR
Physical Name: ME142802
Technical Name: ME_Auto_Rec_Download_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ARNUM 
ME_AutoRec_Number String STR20_LBAU 20 2 MEBANKID ME_Bank_ID String STR20_LBAU 20 3 Output_Format ME_Output_Format String STR20 20 4 BANKID Bank ID String STR15_Bank_ID 15 5 BANKNAME Bank Name String STR30 30 6 BNKBRNCH Bank Branch String STR20 20 7 PHONE1 Phone 1 String Phone_Number 14 8 PHONE2 Phone 2 String Phone_Number 14 9 HYPELINK ME_Use_Hyperterminal_Link Boolean ME_CB_User_Hyperterminal 0 10 ARDLFILAPTH ME_DL_File_and_Path String STR80 80 11 ME_CommLink_Path ME_CommLink_Path String STR80 80 12 MEARDLID ME_DownloadID String STR20 20 13 MKLSSTDD ME_Last_Download_Date Date DT 8 14 MELDTDT ME_Last_Download_Time Time TM6 6 15 Last_Reconciled_Date Last Reconciled Date Date DT 8 16 Last_Reconciled_Balance Last Reconciled Balance Currency DLR19_$S2 19 17 ME_Number_of_Checks ME_Number_of_Checks Integer INT5 4 18 ME_Number_of_deps ME_Number_of_Deposits Integer INT5 4 19 ME_Debits_Total ME_Debits_Total Currency DLR17_$U2 17 20 ME_Credits_Total ME_Credits_Total Currency DLR17_$U2 17 21 USERDATE User Date Date DT 8 22 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ME AutoRec Download MSTR'].USERID AS 'ME AutoRec Download MSTR-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ME142802 AS ['ME AutoRec Download MSTR']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ME AutoRec Download MSTR'].USERID = ['Users Master'].USERID