ME_Check_Setup_4 (ME27601)

Easily find this page again using the shortlink: http://gpt.azrcrv.co.uk/ME27601

Product: Mekorma MICR (2404)
Series: Purchasing

Display Name: Mekorma MICR Payables Check Setup
Physical Name: ME27601
Technical Name: ME_Check_Setup

Group Display Name: ME_Mekorma_MICR_Purchasing_Tables
Group Technical Name: ME_Mekorma_MICR_Purchasing_Tables

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide example SQL

SELECT
       ['Mekorma MICR Payables Check Setup'].CHEKBKID AS 'Mekorma MICR Payables Check Setup-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ME27601 AS ['Mekorma MICR Payables Check Setup']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Mekorma MICR Payables Check Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
2ME_Check_Format_ID SearchME_Check_Format_IDSTR15_LBUString1615
3ME_MICR_1 SearchME_MICR[1]ME_CharString21
4ME_MICR_2 SearchME_MICR[2]ME_CharString21
5ME_MICR_3 SearchME_MICR[3]ME_CharString21
6ME_MICR_4 SearchME_MICR[4]ME_CharString21
7ME_MICR_5 SearchME_MICR[5]ME_CharString21
8ME_MICR_6 SearchME_MICR[6]ME_CharString21
9ME_MICR_7 SearchME_MICR[7]ME_CharString21
10ME_MICR_8 SearchME_MICR[8]ME_CharString21
11ME_MICR_9 SearchME_MICR[9]ME_CharString21
12ME_MICR_10 SearchME_MICR[10]ME_CharString21
13ME_MICR_11 SearchME_MICR[11]ME_CharString21
14ME_MICR_12 SearchME_MICR[12]ME_CharString21
15ME_MICR_13 SearchME_MICR[13]ME_CharString21
16ME_MICR_14 SearchME_MICR[14]ME_CharString21
17ME_MICR_15 SearchME_MICR[15]ME_CharString21
18ME_MICR_16 SearchME_MICR[16]ME_CharString21
19ME_MICR_17 SearchME_MICR[17]ME_CharString21
20ME_MICR_18 SearchME_MICR[18]ME_CharString21
21ME_MICR_19 SearchME_MICR[19]ME_CharString21
22ME_MICR_20 SearchME_MICR[20]ME_CharString21
23ME_MICR_21 SearchME_MICR[21]ME_CharString21
24ME_MICR_22 SearchME_MICR[22]ME_CharString21
25ME_MICR_23 SearchME_MICR[23]ME_CharString21
26ME_MICR_24 SearchME_MICR[24]ME_CharString21
27ME_MICR_25 SearchME_MICR[25]ME_CharString21
28ME_MICR_26 SearchME_MICR[26]ME_CharString21
29ME_MICR_27 SearchME_MICR[27]ME_CharString21
30ME_MICR_28 SearchME_MICR[28]ME_CharString21
31ME_MICR_29 SearchME_MICR[29]ME_CharString21
32ME_MICR_30 SearchME_MICR[30]ME_CharString21
33ME_MICR_31 SearchME_MICR[31]ME_CharString21
34ME_MICR_32 SearchME_MICR[32]ME_CharString21
35ME_MICR_33 SearchME_MICR[33]ME_CharString21
36ME_MICR_34 SearchME_MICR[34]ME_CharString21
37ME_MICR_35 SearchME_MICR[35]ME_CharString21
38ME_MICR_36 SearchME_MICR[36]ME_CharString21
39ME_MICR_37 SearchME_MICR[37]ME_CharString21
40ME_MICR_38 SearchME_MICR[38]ME_CharString21
41ME_MICR_39 SearchME_MICR[39]ME_CharString21
42ME_MICR_40 SearchME_MICR[40]ME_CharString21
43ME_MICR_41 SearchME_MICR[41]ME_CharString21
44ME_MICR_42 SearchME_MICR[42]ME_CharString21
45ME_MICR_43 SearchME_MICR[43]ME_CharString21
46ME_MICR_44 SearchME_MICR[44]ME_CharString21
47ME_MICR_45 SearchME_MICR[45]ME_CharString21
48CHKFORM SearchME_Check_FormatME_Check_Format_DDLInteger20
49ME_Signature_ID SearchME_Signature_IDSTR15_LBAUString1615
50ME_Logo_ID_Array_1 SearchME_Logo_ID_Array[1]STR15_LBAUString1615
51ME_Logo_ID_Array_2 SearchME_Logo_ID_Array[2]STR15_LBAUString1615
52ME_Logo_ID_Array_3 SearchME_Logo_ID_Array[3]STR15_LBAUString1615
53dupdll SearchME_duplicatesME_Duplicates_DDLInteger20
54numXs SearchME_Number_of_XsINT5Integer24
55resvstr1 SearchME_Transit_NumberSTR25String2625
56checkcomm1 SearchME_CheckComment1STR255String256255
57checkcomm2 SearchME_CheckComment2STR255String256255
58checkcomm3 SearchME_CheckComment3STR255String256255
59ME_Stub_ID SearchME_Stub_IDSTR15_LBUString1615
60ME_Using_Pre_Printed_Che SearchME_Using_Pre_Printed_Check_StockME_Using_Pre_Printed_Check_StockBoolean20
61ME_Check_Digit_Divisor SearchME_Check_Digit_DivisorME_Check_Digit_DivisorInteger21
62ME_Check_Digit_DR_or_DSR SearchME_Check_Digit_DR_or_DSRME_Check_Digit_Calculation_Method_DDLInteger20
63ME_Check_Digit_Use_Zeros SearchME_Check_Digit_Use_ZerosME_Check_Digit_Use_ZerosBoolean20
64ME_Check_Digit_Weighted SearchME_Check_Digit_WeightedME_Check_Digit_WeightedBoolean20
65ME_Check_Digit_Weighting SearchME_Check_Digit_WeightingME_Check_Digit_WeightingLong Integer410

Leave a Reply

Your email address will not be published. Required fields are marked *