Matching – Lawson MA tables and programs

Matching (MA) in Lawson S3 v10 MSP6 has 37 tables, 106 online screens and 20 batch programs.

Tables (37)

TablePrefixDescriptionPrimary keyFields
MAAOCDTLMAAInvoice Add On Cost DetailCOMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR70
MAAOIHISTMH2No description in the Lawson data dictionaryCOMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, VENDOR, INVOICE, SUFFIX11
MACAPDTLMDAInvoice Distrib ConversionCOMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ-NBR54
MACINVAOCMAONo description in the Lawson data dictionaryCOMPANY, VENDOR, EDI-NBR, INVOICE, SEQ-NBR, AOC-CODE47
MACINVDTLMOPInvoice Conversion/InterfaceCOMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, SEQ-NBR48
MACINVERRMCIInv Interface/Conversion ErrorCOMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ, RECORD-TYPE, SEQ-NBR9
MACINVOICEMAIInvoice Conversion/InterfaceCOMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX99
MACOAUDMCTMatching Company AuditCOMPANY, ACTION, DATE, TIME, UNIQUE-I-D12
MACOMPANYMAYMatching CompanyCOMPANY85
MACRECADJMRJReceipt AdjustmentCOMPANY, REC-REF-NBR, DOC-TYPE, LINE-NBR64
MACRECAOCMRAMA Record Add on CostCOMPANY, REFERENCE-NO, LINE-NBR, AOC-CODE, SEQ-NBR44
MACRECERRMREMA Record ErrorCOMPANY, REFERENCE-NO, ERROR-TYPE, LINE-NBR, SEQ-NBR18
MACRECHDRMRHMA Record HeaderCOMPANY, REFERENCE-NO, SEQ-NBR42
MACRECLINEMRLMA Record LineCOMPANY, REFERENCE-NO, LINE-NBR, SEQ-NBR55
MACRECPOTMRPMA Receipt TransactionCOMPANY, REFERENCE-NO, LINE-NBR, SEQ15
MADICTMDCNo description in the Lawson data dictionaryDB-FILE-PFX, FIELD-NBR5
MAELMGPRELMGRMatch Element Group RelationMATCH-CLASS, RELATION, SEQ-TRNS-NBR13
MAELMGROUPMGPMatching Element GroupELEMENT-GROUP2
MAELMVALUEMVAMatching Element ValueELEMENT, ELEMENT-VALUE4
MAFRXREFMFXNo description in the Lawson data dictionaryDIST-COMPANY, DIS-ACCT-UNIT, DIS-ACCOUNT, DIS-SUB-ACCT4
MAINVDTLMADInvoice Line DetailCOMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, SEQ-NBR87
MAINVHANDMAHInvoice Handling CodeHANDLING-CODE18
MAINVMSGMAGInvoice and PO Cost MessageCOMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, MAD-SEQ-NBR, SEQ-NBR36
MAINVREFMRFNo description in the Lawson data dictionaryCOMPANY, VENDOR, API-INVOICE, API-SUFFIX, API-CANCEL-SEQ, REF-INV-NBR, REF-SUFFIX, REF-CANCEL-SEQ8
MAMAAHISTMMHNo description in the Lawson data dictionaryCOMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR68
MAMADHISTMH1No description in the Lawson data dictionaryCOMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR77
MAMATCHTBLMAMMatch TableMATCH-TABLE7
MAMSGTOLMGTNo description in the Lawson data dictionaryMATCH-RULE31
MAMTCHELEMMAEMatching ElementsELEMENT7
MAMTCHRULEMAUMatching RulesMATCH-RULE38
MAMTTAUDMTTMatch Table AuditMATCH-TABLE, ACTION, DATE, TIME, UNIQUE-I-D12
MAPOINVAOIMultiple PO InvoiceCOMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, VENDOR, INVOICE, SUFFIX11
MAREASONCDMARMatching Reason CodeREASON-CODE2
MARULAUDMRUMatching Rules AuditMATCH-RULE, ACTION, DATE, TIME, UNIQUE-I-D12
MATCHCLASSMALMatch ClassMATCH-CLASS7
MAWORKQWRQNo description in the Lawson data dictionaryID, VENDOR-SNAME, VENDOR, COMPANY, INVOICE, SUFFIX, CANCEL-SEQ20
PROCLEVMAZMatching Process LevelCOMPANY, PROC-LEVEL30

Online screens (106)

