Mekorma MICR Upgrade Log (ME27656)

azurecurveProductsMekorma MICR (2404)SystemMekorma MICR Upgrade Log (ME27656)

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

Product: Mekorma MICR (2404)
Series: System

Display Name: Mekorma MICR Upgrade Log
Physical Name: ME27656
Technical Name: ME_Upgrade_Log

Group Display Name: ME_Mekorma_MICR_System_Tables
Group Technical Name: ME_Mekorma_MICR_System_Tables

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CMPANYID SearchCompany IDINT5Integer24
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Mekorma MICR Upgrade Log'].CMPANYID AS 'Mekorma MICR Upgrade Log-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       ME27656 AS ['Mekorma MICR Upgrade Log']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Mekorma MICR Upgrade Log'].CMPANYID = ['Company Master'].CMPANYID
2ME_Major_Version SearchME_Major_VersionINT3Integer23
3ME_Minor_Version SearchME_Minor_VersionINT3Integer23
4ME_Build_Number SearchME_Build_NumberINTInteger20
5ME_Attempted_Date SearchME_Attempted_DateDTDate48
6ME_Attempted_Time SearchME_Attempted_TimeTM6Time46
7ME_Attempted_Build SearchME_Attempted_BuildINTInteger20
8ME_Attempted_Major_Versi SearchME_Attempted_Major_VersionINTInteger20
9ME_Attempted_Minor_Versi SearchME_Attempted_Minor_VersionINTInteger20
10ME_Completed_Date SearchME_Completed_DateDTDate48
11ME_Completed_Time SearchME_Completed_TimeTM6Time46
12USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Mekorma MICR Upgrade Log'].USERID AS 'Mekorma MICR Upgrade Log-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ME27656 AS ['Mekorma MICR Upgrade Log']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Mekorma MICR Upgrade Log'].USERID = ['Users Master'].USERID
13ME_Status_Description SearchME_Status_DescriptionSTR50String5250
azurecurveProductsMekorma MICR (2404)SystemMekorma MICR Upgrade Log (ME27656)

Leave a Reply

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