MMM Logging Master (MPP71508)

azurecurveProductsMekorma MICR (2404)SystemMMM Logging Master (MPP71508)

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

Product: Mekorma MICR (2404)
Series: System

Display Name: MMM Logging Master
Physical Name: MPP71508
Technical Name: MMM_Logging_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CMPANYID SearchCompany IDINT5Integer4
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['MMM Logging Master'].CMPANYID AS 'MMM Logging Master-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       MPP71508 AS ['MMM Logging Master']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['MMM Logging Master'].CMPANYID = ['Company Master'].CMPANYID
2BCHSOURC SearchBatch SourceSTR15String15
3BACHNUMB SearchBatch NumberSTR15_LBAUString15
4MPP_Phase SearchMPP_PhaseINTInteger0
5PmtMethod SearchPayment MethodGBInteger0
6MMM_Built SearchMMM_BuiltINTInteger0
7MMM_Edited_Check_Batch SearchMMM_Edited_Check_BatchINTInteger0
8DSCRIPTN SearchDescriptionSTR30String30
9MMMHashCode SearchMMM_HashCodeSTR40String40
10MMM_Printed_Edit_List SearchMMM_Printed_Edit_ListINTInteger0
11MMMTransmissionID SearchMMM_Transmission_IDSTR20String20
12MMM_Requested_Approval SearchMMM_Requested_ApprovalINTInteger0
13MMM_Approved SearchMMM_ApprovedINTInteger0
14MMM_Transmission_Date SearchMMM_Transmission_DateDATEDate6
15MMM_Printed SearchMMM_PrintedINTInteger0
16MMM_Transmission_Time SearchMMM_Transmission_TimeTM6Time6
17MMM_Test_Batch SearchMMM_Test_BatchINTInteger0
18MMM_Posted SearchMMM_PostedINTInteger0
19CREATDDT SearchCreated DateDTDate8
20CREATETIME SearchCreated TimeTM6Time6
21USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['MMM Logging Master'].USERID AS 'MMM Logging Master-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       MPP71508 AS ['MMM Logging Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['MMM Logging Master'].USERID = ['Users Master'].USERID
22NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer6
23CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['MMM Logging Master'].CHEKBKID AS 'MMM Logging Master-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       MPP71508 AS ['MMM Logging Master']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['MMM Logging Master'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
24SRCECODE SearchSource CodeSTR6String6
25MMM_LogSecurityCode SearchMMM_LogSecurityCodeSTR50String50
26RECRDID SearchRecord IDSTR40String40
azurecurveProductsMekorma MICR (2404)SystemMMM Logging Master (MPP71508)

Leave a Reply

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