ME_Signature_Setup_4 (ME27604)

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

Product: Mekorma MICR (2404)
Series: Purchasing

Display Name: Mekorma MICR Signature Setup
Physical Name: ME27604
Technical Name: ME_Signature_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
1ME_Signature_ID SearchME_Signature_IDSTR15_LBAUString1615
2DSCRIPTN SearchDescriptionSTR30String3230
3ME_Signature_Line1 SearchME_Signature_Line1ME_Signature_DDLInteger20
4ME_Filename2 SearchME_Filename2STR255String256255
5ME_Signature_Line2 SearchME_Signature_Line2ME_Signature_DDLInteger20
6ME_Signature1 SearchME_Signature1ME_Signature_DDLInteger20
7ME_Scaling2 SearchME_Scaling2ME_INT5%Integer25
8ME_Signature2 SearchME_Signature2ME_Signature_DDLInteger20
9ME_CB_Print_Without_Sign SearchME_CB_Print_Without_Signature1CBBoolean20
10ME_CB_Print_Without_Sig2 SearchME_CB_Print_Without_Signature2CBBoolean20
11ME_Ask_Password1 SearchME_Ask_Password1ME_Signature_DDLInteger20
12ME_Ask_Password1 SearchME_Ask_Password1ME_Password_DDLInteger20
13ME_Ask_Password2 SearchME_Ask_Password2ME_Signature_DDLInteger20
14ME_Sort_Blank_Sig_Lines_ SearchME_Sort_Blank_Sig_Lines_to_TopME_sort_blank_sig_CBBoolean20
15ME_Ask_Password2 SearchME_Ask_Password2ME_Password_DDLInteger20
16ME_Filename SearchME_FilenameSTR255String256255
17ME_Signature_Line_Logic SearchME_Signature_Line_LogicME_Signature_DDLInteger20
18ME_Scaling SearchME_ScalingME_INT5%Integer25
19ME_Signature_Threshhold1 SearchME_Signature_Threshhold1DLR17_RBS0_UTR$Currency1017
20ME_Signature_Threshhold2 SearchME_Signature_Threshhold2DLR17_RBS0_UTR$Currency1017
21ME_Signature_Password1 SearchME_Signature_Password1STR10String1210
22ME_Signature_Password2 SearchME_Signature_Password2STR10String1210
23ME_Signature_Queryfile1 SearchME_Signature_Queryfile1ME_Signature_Query_CBBoolean20
24ME_Signature_Queryfile2 SearchME_Signature_Queryfile2ME_Signature_Query_CBBoolean20
25ME_Sort_Checks SearchME_Sort_ChecksME_Sort_ChecksBoolean20
26ME_Password1_Set_By_Whom SearchME_Password1_Set_By_WhomSTR15_User_IDString1615
27ME_Password1_Set_Date SearchME_Password1_Set_DateDATEDate46
28ME_Password2_Set_By_Whom SearchME_Password2_Set_By_WhomSTR15_User_IDString1615
29ME_Password2_Set_Date SearchME_Password2_Set_DateDATEDate46
30ME_FileID1 SearchME_FileID1GUIDStringString3836
31ME_FileID2 SearchME_FileID2GUIDStringString3836
32NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide example SQL

SELECT
       ['Mekorma MICR Signature Setup'].NOTEINDX AS 'Mekorma MICR Signature Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ME27604 AS ['Mekorma MICR Signature Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Mekorma MICR Signature Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX

Leave a Reply

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