Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME27609
Product: Mekorma MICR (2404)
Series: Payroll
Display Name: Mekorma MICR Payroll Check Setup Group Display Name: ME_Mekorma_MICR_Payroll_Tables
Physical Name: ME27609
Technical Name: ME_Pay_Check_Setup
Group Technical Name: ME_Mekorma_MICR_Payroll_Tables
Seq 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/hideSELECT
['Mekorma MICR Payroll Check Setup'].CHEKBKID AS 'Mekorma MICR Payroll Check Setup-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ME27609 AS ['Mekorma MICR Payroll Check Setup']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Mekorma MICR Payroll Check Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
2 | 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_Signature_ID | ME_Signature_ID | STR15_LBAU | String | 15 | |
50 | ME_Logo_ID_Array_1 | ME_Logo_ID_Array[1] | 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 | checkcomm1 | ME_CheckComment1 | STR255 | String | 255 | |
56 | resvstr1 | ME_Transit_Number | STR25 | String | 25 | |
57 | checkcomm2 | ME_CheckComment2 | STR255 | String | 255 | |
58 | checkcomm3 | ME_CheckComment3 | STR255 | String | 255 | |
59 | ME_Stub_ID | ME_Stub_ID | STR15_LBU | String | 15 | |
60 | ME_Check_Digit_Divisor | ME_Check_Digit_Divisor | ME_Check_Digit_Divisor | Integer | 1 | |
61 | ME_Using_Pre_Printed_Che | ME_Using_Pre_Printed_Check_Stock | ME_Using_Pre_Printed_Check_Stock | Boolean | 0 | |
62 | ME_Check_Digit_DR_or_DSR | ME_Check_Digit_DR_or_DSR | ME_Check_Digit_Calculation_Method_DDL | Integer | 0 | |
63 | ME_Check_Digit_Use_Zeros | ME_Check_Digit_Use_Zeros | ME_Check_Digit_Use_Zeros | Boolean | 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 |