Mekorma MICR Check Audit History (ME240459)

azurecurveProductsMekorma MICR (2404)CompanyMekorma MICR Check Audit History (ME240459)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME240459

Product: Mekorma MICR (2404)
Series: Company

Display Name: Mekorma MICR Check Audit History
Physical Name: ME240459
Technical Name: ME_CheckAudit_HIST

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

Click to show/hide

SELECT
       ['Mekorma MICR Check Audit History'].CHEKBKID AS 'Mekorma MICR Check Audit History-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ME240459 AS ['Mekorma MICR Check Audit History']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Mekorma MICR Check Audit History'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
3BACHNUMB SearchBatch NumberSTR15_LBAUString1615
4USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Mekorma MICR Check Audit History'].USERID AS 'Mekorma MICR Check Audit History-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ME240459 AS ['Mekorma MICR Check Audit History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Mekorma MICR Check Audit History'].USERID = ['Users Master'].USERID
5PMNTNMBR SearchPayment NumberSTR20_LBAUString2220
6DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
7INDXLONG SearchIndexLongLong IntLong Integer48
8MEORIGBACHNUMB SearchME_OrigBatchNumberSTR15_LBAUString1615
9MEBATCHCHECKBOOKID SearchME_BatchCheckbookIDSTR15_Checkbook_IDString1615
10CHKCOUNT SearchCheck CountINT4_U0Integer24
11CHEKAMNT SearchCheck AmountDLR19_RBS0_UTR$Currency1019
12CREATDDT SearchCreated DateDTDate48
13CRUSRID SearchCreated User IDSTR15_User_IDString1615
14POSTEDDT SearchPosted DateDATEDate46
15PTDUSRID SearchPosted User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Mekorma MICR Check Audit History'].PTDUSRID AS 'Mekorma MICR Check Audit History-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ME240459 AS ['Mekorma MICR Check Audit History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Mekorma MICR Check Audit History'].PTDUSRID = ['Users Master'].USERID
16ME_Path SearchME_PathSTR255String256255
17ME_Check_STB_FileNEW SearchME_Check_STB_FileSTR132String134132
18ME_Check_STB_Version SearchME_Check_STB_VersionINTInteger20
19ME_Overflow_STB_FileNEW SearchME_Overflow_STB_FileSTR132String134132
20ME_Overflow_STB_Version SearchME_Overflow_STB_VersionINTInteger20
21ME_Refund_Checks_STB_Fil SearchME_Refund_Checks_STB_FileSTR132String134132
22MEREFSTBVER SearchME_Refund_Checks_STB_VersionINTInteger20
23ME_Refund_Checks_Overflo SearchME_Refund_Checks_Overflow_STB_FileSTR132String134132
24MEREFOVERSION SearchME_Refund_Checks_Overflow_STB_VersionINTInteger20
25ME_Copy_STB_File SearchME_Copy_STB_FileSTR132String134132
26ME_Copy_STB_Version SearchME_Copy_STB_VersionINTInteger20
27ME_Copy_Overflow_STB_Fil SearchME_Copy_Overflow_STB_FileSTR132String134132
28ME_Copy_Overflow_STB_Ver SearchME_Copy_Overflow_STB_VersionINTInteger20
29BACHDATE SearchBatch DateDTDate48
30TIME1 SearchTimeTM6Time46
31MEUSERID1 SearchME_UserID1User_IDString1615
32MEUSERID2 SearchME_UserID2User_IDString1615
33CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Mekorma MICR Check Audit History'].CURNCYID AS 'Mekorma MICR Check Audit History-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ME240459 AS ['Mekorma MICR Check Audit History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Mekorma MICR Check Audit History'].CURNCYID = ['Currency Setup'].CURNCYID
34CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Mekorma MICR Check Audit History'].CURRNIDX AS 'Mekorma MICR Check Audit History-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ME240459 AS ['Mekorma MICR Check Audit History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Mekorma MICR Check Audit History'].CURRNIDX = ['Currency Setup'].CURRNIDX
35MEATTCHIDS_1 SearchME_AttachmentIDs[1]GUIDStringString3836
36MEATTCHIDS_2 SearchME_AttachmentIDs[2]GUIDStringString3836
37MEATTCHIDS_3 SearchME_AttachmentIDs[3]GUIDStringString3836
38MEATTCHIDS_4 SearchME_AttachmentIDs[4]GUIDStringString3836
39MEATTCHIDS_5 SearchME_AttachmentIDs[5]GUIDStringString3836
40MEATTCHIDS_6 SearchME_AttachmentIDs[6]GUIDStringString3836
azurecurveProductsMekorma MICR (2404)CompanyMekorma MICR Check Audit History (ME240459)

Leave a Reply

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