Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME240484
Product: Mekorma MICR (2404)
Series: System
Display Name: Mekorma MICR Wizard Line Setup
Physical Name: ME240484
Technical Name: ME_WizardMICRLineSetupSeq 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 Wizard Line Setup'].INTERID AS 'Mekorma MICR Wizard Line Setup-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
ME240484 AS ['Mekorma MICR Wizard Line Setup']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Mekorma MICR Wizard Line Setup'].INTERID = ['Company Master'].INTERID2 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Mekorma MICR Wizard Line Setup'].CHEKBKID AS 'Mekorma MICR Wizard Line Setup-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ME240484 AS ['Mekorma MICR Wizard Line Setup']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Mekorma MICR Wizard Line Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID3 ME_Upgrade ME_Upgrade CB Boolean 0 4 METOPROCESS ME_ToProcess CB Boolean 0 5 MECOMPLETED ME_Completed CB Boolean 0 6 MEACCTNUMBER ME_AccountNumber STR12 String 12 7 RIGHTSTARTPOSITION1 ME_RightStartPosition1 ME_RightStartPosition1 Integer 0 8 TRNSTNBR Transit Number STR9 String 9 9 RIGHTSTARTPOSITION2 ME_RightStartPosition2 INT2 Integer 2 10 NUMBERDIGITSCHECK ME_NumberDigitsCheck ME_NumberDigitsCheck Integer 0 11 RIGHTSTARTPOSITION3 ME_RightStartPosition3 ME_RightStartPosition3 Integer 0 12 CITISTATEPREFIX ME_CityStatePrefix INT2 Integer 2 13 resvstr1 ME_Transit_Number STR25 String 25 14 ME_MICR_1 ME_MICR[1] ME_Char String 1 15 ME_MICR_2 ME_MICR[2] ME_Char String 1 16 ME_MICR_3 ME_MICR[3] ME_Char String 1 17 ME_MICR_4 ME_MICR[4] ME_Char String 1 18 ME_MICR_5 ME_MICR[5] ME_Char String 1 19 ME_MICR_6 ME_MICR[6] ME_Char String 1 20 ME_MICR_7 ME_MICR[7] ME_Char String 1 21 ME_MICR_8 ME_MICR[8] ME_Char String 1 22 ME_MICR_9 ME_MICR[9] ME_Char String 1 23 ME_MICR_10 ME_MICR[10] ME_Char String 1 24 ME_MICR_11 ME_MICR[11] ME_Char String 1 25 ME_MICR_12 ME_MICR[12] ME_Char String 1 26 ME_MICR_13 ME_MICR[13] ME_Char String 1 27 ME_MICR_14 ME_MICR[14] ME_Char String 1 28 ME_MICR_15 ME_MICR[15] ME_Char String 1 29 ME_MICR_16 ME_MICR[16] ME_Char String 1 30 ME_MICR_17 ME_MICR[17] ME_Char String 1 31 ME_MICR_18 ME_MICR[18] ME_Char String 1 32 ME_MICR_19 ME_MICR[19] ME_Char String 1 33 ME_MICR_20 ME_MICR[20] ME_Char String 1 34 ME_MICR_21 ME_MICR[21] ME_Char String 1 35 ME_MICR_22 ME_MICR[22] ME_Char String 1 36 ME_MICR_23 ME_MICR[23] ME_Char String 1 37 ME_MICR_24 ME_MICR[24] ME_Char String 1 38 ME_MICR_25 ME_MICR[25] ME_Char String 1 39 ME_MICR_26 ME_MICR[26] ME_Char String 1 40 ME_MICR_27 ME_MICR[27] ME_Char String 1 41 ME_MICR_28 ME_MICR[28] ME_Char String 1 42 ME_MICR_29 ME_MICR[29] ME_Char String 1 43 ME_MICR_30 ME_MICR[30] ME_Char String 1 44 ME_MICR_31 ME_MICR[31] ME_Char String 1 45 ME_MICR_32 ME_MICR[32] ME_Char String 1 46 ME_MICR_33 ME_MICR[33] ME_Char String 1 47 ME_MICR_34 ME_MICR[34] ME_Char String 1 48 ME_MICR_35 ME_MICR[35] ME_Char String 1 49 ME_MICR_36 ME_MICR[36] ME_Char String 1 50 ME_MICR_37 ME_MICR[37] ME_Char String 1 51 ME_MICR_38 ME_MICR[38] ME_Char String 1 52 ME_MICR_39 ME_MICR[39] ME_Char String 1 53 ME_MICR_40 ME_MICR[40] ME_Char String 1 54 ME_MICR_41 ME_MICR[41] ME_Char String 1 55 ME_MICR_42 ME_MICR[42] ME_Char String 1 56 ME_MICR_43 ME_MICR[43] ME_Char String 1 57 ME_MICR_44 ME_MICR[44] ME_Char String 1 58 ME_MICR_45 ME_MICR[45] ME_Char String 1 59 numXs ME_Number_of_Xs INT5 Integer 4 60 INACTIVE Inactive CB_Inactive Boolean 0 61 MEDESC ME_Description STR100 String 100