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)
| Table | Prefix | Description | Primary key | Fields |
|---|
| MAAOCDTL | MAA | Invoice Add On Cost Detail | COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR | 70 |
| MAAOIHIST | MH2 | No description in the Lawson data dictionary | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, VENDOR, INVOICE, SUFFIX | 11 |
| MACAPDTL | MDA | Invoice Distrib Conversion | COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ-NBR | 54 |
| MACINVAOC | MAO | No description in the Lawson data dictionary | COMPANY, VENDOR, EDI-NBR, INVOICE, SEQ-NBR, AOC-CODE | 47 |
| MACINVDTL | MOP | Invoice Conversion/Interface | COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, SEQ-NBR | 48 |
| MACINVERR | MCI | Inv Interface/Conversion Error | COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ, RECORD-TYPE, SEQ-NBR | 9 |
| MACINVOICE | MAI | Invoice Conversion/Interface | COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX | 99 |
| MACOAUD | MCT | Matching Company Audit | COMPANY, ACTION, DATE, TIME, UNIQUE-I-D | 12 |
| MACOMPANY | MAY | Matching Company | COMPANY | 85 |
| MACRECADJ | MRJ | Receipt Adjustment | COMPANY, REC-REF-NBR, DOC-TYPE, LINE-NBR | 64 |
| MACRECAOC | MRA | MA Record Add on Cost | COMPANY, REFERENCE-NO, LINE-NBR, AOC-CODE, SEQ-NBR | 44 |
| MACRECERR | MRE | MA Record Error | COMPANY, REFERENCE-NO, ERROR-TYPE, LINE-NBR, SEQ-NBR | 18 |
| MACRECHDR | MRH | MA Record Header | COMPANY, REFERENCE-NO, SEQ-NBR | 42 |
| MACRECLINE | MRL | MA Record Line | COMPANY, REFERENCE-NO, LINE-NBR, SEQ-NBR | 55 |
| MACRECPOT | MRP | MA Receipt Transaction | COMPANY, REFERENCE-NO, LINE-NBR, SEQ | 15 |
| MADICT | MDC | No description in the Lawson data dictionary | DB-FILE-PFX, FIELD-NBR | 5 |
| MAELMGPREL | MGR | Match Element Group Relation | MATCH-CLASS, RELATION, SEQ-TRNS-NBR | 13 |
| MAELMGROUP | MGP | Matching Element Group | ELEMENT-GROUP | 2 |
| MAELMVALUE | MVA | Matching Element Value | ELEMENT, ELEMENT-VALUE | 4 |
| MAFRXREF | MFX | No description in the Lawson data dictionary | DIST-COMPANY, DIS-ACCT-UNIT, DIS-ACCOUNT, DIS-SUB-ACCT | 4 |
| MAINVDTL | MAD | Invoice Line Detail | COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, SEQ-NBR | 87 |
| MAINVHAND | MAH | Invoice Handling Code | HANDLING-CODE | 18 |
| MAINVMSG | MAG | Invoice and PO Cost Message | COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, MAD-SEQ-NBR, SEQ-NBR | 36 |
| MAINVREF | MRF | No description in the Lawson data dictionary | COMPANY, VENDOR, API-INVOICE, API-SUFFIX, API-CANCEL-SEQ, REF-INV-NBR, REF-SUFFIX, REF-CANCEL-SEQ | 8 |
| MAMAAHIST | MMH | No description in the Lawson data dictionary | COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR | 68 |
| MAMADHIST | MH1 | No description in the Lawson data dictionary | COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR | 77 |
| MAMATCHTBL | MAM | Match Table | MATCH-TABLE | 7 |
| MAMSGTOL | MGT | No description in the Lawson data dictionary | MATCH-RULE | 31 |
| MAMTCHELEM | MAE | Matching Elements | ELEMENT | 7 |
| MAMTCHRULE | MAU | Matching Rules | MATCH-RULE | 38 |
| MAMTTAUD | MTT | Match Table Audit | MATCH-TABLE, ACTION, DATE, TIME, UNIQUE-I-D | 12 |
| MAPOINV | AOI | Multiple PO Invoice | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, VENDOR, INVOICE, SUFFIX | 11 |
| MAREASONCD | MAR | Matching Reason Code | REASON-CODE | 2 |
| MARULAUD | MRU | Matching Rules Audit | MATCH-RULE, ACTION, DATE, TIME, UNIQUE-I-D | 12 |
| MATCHCLASS | MAL | Match Class | MATCH-CLASS | 7 |
| MAWORKQ | WRQ | No description in the Lawson data dictionary | ID, VENDOR-SNAME, VENDOR, COMPANY, INVOICE, SUFFIX, CANCEL-SEQ | 20 |
| PROCLEV | MAZ | Matching Process Level | COMPANY, PROC-LEVEL | 30 |
Online screens (106)
| Screen | Description | Updates | References |
|---|
| MA00.1 | Match Table | 5 | 6 |
| MA00.2 | Match Elements | 1 | 0 |
| MA00.3 | Match Class | 2 | 0 |
| MA00.4 | Match Rule Groups | 6 | 3 |
| MA00.5 | Element Value | 1 | 2 |
| MA00.6 | Element Group | 1 | 0 |
| MA00.7 | Element Group Relation | 1 | 2 |
| MA01.1 | Company | 8 | 16 |
| MA01.2 | Financial Reporting Account Setup | 2 | 4 |
| MA05.1 | Handling Code | 2 | 7 |
| MA05.2 | Vendor Handling Code | 0 | 3 |
| MA05.3 | Company Handling Code | 1 | 6 |
| MA05.4 | Process Level Handling Code | 0 | 2 |
| MA05.5 | Reason Code | 1 | 0 |
| MA05.6 | Multiple Handling Code | 2 | 6 |
| MA08.1 | Add On Charge/Allowance | 7 | 10 |
| MA26.1 | PO Invoice Match | 11 | 39 |
| MA41.1 | Add-On Cost Detail - Purchase Order | 227 | 243 |
| MA41.2 | Add On Cost Lookup | 227 | 243 |
| MA41.4 | Miscellaneous Add-On Cost | 227 | 243 |
| MA41.7 | AOC Approval Entry | 227 | 243 |
| MA42.1 | Memo Line Detail - Purchase Order | 91 | 111 |
| MA42.2 | Memo Line AOC Detail | 227 | 243 |
| MA43.1 | Invoice Line Detail - Purchase Order | 97 | 114 |
| MA43.2 | Purchase Order Lookup | 227 | 243 |
| MA43.3 | Invoice Line Detail - Receipt | 93 | 111 |
| MA43.4 | Invoice Line Detail - Service | 91 | 105 |
| MA43.6 | Service Agreement Detail | 91 | 107 |
| MA43.7 | GL Distribution | 177 | 185 |
| MA44.1 | Invoice Line Detail - Purchase Order | 227 | 244 |
| MA44.2 | Invoice Line Detail- Service | 227 | 244 |
| MA53.1 | Receipt Interface | 182 | 184 |
| MA53.2 | Receipt Adjustment Interface | 3 | 8 |
| MA53.3 | Receipt Interface Errors | 0 | 4 |
| MA53.4 | Receipt Interface Errors Filter | 0 | 2 |
| MA53.5 | Additional Receiving Entry | 1 | 5 |
| MA53.6 | Add-on Charge Line Details | 2 | 5 |
| MA53.7 | Additional Receiving Adjustment Entry | 1 | 5 |
| MA54.1 | Invoice | 6 | 22 |
| MA54.2 | Distribution | 2 | 16 |
| MA54.3 | Invoice Line Detail | 1 | 7 |
| MA54.7 | Add-on Charge Line Details | 2 | 5 |
| MA54.8 | Invoice Errors | 0 | 5 |
| MA54.9 | Invoice Errors Filter | 0 | 4 |
| MA60.1 | Reconciliation Queue | 1 | 10 |
| MA60.2 | Invoice Level Match | 176 | 191 |
| MA60.3 | Detail Level Match | 175 | 195 |
| MA60.4 | Invoice Match Reference Adjustment | 5 | 26 |
| MA60.5 | Receipt Match Reference Adjustment | 177 | 183 |
| MA60.7 | Chargeback Header Selection | 1 | 2 |
| MA61.1 | Match Invoice Approval | 212 | 232 |
| MA62.6 | Item Detail | 0 | 4 |
| MA62.7 | Chargeback Detail Selection | 0 | 2 |
| MA63.1 | Invoice Line Match | 89 | 100 |
| MA63.2 | Chargeback | 1 | 2 |
| MA64.1 | Message Queue - Vendor | 0 | 8 |
| MA64.2 | Message Queue - PO | 0 | 7 |
| MA64.3 | Message Queue - Item | 0 | 7 |
| MA64.4 | Invoice Messaging Queue | 0 | 5 |
| MA64.5 | Selection Criteria | 0 | 4 |
| MA64.6 | Message Detail by Invoice | 2 | 34 |
| MA64.8 | Workflow Message Queue - Invoice | 0 | 2 |
| MA64.9 | PO Cost Message Accept Upload | 9 | 41 |
| MA65.1 | Invoice Line Adjustment | 94 | 134 |
| MA66.1 | Review Invoice Message | 1 | 37 |
| MA66.2 | Invoice Message - Details | 182 | 191 |
| MA66.3 | Purchase Order Cost Review Message | 12 | 44 |
| MA66.8 | Chargeback Details | 0 | 11 |
| MA67.1 | Vendor inquiry frontend | 2 | 7 |
| MA67.2 | Invoice Match from frontend | 178 | 184 |
| MA67.3 | Detail Match from frontend | 176 | 195 |
| MA67.4 | AOC Match from frontend | 0 | 7 |
| MA68.1 | Reconciliation Queue - Prepaids | 1 | 9 |
| MA68.2 | Invoice Level Match - Prepaid | 176 | 190 |
| MA68.3 | Detail Level Match - Prepaid | 177 | 184 |
| MA68.4 | Invoice Match Reference Adjustment | 5 | 26 |
| MA68.5 | Receipt Match Reference Adjustment | 177 | 183 |
| MA68.7 | Chargeback | 1 | 2 |
| MA69.1 | AOC Level Detail Match | 88 | 101 |
| MA69.2 | AOC Level Selections | 1 | 14 |
| MA69.3 | Invoice-Invoice Level Totals Display | 0 | 4 |
| MA69.4 | Receipts-Invoice Level Totals Display | 0 | 4 |
| MA69.5 | Invoice-Detail Level Totals Display | 0 | 4 |
| MA69.6 | Receipt-Detail Level Totals Display | 0 | 4 |
| MA69.7 | Chargeback | 1 | 2 |
| MA70.1 | Invoice Unmatch | 201 | 195 |
| MA75.1 | PO Invoice Cancel | 201 | 195 |
| MA80.1 | Receipt Archive | 177 | 183 |
| MA89.1 | Company Audit | 0 | 2 |
| MA89.2 | Match Table Audit | 0 | 2 |
| MA89.3 | MA Rule Group Audit | 0 | 2 |
| MA90.1 | Match Analysis | 0 | 13 |
| MA90.2 | All Transactions for Invoice | 4 | 19 |
| MA90.3 | Match Analysis Details | 4 | 19 |
| MA90.4 | Ready to Archive Receipts | 0 | 5 |
| MA90.5 | Misc AOC for an Invoice | 4 | 18 |
| MA90.6 | Summarization | 4 | 17 |
| MA91.1 | Match Pool Display | 0 | 12 |
| MA95.1 | Vendor History | 0 | 5 |
| MA95.2 | Vendor History Analysis | 0 | 5 |
| MAED.1 | Vendor | 5 | 41 |
| MAHA.1 | Match Handling Code Edit | 0 | 1 |
| MAI1.1 | Invoke for MAMATCH Object | 211 | 235 |
| MAPC.1 | Match PO Code Edit | 0 | 1 |
| MAPL.1 | Process Level Setup | 2 | 2 |
| MARC.1 | Match Reason Code Edit | 0 | 1 |
Batch programs (20)
| Program | Description | Updates | References |
|---|
| MA126 | Auto Matching | 90 | 96 |
| MA167 | Smart Recon queue Build | 4 | 4 |
| MA168 | Prepaid Invoice Not Received | 4 | 9 |
| MA180 | Open Receipt Archive | 178 | 185 |
| MA189 | MA Audit Analysis Report | 4 | 4 |
| MA200 | Company Listing | 1 | 4 |
| MA205 | Code Listing | 2 | 15 |
| MA208 | Add on Charge/Allowance Listing | 6 | 12 |
| MA231 | Unmatched Receipt Listing | 2 | 12 |
| MA236 | Invoiced, Not Received Report | 1 | 16 |
| MA237 | Match Update Report | 2 | 12 |
| MA264 | Invoice Message Listing | 1 | 9 |
| MA278 | Cost Variance Analysis | 178 | 186 |
| MA279 | Invoice AOC Detail Report | 29 | 56 |
| MA310 | Pool Count Rebuild | 3 | 9 |
| MA530 | ERS Invoice Creation | 179 | 185 |
| MA531 | Receipt Interface | 186 | 182 |
| MA540 | Invoice Interface | 47 | 102 |
| MA730 | PORECLINE OTM REBUILD | 4 | 7 |
| MA999 | 802 Company Update | 3 | 0 |
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