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 TypeLength
1Queue_ID SearchQueue IDINT2Integer2
2CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
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_LBAUString15
4USERID SearchUser IDSTR15_User_IDString15
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_LBAUString20
6DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
7INDXLONG SearchIndexLongLong IntLong Integer8
8MEORIGBACHNUMB SearchME_OrigBatchNumberSTR15_LBAUString15
9MEBATCHCHECKBOOKID SearchME_BatchCheckbookIDSTR15_Checkbook_IDString15
10CHKCOUNT SearchCheck CountINT4_U0Integer4
11CHEKAMNT SearchCheck AmountDLR19_RBS0_UTR$Currency19
12CREATDDT SearchCreated DateDTDate8
13CRUSRID SearchCreated User IDSTR15_User_IDString15
14POSTEDDT SearchPosted DateDATEDate6
15PTDUSRID SearchPosted User IDSTR15String15
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_PathSTR255String255
17ME_Check_STB_FileNEW SearchME_Check_STB_FileSTR132String132
18ME_Check_STB_Version SearchME_Check_STB_VersionINTInteger0
19ME_Overflow_STB_FileNEW SearchME_Overflow_STB_FileSTR132String132
20ME_Overflow_STB_Version SearchME_Overflow_STB_VersionINTInteger0
21ME_Refund_Checks_STB_Fil SearchME_Refund_Checks_STB_FileSTR132String132
22MEREFSTBVER SearchME_Refund_Checks_STB_VersionINTInteger0
23ME_Refund_Checks_Overflo SearchME_Refund_Checks_Overflow_STB_FileSTR132String132
24MEREFOVERSION SearchME_Refund_Checks_Overflow_STB_VersionINTInteger0
25ME_Copy_STB_File SearchME_Copy_STB_FileSTR132String132
26ME_Copy_STB_Version SearchME_Copy_STB_VersionINTInteger0
27ME_Copy_Overflow_STB_Fil SearchME_Copy_Overflow_STB_FileSTR132String132
28ME_Copy_Overflow_STB_Ver SearchME_Copy_Overflow_STB_VersionINTInteger0
29BACHDATE SearchBatch DateDTDate8
30TIME1 SearchTimeTM6Time6
31MEUSERID1 SearchME_UserID1User_IDString15
32MEUSERID2 SearchME_UserID2User_IDString15
33CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 IndexINT3Integer3
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]GUIDStringString36
36MEATTCHIDS_2 SearchME_AttachmentIDs[2]GUIDStringString36
37MEATTCHIDS_3 SearchME_AttachmentIDs[3]GUIDStringString36
38MEATTCHIDS_4 SearchME_AttachmentIDs[4]GUIDStringString36
39MEATTCHIDS_5 SearchME_AttachmentIDs[5]GUIDStringString36
40MEATTCHIDS_6 SearchME_AttachmentIDs[6]GUIDStringString36
azurecurveProductsMekorma MICR (2404)CompanyMekorma MICR Check Audit History (ME240459)

Leave a Reply

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