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 TypeSQL DB LengthKeyable Length
1CMPANYID SearchCompany IDINT5Integer24
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 SourceSTR15String1615
3BACHNUMB SearchBatch NumberSTR15_LBAUString1615
4MPP_Phase SearchMPP_PhaseINTInteger20
5PmtMethod SearchPayment MethodGBInteger20
6MMM_Built SearchMMM_BuiltINTInteger20
7MMM_Edited_Check_Batch SearchMMM_Edited_Check_BatchINTInteger20
8DSCRIPTN SearchDescriptionSTR30String3230
9MMMHashCode SearchMMM_HashCodeSTR40String4240
10MMM_Printed_Edit_List SearchMMM_Printed_Edit_ListINTInteger20
11MMMTransmissionID SearchMMM_Transmission_IDSTR20String2220
12MMM_Requested_Approval SearchMMM_Requested_ApprovalINTInteger20
13MMM_Approved SearchMMM_ApprovedINTInteger20
14MMM_Transmission_Date SearchMMM_Transmission_DateDATEDate46
15MMM_Printed SearchMMM_PrintedINTInteger20
16MMM_Transmission_Time SearchMMM_Transmission_TimeTM6Time46
17MMM_Test_Batch SearchMMM_Test_BatchINTInteger20
18MMM_Posted SearchMMM_PostedINTInteger20
19CREATDDT SearchCreated DateDTDate48
20CREATETIME SearchCreated TimeTM6Time46
21USERID SearchUser IDSTR15_User_IDString1615
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 Integer46
23CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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 CodeSTR6String86
25MMM_LogSecurityCode SearchMMM_LogSecurityCodeSTR50String5250
26RECRDID SearchRecord IDSTR40String4240
azurecurveProductsMekorma MICR (2404)SystemMMM Logging Master (MPP71508)

Leave a Reply

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