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_DTLSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMPANYID 
Company ID INT5 Integer 4 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'].CMPANYID2 BACHNUMB Batch Number STR15_LBAU String 15 3 BCHSOURC Batch Source STR15 String 15 4 MPP_Phase MPP_Phase INT Integer 0 5 PMNTNMBR Payment Number STR20_LBAU String 20 6 MMMTransmissionID MMM_Transmission_ID STR20 String 20 7 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 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'].CHEKBKID8 DOCDATE Document Date DT Date 8 9 DOCNUMBR Document Number STR20_Document_Number String 20 10 APPLDAMT Applied Amount DLR17_RBS0_STR$ Currency 17 11 CURTRXAM Current Trx Amount DLR17_RBS0_UTR$ Currency 17 12 CHEKTOTL Check Total DLR19_RBS0_UTR$ Currency 19 13 VENDORID Vendor ID STR_15_Vendor_ID String 15 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'].VENDORID14 VENDNAME Vendor Name STR64_Vendor_Name String 64 15 VNDCHKNM Vendor Check Name STR64_Vendor_Name String 64 16 SOURCDOC Source Document STR10_Source_Document String 10 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'].SOURCDOC17 CREATDDT Created Date DT Date 8 18 MMMHashCode MMM_HashCode STR40 String 40