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 TypeLength
1CMPANYID SearchCompany IDINT5Integer4
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_VersionINT3Integer3
3ME_Minor_Version SearchME_Minor_VersionINT3Integer3
4ME_Build_Number SearchME_Build_NumberINTInteger0
5ME_Attempted_Date SearchME_Attempted_DateDTDate8
6ME_Attempted_Time SearchME_Attempted_TimeTM6Time6
7ME_Attempted_Build SearchME_Attempted_BuildINTInteger0
8ME_Attempted_Major_Versi SearchME_Attempted_Major_VersionINTInteger0
9ME_Attempted_Minor_Versi SearchME_Attempted_Minor_VersionINTInteger0
10ME_Completed_Date SearchME_Completed_DateDTDate8
11ME_Completed_Time SearchME_Completed_TimeTM6Time6
12USERID SearchUser IDSTR15_User_IDString15
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_DescriptionSTR50String50
azurecurveProductsMekorma MICR (2404)SystemMekorma MICR Upgrade Log (ME27656)

Leave a Reply

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