MMM Logging Detail (MPP71509)

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

Product: Mekorma MICR (2404)
Series: System

Display Name: MMM Logging Detail
Physical Name: MPP71509
Technical Name: MMM_Logging_DTL

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 Detail'].CMPANYID AS 'MMM Logging Detail-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       MPP71509 AS ['MMM Logging Detail']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['MMM Logging Detail'].CMPANYID = ['Company Master'].CMPANYID
2BACHNUMB SearchBatch NumberSTR15_LBAUString1615
3BCHSOURC SearchBatch SourceSTR15String1615
4MPP_Phase SearchMPP_PhaseINTInteger20
5PMNTNMBR SearchPayment NumberSTR20_LBAUString2220
6MMMTransmissionID SearchMMM_Transmission_IDSTR20String2220
7CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['MMM Logging Detail'].CHEKBKID AS 'MMM Logging Detail-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       MPP71509 AS ['MMM Logging Detail']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['MMM Logging Detail'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
8DOCDATE SearchDocument DateDTDate48
9DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
10APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
11CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency1017
12CHEKTOTL SearchCheck TotalDLR19_RBS0_UTR$Currency1019
13VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['MMM Logging Detail'].VENDORID AS 'MMM Logging Detail-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       MPP71509 AS ['MMM Logging Detail']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['MMM Logging Detail'].VENDORID = ['PM Vendor Master File'].VENDORID
14VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
15VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString6664
16SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['MMM Logging Detail'].SOURCDOC AS 'MMM Logging Detail-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       MPP71509 AS ['MMM Logging Detail']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['MMM Logging Detail'].SOURCDOC = ['Source Document Master'].SOURCDOC
17CREATDDT SearchCreated DateDTDate48
18MMMHashCode SearchMMM_HashCodeSTR40String4240

Leave a Reply

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