Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME240475
Product: Mekorma MICR (2404)
Series: System
Display Name: Mekorma MICR Signature Files
Physical Name: ME240475
Technical Name: ME_SignatureFilesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 INTERID 
Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Mekorma MICR Signature Files'].INTERID AS 'Mekorma MICR Signature Files-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
ME240475 AS ['Mekorma MICR Signature Files']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Mekorma MICR Signature Files'].INTERID = ['Company Master'].INTERID2 BusObjKey BusObjKey STR200 String 200 3 Attachment_ID Attachment ID GUIDString String 36 4 FILENAME File Name STR45 String 45 5 FilePath FilePath STR255 String 255 6 CRUSRID Created User ID STR15_User_ID String 15 7 CREATDDT Created Date DT Date 8