Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME291609
Product: MICR for Canadian Payroll (2916)
Series: Payroll
Display Name: MICR Payroll Check Setup
Physical Name: ME291609
Technical Name: ME_Pay_Check_SetupSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CHEKBKID 
Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['MICR Payroll Check Setup'].CHEKBKID AS 'MICR Payroll Check Setup-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ME291609 AS ['MICR Payroll Check Setup']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['MICR Payroll Check Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID2 ME_Check_Format_ID ME_Check_Format_ID STR15_LBU String 15 3 ME_MICR_1 ME_MICR[1] ME_Char String 1 4 ME_MICR_2 ME_MICR[2] ME_Char String 1 5 ME_MICR_3 ME_MICR[3] ME_Char String 1 6 ME_MICR_4 ME_MICR[4] ME_Char String 1 7 ME_MICR_5 ME_MICR[5] ME_Char String 1 8 ME_MICR_6 ME_MICR[6] ME_Char String 1 9 ME_MICR_7 ME_MICR[7] ME_Char String 1 10 ME_MICR_8 ME_MICR[8] ME_Char String 1 11 ME_MICR_9 ME_MICR[9] ME_Char String 1 12 ME_MICR_10 ME_MICR[10] ME_Char String 1 13 ME_MICR_11 ME_MICR[11] ME_Char String 1 14 ME_MICR_12 ME_MICR[12] ME_Char String 1 15 ME_MICR_13 ME_MICR[13] ME_Char String 1 16 ME_MICR_14 ME_MICR[14] ME_Char String 1 17 ME_MICR_15 ME_MICR[15] ME_Char String 1 18 ME_MICR_16 ME_MICR[16] ME_Char String 1 19 ME_MICR_17 ME_MICR[17] ME_Char String 1 20 ME_MICR_18 ME_MICR[18] ME_Char String 1 21 ME_MICR_19 ME_MICR[19] ME_Char String 1 22 ME_MICR_20 ME_MICR[20] ME_Char String 1 23 ME_MICR_21 ME_MICR[21] ME_Char String 1 24 ME_MICR_22 ME_MICR[22] ME_Char String 1 25 ME_MICR_23 ME_MICR[23] ME_Char String 1 26 ME_MICR_24 ME_MICR[24] ME_Char String 1 27 ME_MICR_25 ME_MICR[25] ME_Char String 1 28 ME_MICR_26 ME_MICR[26] ME_Char String 1 29 ME_MICR_27 ME_MICR[27] ME_Char String 1 30 ME_MICR_28 ME_MICR[28] ME_Char String 1 31 ME_MICR_29 ME_MICR[29] ME_Char String 1 32 ME_MICR_30 ME_MICR[30] ME_Char String 1 33 ME_MICR_31 ME_MICR[31] ME_Char String 1 34 ME_MICR_32 ME_MICR[32] ME_Char String 1 35 ME_MICR_33 ME_MICR[33] ME_Char String 1 36 ME_MICR_34 ME_MICR[34] ME_Char String 1 37 ME_MICR_35 ME_MICR[35] ME_Char String 1 38 ME_MICR_36 ME_MICR[36] ME_Char String 1 39 ME_MICR_37 ME_MICR[37] ME_Char String 1 40 ME_MICR_38 ME_MICR[38] ME_Char String 1 41 ME_MICR_39 ME_MICR[39] ME_Char String 1 42 ME_MICR_40 ME_MICR[40] ME_Char String 1 43 ME_MICR_41 ME_MICR[41] ME_Char String 1 44 ME_MICR_42 ME_MICR[42] ME_Char String 1 45 ME_MICR_43 ME_MICR[43] ME_Char String 1 46 ME_MICR_44 ME_MICR[44] ME_Char String 1 47 ME_MICR_45 ME_MICR[45] ME_Char String 1 48 CHKFORM ME_Check_Format ME_Check_Format_DDL Integer 0 49 ME_Logo_ID_Array_1 ME_Logo_ID_Array[1] STR15_LBAU String 15 50 ME_Signature_ID ME_Signature_ID STR15_LBAU String 15 51 ME_Logo_ID_Array_2 ME_Logo_ID_Array[2] STR15_LBAU String 15 52 ME_Logo_ID_Array_3 ME_Logo_ID_Array[3] STR15_LBAU String 15 53 dupdll ME_duplicates ME_Duplicates_DDL Integer 0 54 numXs ME_Number_of_Xs INT5 Integer 4 55 resvstr1 ME_Transit_Number STR25 String 25 56 checkcomm1 ME_CheckComment1 STR255 String 255 57 checkcomm3 ME_CheckComment3 STR255 String 255 58 checkcomm2 ME_CheckComment2 STR255 String 255 59 ME_Stub_ID ME_Stub_ID STR15_LBU String 15 60 ME_Using_Pre_Printed_Che ME_Using_Pre_Printed_Check_Stock ME_Using_Pre_Printed_Check_Stock Boolean 0 61 ME_Check_Digit_Divisor ME_Check_Digit_Divisor ME_Check_Digit_Divisor Integer 1 62 ME_Check_Digit_Use_Zeros ME_Check_Digit_Use_Zeros ME_Check_Digit_Use_Zeros Boolean 0 63 ME_Check_Digit_DR_or_DSR ME_Check_Digit_DR_or_DSR ME_Check_Digit_Calculation_Method_DDL Integer 0 64 ME_Check_Digit_Weighted ME_Check_Digit_Weighted ME_Check_Digit_Weighted Boolean 0 65 ME_Check_Digit_Weighting ME_Check_Digit_Weighting ME_Check_Digit_Weighting Long Integer 10