Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME240444
Product: Mekorma MICR (2404)
Series: System
Display Name: Mekorma MICR EFT Options
Physical Name: ME240444
Technical Name: ME_EFT_OptionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMPANYID 
Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Mekorma MICR EFT Options'].CMPANYID AS 'Mekorma MICR EFT Options-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
ME240444 AS ['Mekorma MICR EFT Options']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Mekorma MICR EFT Options'].CMPANYID = ['Company Master'].CMPANYID2 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Mekorma MICR EFT Options'].CHEKBKID AS 'Mekorma MICR EFT Options-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ME240444 AS ['Mekorma MICR EFT Options']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Mekorma MICR EFT Options'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID3 MEEFTOPTIONS ME_EFT_Options ME_EFT_Options Integer 0 4 MEEFTREMFRMT ME_EFT_RemittanceStub STR132 String 132