MMM Logging TEMP (MMMLOG)

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_TEMP

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 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'].CMPANYID
2MMM_Test_Batch SearchMMM_Test_BatchINTInteger20
3BCHSOURC SearchBatch SourceSTR15String1615
4BACHNUMB SearchBatch NumberSTR15_LBAUString1615
5DSCRIPTN SearchDescriptionSTR30String3230
6NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer46
7MPP_Phase SearchMPP_PhaseINTInteger20
8PMNTNMBR SearchPayment NumberSTR20_LBAUString2220
9PmtMethod SearchPayment MethodGBInteger20
10MMMTransmissionID SearchMMM_Transmission_IDSTR20String2220
11CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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'].CHEKBKID
12DOCDATE SearchDocument DateDTDate48
13DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
14APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
15CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency1017
16CHEKTOTL SearchCheck TotalDLR19_RBS0_UTR$Currency1019
17VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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'].VENDORID
18VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
19VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString6664
20SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
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'].SOURCDOC
21CREATDDT SearchCreated DateDTDate48
22MMMHashCode SearchMMM_HashCodeSTR40String4240

Leave a Reply

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