ScreenDescriptionUpdatesReferences
MA00.1Match Table56
MA00.2Match Elements10
MA00.3Match Class20
MA00.4Match Rule Groups63
MA00.5Element Value12
MA00.6Element Group10
MA00.7Element Group Relation12
MA01.1Company816
MA01.2Financial Reporting Account Setup24
MA05.1Handling Code27
MA05.2Vendor Handling Code03
MA05.3Company Handling Code16
MA05.4Process Level Handling Code02
MA05.5Reason Code10
MA05.6Multiple Handling Code26
MA08.1Add On Charge/Allowance710
MA26.1PO Invoice Match1139
MA41.1Add-On Cost Detail - Purchase Order227243
MA41.2Add On Cost Lookup227243
MA41.4Miscellaneous Add-On Cost227243
MA41.7AOC Approval Entry227243
MA42.1Memo Line Detail - Purchase Order91111
MA42.2Memo Line AOC Detail227243
MA43.1Invoice Line Detail - Purchase Order97114
MA43.2Purchase Order Lookup227243
MA43.3Invoice Line Detail - Receipt93111
MA43.4Invoice Line Detail - Service91105
MA43.6Service Agreement Detail91107
MA43.7GL Distribution177185
MA44.1Invoice Line Detail - Purchase Order227244
MA44.2Invoice Line Detail- Service227244
MA53.1Receipt Interface182184
MA53.2Receipt Adjustment Interface38
MA53.3Receipt Interface Errors04
MA53.4Receipt Interface Errors Filter02
MA53.5Additional Receiving Entry15
MA53.6Add-on Charge Line Details25
MA53.7Additional Receiving Adjustment Entry15
MA54.1Invoice622
MA54.2Distribution216
MA54.3Invoice Line Detail17
MA54.7Add-on Charge Line Details25
MA54.8Invoice Errors05
MA54.9Invoice Errors Filter04
MA60.1Reconciliation Queue110
MA60.2Invoice Level Match176191
MA60.3Detail Level Match175195
MA60.4Invoice Match Reference Adjustment526
MA60.5Receipt Match Reference Adjustment177183
MA60.7Chargeback Header Selection12
MA61.1Match Invoice Approval212232
MA62.6Item Detail04
MA62.7Chargeback Detail Selection02
MA63.1Invoice Line Match89100
MA63.2Chargeback12
MA64.1Message Queue - Vendor08
MA64.2Message Queue - PO07
MA64.3Message Queue - Item07
MA64.4Invoice Messaging Queue05
MA64.5Selection Criteria04
MA64.6Message Detail by Invoice234
MA64.8Workflow Message Queue - Invoice02
MA64.9PO Cost Message Accept Upload941
MA65.1Invoice Line Adjustment94134
MA66.1Review Invoice Message137
MA66.2Invoice Message - Details182191
MA66.3Purchase Order Cost Review Message1244
MA66.8Chargeback Details011
MA67.1Vendor inquiry frontend27
MA67.2Invoice Match from frontend178184
MA67.3Detail Match from frontend176195
MA67.4AOC Match from frontend07
MA68.1Reconciliation Queue - Prepaids19
MA68.2Invoice Level Match - Prepaid176190
MA68.3Detail Level Match - Prepaid177184
MA68.4Invoice Match Reference Adjustment526
MA68.5Receipt Match Reference Adjustment177183
MA68.7Chargeback12
MA69.1AOC Level Detail Match88101
MA69.2AOC Level Selections114
MA69.3Invoice-Invoice Level Totals Display04
MA69.4Receipts-Invoice Level Totals Display04
MA69.5Invoice-Detail Level Totals Display04
MA69.6Receipt-Detail Level Totals Display04
MA69.7Chargeback12
MA70.1Invoice Unmatch201195
MA75.1PO Invoice Cancel201195
MA80.1Receipt Archive177183
MA89.1Company Audit02
MA89.2Match Table Audit02
MA89.3MA Rule Group Audit02
MA90.1Match Analysis013
MA90.2All Transactions for Invoice419
MA90.3Match Analysis Details419
MA90.4Ready to Archive Receipts05
MA90.5Misc AOC for an Invoice418
MA90.6Summarization417
MA91.1Match Pool Display012
MA95.1Vendor History05
MA95.2Vendor History Analysis05
MAED.1Vendor541
MAHA.1Match Handling Code Edit01
MAI1.1Invoke for MAMATCH Object211235
MAPC.1Match PO Code Edit01
MAPL.1Process Level Setup22
MARC.1Match Reason Code Edit01

Batch programs (20)

ProgramDescriptionUpdatesReferences
MA126Auto Matching9096
MA167Smart Recon queue Build44
MA168Prepaid Invoice Not Received49
MA180Open Receipt Archive178185
MA189MA Audit Analysis Report44
MA200Company Listing14
MA205Code Listing215
MA208Add on Charge/Allowance Listing612
MA231Unmatched Receipt Listing212
MA236Invoiced, Not Received Report116
MA237Match Update Report212
MA264Invoice Message Listing19
MA278Cost Variance Analysis178186
MA279Invoice AOC Detail Report2956
MA310Pool Count Rebuild39
MA530ERS Invoice Creation179185
MA531Receipt Interface186182
MA540Invoice Interface47102
MA730PORECLINE OTM REBUILD47
MA999802 Company Update30

