Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME142803
Product: Electronic Reconcile (1428)
Series:
Display Name: ME AutoRec Formats
Physical Name: ME142803
Technical Name: ME_AutoRec_FormatsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MEBANKID 
ME_Bank_ID String STR20_LBAU 20 2 MEBANKDESC ME_Bank_Description_Location String STR50 50 3 ME_FileType ME_FileType Integer ME_FileTypeDLL 0 4 ME_Delimiter ME_Delimiter String ME_String1_Delimiter 1 5 ME_RecordLength ME_RecordLength Integer INT5_RU0 5 6 ME_FromPosition ME_FromPosition Integer INT3_U0 3 7 ME_ToPosition ME_ToPosition Integer INT3_U0 3 8 ME_FieldNumber ME_FieldNumber Integer INT3_U0 3 9 ME_Uses_Status_Codes ME_Uses_Status_Codes Boolean ME_CB_UsesStatusCodes 0 10 USERDATE User Date Date DT 8 11 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ME AutoRec Formats'].USERID AS 'ME AutoRec Formats-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ME142803 AS ['ME AutoRec Formats']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ME AutoRec Formats'].USERID = ['Users Master'].USERID12 ME_File_Format ME File Format Integer ME_DDL_File_Format 0 13 ME_Record_Delimiter ME Record Delimiter Boolean ME_CB_Record_Delimiter 0