Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MMMLOG
Product: Mekorma MICR (2404)
Series: System
Display Name: MMM Logging TEMP
Physical Name: MMMLOG
Technical Name: MMM_Logging_TEMPSeq 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 TEMP'].CMPANYID AS 'MMM Logging TEMP-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
MMMLOG AS ['MMM Logging TEMP']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MMM Logging TEMP'].CMPANYID = ['Company Master'].CMPANYID2 MMM_Test_Batch MMM_Test_Batch INT Integer 0 3 BCHSOURC Batch Source STR15 String 15 4 BACHNUMB Batch Number STR15_LBAU String 15 5 DSCRIPTN Description STR30 String 30 6 NUMOFTRX Number Of TRX LI6_U0 Long Integer 6 7 MPP_Phase MPP_Phase INT Integer 0 8 PMNTNMBR Payment Number STR20_LBAU String 20 9 PmtMethod Payment Method GB Integer 0 10 MMMTransmissionID MMM_Transmission_ID STR20 String 20 11 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['MMM Logging TEMP'].CHEKBKID AS 'MMM Logging TEMP-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
MMMLOG AS ['MMM Logging TEMP']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['MMM Logging TEMP'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID12 DOCDATE Document Date DT Date 8 13 DOCNUMBR Document Number STR20_Document_Number String 20 14 APPLDAMT Applied Amount DLR17_RBS0_STR$ Currency 17 15 CURTRXAM Current Trx Amount DLR17_RBS0_UTR$ Currency 17 16 CHEKTOTL Check Total DLR19_RBS0_UTR$ Currency 19 17 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['MMM Logging TEMP'].VENDORID AS 'MMM Logging TEMP-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
MMMLOG AS ['MMM Logging TEMP']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['MMM Logging TEMP'].VENDORID = ['PM Vendor Master File'].VENDORID18 VENDNAME Vendor Name STR64_Vendor_Name String 64 19 VNDCHKNM Vendor Check Name STR64_Vendor_Name String 64 20 SOURCDOC Source Document STR10_Source_Document String 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['MMM Logging TEMP'].SOURCDOC AS 'MMM Logging TEMP-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
MMMLOG AS ['MMM Logging TEMP']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['MMM Logging TEMP'].SOURCDOC = ['Source Document Master'].SOURCDOC21 CREATDDT Created Date DT Date 8 22 MMMHashCode MMM_HashCode STR40 String 40