Other tables used by Matching programs (444)

ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACAMCODE, ACBILL, ACBILLX, ACBRDNTRAN, ACBUDHDR, ACCAL, ACCALX, ACCATGRP, ACCATGRPX, ACCATSUM, ACCATSUMX, ACCNTRACT, ACCOMMIT, ACCOMMITX, ACCONSOL, ACDETAIL, ACDETAILAU, ACHEADER, ACHEADERAU, ACIFACTV, ACPRDPERF, ACTRANS, ADDRDATA, AMACCOUNT, AMACCTAU, AMACCTGPAU, AMACCTGRP, AMASSET, AMASSETADJ, AMASSETBOD, AMASSETDSP, AMASSETGRP, AMASSETTRF, AMASTBKADJ, AMASTBKDSP, AMASTBKTRF, AMASTBOOK, AMASTITADJ, AMASTITDSP, AMASTITEM, AMASTITTRF, AMASTMXVAL, AMASTRECAP, AMASTRPAIR, AMASTTYPAU, AMASTTYPE, AMAUGROUP, AMAUGRPAU, AMBKHIST, AMBKHISTX, AMBKTEMPLT, AMBKTRANS, AMBOOK, AMCALENDAR, AMCLASSDEP, AMCNTRLAU, AMCOMPUTE, AMCONTROL, AMCTLTRANS, AMDICT2, AMDIVISION, AMDIVISNAU, AMINTER, AMINTERAU, AMLOCATION, AMLOCAUDIT, AMLOCDTL, AMMETHOD, AMMONITOR, AMPOASTDTL, AMPOASTHDR, AMPODFLTS, AMPUCODE, AMPUHIS, AMRPRINTER, AMSEGBLOCK, AMSYSOPTAU, AMTABLEPCT, AMTABLETAX, AMTAXAUTH, AMTEMPLATE, AMTRANS, AMTRANSBOD, AMTRANSUMM, AMTYPALLOC, AMTYPALLOX, AMUOPPDS, APACCRCODE, APAPIHIST, APAPPROVAL, APASTDTL, APAUDIT, APAUTHBUY, APAUTHOR, APBATCH, APCOMMENTS, APCOMPANY, APCONTACT, APCPYVND, APDICT2, APDISCACC, APDISCCODE, APDISTCODE, APDISTHDR, APDISTPAY, APDISTRIB, APDIVCODE, APDRAFTS, APDRFTCDES, APDRFTDIST, APDSUSRFLD, APEXPINV, APHLDINV, APHOLDCODE, APINCCODE, APINUSRFLD, APINVOICE, APMONITOR, APPAYGROUP, APPAYMENT, APPMTBOD, APPOVNXREF, APPRCLVAUD, APPROCGRP, APPROCLEV, APUAVAL, APUDISTCD, APUSRFLDEF, APVENADDR, APVENBAL, APVENCERT, APVENCLASS, APVENDIV, APVENGROUP, APVENLCBOD, APVENLOC, APVENMAST, APVENPAY, APVNMXVAL, APWTHCODE, ARCOMP, ARCUSTGRP, ARCUSTOMER, AUMXVALUAU, AUMXVLDTAU, BILLTO, BUYBOD, BUYCLASS, BUYCMPLOC, BUYER, BUYERGRP, BUYVENPF, C3BODRET, C3TAXRET, CAALLOCGRP, CAALOCGPAU, CADETAIL, CADETAILAU, CAHEADER, CAHEADERAU, CBBANKENT, CBBANKINST, CBCASHCODE, CBCASHFORM, CBCCTRNJB, CBCHECK, CBCPYCASH, CBDRFTFORM, CBPAYMENT, CBPMTCAT, CBRECPTHDR, CBTRANS, CBTRANSBOD, CBUSER, CBUSRCLASS, COCOMP, COLINE, COMMCODES, COMPONENT, COSGBLK, CUACCT, CUACCTAU, CUCODES, CUCODESAU, CUCONV, CUCONVAU, CURELAT, CURELATAU, CUSTDESC, CUSTORDER, CUTABLE, CUTABLEAU, CUTRANSL, CUTRNSLAU, CXBURDEN, CXCASEPREF, CXCOMPANY, CXCPIUAVAL, CXITEMHIST, CXPREFITEM, CXPTMPITEM, EEADVANCE, EEAPPROVAL, EEEXPENSE, FBADJCODAU, FBCNTRLAU, FBDETAIL, FBDETAILAU, FBFNDHDRAU, FBFUNDAMT, FBFUNDDTL, FBHEADER, FBHEADERAU, FBHSTHDRAU, FBINTBUAU, FBSPREADAU, FBTRANS, FBTRANSAU, FBYETR, FOBCODE, GLACCTVLD, GLACMXVLAU, GLADDRESS, GLAMOUNTS, GLAUTMXVAU, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCHTDTLAU, GLCNTRLAU, GLCODES, GLCOMMIT, GLCOMMITX, GLCONTROL, GLCPYGRP, GLHISCOMBL, GLHISCOMX, GLINTCO, GLMASTER, GLMASTERAU, GLNAMES, GLNAMESAU, GLNLOCDTL, GLSRCCODE, GLSYSTEM, GLSYSTEMAU, GLTRANS, GLZONE, GMFNDACT, GTMXVALUAU, HCCHRGITEM, HCHPPAUDIT, HCPATCHRG, HCPATPROC, HCPATVISIT, ICBIN, ICCATEGORY, ICCOMPANY, ICCOUT, ICFACILITY, ICHISTORY, ICICRAUDIT, ICITEMCODE, ICITEMGTIN, ICITLLBL, ICLOCATION, ICLOT, ICMANFCODE, ICMFGCODE, ICMFGDIST, ICRECEIPTS, ICTRANS, ICTRANSDTL, ICVALUOM, IFBCIQUEUE, IFDICT, INDOCTPCD, INFERCONCD, INLINETYPE, INSTATPROC, INSTCMDTY, INSTCTRYCD, INSTDETAIL, INSTHEADER, INSTNBR, INSTNOTC, INSTPORTS, INSTREGN, ITEMGROUP, ITEMLOC, ITEMMAST, ITEMSPECL, ITEMSUB, ITSERIAL, JBKACCT, JBKOPCODE, JBKSEQNBR, JBKSYSCODE, JBOOKHDR, KITITEM, KWDDETAIL, KWDMASTER, KWDSETUP, KWDSYNONYM, LMLEASE, LMLEASESEG, MFGSHPFAC, MLCOLEDGER, MMDIST, MMUAVAL, MXCATDEF, MXCATDEFAU, MXELEMENT, MXELEMNTAU, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXLSTDTLAU, MXLSTHDRAU, MXOBJCAT, MXOBJCATAU, MXTMPDTLAU, MXTMPHDRAU, MXTPEFDTAU, MXTPHEDTAU, MXVALIDAU, MXVEWDTLAU, MXVEWHDRAU, NATACCT, NATBALANCE, OECOMPANY, OECUST, OEFRTCODE, OEROUTE, ORDERTYPE, PDCARD, PDCCHRGERR, PDPROGRAM, PJLBOD, POAGMAUDIT, POAGMTPART, POAGMTPRIC, POAOCDTL, POAOCMAST, POAOCSPRD, POAPPCODE, POAPPROVE, POAUDIT, POAUDRULES, POAUDTYPE, POCODE, POCOMPANY, POCONTGRP, POCONTRACT, POCONTREB, PODOCREF, POHDROUT, POHDRPVT, POINTAOC, POINTAUDIT, POINTERFAC, POITEMVEN, POIVACMNT, POLINE, POLINEOUT, POLINEPVT, POLINESRC, POMATCHOBJ, POMESSAGE, POMXVAL, POPCRUF, POPLIUF, POPOVUF, POPSPHIST, POREBDIST, POREBDUE, POREBRECD, PORECADJHD, PORECADJLN, PORECEIVE, PORECLINE, PORETURNHD, PORETURNLN, POREVISION, PORLNUF, PORQHUF, POTRACK, POTRANSDTL, POVACOMMIT, POVACOMMIX, POVADIST, POVAGLNERR, POVAGRMTHD, POVAGRMTLN, POVAPARTLN, POVENDLOC, POVENDOR, PROCTEMPLN, PROCUREGRP, PTHBOD, PURCHORDER, PVHBOD, REASON, RECAOCDTL, REQHEADER, REQLINE, REQUESTER, RJBRIDGE, RJCNTRLAU, RJCONTROL, RJMXVALUAU, RJSCHEDULE, ROUTEDOC, ROUTEHDR, ROUTESTOP, RQAUDIT, RQLOC, RQTRANS, SOHDETAIL, STATICCUST, STCOMMCODE, SUBCKPOINT, SYSTEMCODE, TERMS, TXCODEMAST, TXCOMPANY, TXTAXCODE, TXTAXRATE, TXTAXTABLE, TXTAXTRAN, TXUSAGECD, VBABOD, WFSETUP, WHDEMAND, WHDEMNDHDR, WHPROCTYPE, WHSHIPLINE, WHSHIPMENT, WHSHLAUD