Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME142802
Product: Electronic Reconcile (1428)
Series: Financial
Display Name: ME AutoRec Download MSTR DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: ME142802
Technical Name: ME_Auto_Rec_Download_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 ARNUM 
ME_AutoRec_Number STR20_LBAU String 22 20 2 MEBANKID ME_Bank_ID STR20_LBAU String 22 20 3 Output_Format ME_Output_Format STR20 String 22 20 4 BANKID Bank ID STR15_Bank_ID String 16 15 5 BANKNAME Bank Name STR30 String 32 30 6 BNKBRNCH Bank Branch STR20 String 22 20 7 PHONE1 Phone 1 Phone_Number String 22 14 8 PHONE2 Phone 2 Phone_Number String 22 14 9 HYPELINK ME_Use_Hyperterminal_Link ME_CB_User_Hyperterminal Boolean 2 0 10 ARDLFILAPTH ME_DL_File_and_Path STR80 String 82 80 11 ME_CommLink_Path ME_CommLink_Path STR80 String 82 80 12 MEARDLID ME_DownloadID STR20 String 22 20 13 MKLSSTDD ME_Last_Download_Date DT Date 4 8 14 MELDTDT ME_Last_Download_Time TM6 Time 4 6 15 Last_Reconciled_Date Last Reconciled Date DT Date 4 8 16 Last_Reconciled_Balance Last Reconciled Balance DLR19_$S2 Currency 10 19 17 ME_Number_of_Checks ME_Number_of_Checks INT5 Integer 2 4 18 ME_Number_of_deps ME_Number_of_Deposits INT5 Integer 2 4 19 ME_Debits_Total ME_Debits_Total DLR17_$U2 Currency 10 17 20 ME_Credits_Total ME_Credits_Total DLR17_$U2 Currency 10 17 21 USERDATE User Date DT Date 4 8 22 USERID User ID STR15_User_ID String 16 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'].USERID23 DEX_ROW_ID int int 10 10