Requisitions – Lawson RQ tables and programs
Requisitions (RQ) in Lawson S3 v10 MSP6 has 20 tables, 52 online screens and 26 batch programs.
Tables (20)
| Table | Prefix | Description | Primary key | Fields |
|---|
| PORLNUF | UFQ | No description in the Lawson data dictionary | COMPANY, REQ-NUMBER, LINE-NBR | 8 |
| PORQHUF | UFH | No description in the Lawson data dictionary | COMPANY, REQ-NUMBER | 7 |
| REQBOD | RBA | No description in the Lawson data dictionary | COMPANY, REQUESTER | 8 |
| REQHEADER | RQH | Requisition Header | COMPANY, REQ-NUMBER | 134 |
| REQLINE | RLN | Requisition Line | COMPANY, REQ-NUMBER, LINE-NBR | 113 |
| REQUESTER | REQ | Requester | COMPANY, REQUESTER | 49 |
| RQACCTU | RQU | Requesters Accounting Units | COMPANY, REQUESTER, ACCT-UNIT, DIST-COMPANY | 4 |
| RQAOCDTL | RAO | No description in the Lawson data dictionary | COMPANY, REQ-NUMBER, LINE-NBR, AOC-CODE | 22 |
| RQAOCSPRD | RSP | No description in the Lawson data dictionary | COMPANY, REQ-NUMBER, AOC-CODE | 24 |
| RQAPPCODE | RAC | Requisition Approval Codes | COMPANY, APPROVE-CD | 8 |
| RQAPPROVE | RAP | Requisition Approvals | COMPANY, AUTH-ID, APPROVE-CD, REQ-NUMBER | 5 |
| RQAUDIT | RHA | Requisition Audit | COMPANY, REQ-NUMBER, LINE-NBR, LINE-SEQ, BIN, LOT-SERIAL, UOM, DATE, TIME, FLD-NBR, AUDIT-TYPE | 16 |
| RQHBOD | RBB | No description in the Lawson data dictionary | COMPANY, REQ-NUMBER | 8 |
| RQLINEDTL | RQD | Requisition Line Details | COMPANY, REQ-NUMBER, LINE-NBR, BIN, LOT-SERIAL, UOM | 8 |
| RQLMXVAL | RQV | No description in the Lawson data dictionary | RQL-OBJ-ID, MATRIX-CAT | 3 |
| RQLOC | RQL | Requesting Locations | COMPANY, REQ-LOCATION | 36 |
| RQPURCHCLS | RQP | Requesters Purchasing Classes | COMPANY, REQUESTER, PURCH-MAJOR, PURCH-MINOR | 4 |
| RQREQAUDIT | RQA | Requester Audit | COMPANY, REQUESTER, PURCH-MAJOR, PURCH-MINOR, ACCT-UNIT, DIST-COMPANY, DATE, TIME, FLD-NBR | 14 |
| RQRQLAUDIT | RLA | Requesting Location Audit | COMPANY, REQ-LOCATION, DATE, TIME, FLD-NBR | 10 |
| RQTRANS | RQT | Requisition Transactions | FROM-COMPANY, FROM-LOCATION, DOC-TYPE, REQ-NUMBER, DOC-NBR-NUM, SEQ, LINE-NBR | 22 |
Online screens (52)
| Screen | Description | Updates | References |
|---|
| MM80.1 | Departmental Procurement Expense Inquiry Selection | 3 | 33 |
| MM80.2 | Departmental Procurement Expense Inquiry Detail | 3 | 34 |
| RQ01.1 | Requesting Locations | 179 | 188 |
| RQ01.2 | RQ Location Attributes | 0 | 7 |
| RQ01.3 | Values by RQ Location Attributes | 0 | 7 |
| RQ01.4 | Query List Members | 0 | 2 |
| RQ01.5 | Manual RQ Location List | 3 | 2 |
| RQ02.1 | Approval Codes | 2 | 8 |
| RQ04.1 | Requesters | 7 | 15 |
| RQ10.1 | Requisition | 193 | 241 |
| RQ10.2 | Account Distribution | 177 | 186 |
| RQ10.3 | Select and Copy | 192 | 237 |
| RQ10.4 | Requisition Line Entry Detail | 179 | 195 |
| RQ10.5 | Substitutes | 178 | 196 |
| RQ11.1 | Kit Accessories | 191 | 238 |
| RQ11.3 | AOC Spread | 13 | 33 |
| RQ11.4 | Miscellaneous AOC | 13 | 34 |
| RQ11.5 | Item AOC | 14 | 37 |
| RQ12.1 | Approval Review | 178 | 187 |
| RQ13.1 | Direct Approval | 178 | 187 |
| RQ13.2 | Direct Line Approval | 191 | 235 |
| RQ23.1 | Procedure Information | 4 | 3 |
| RQ35.1 | Requisition Returns | 193 | 240 |
| RQ39.1 | Serial Feedback | 2 | 9 |
| RQ39.2 | Lot Feedback | 2 | 8 |
| RQ39.3 | Bin Feedback | 2 | 7 |
| RQ40.1 | Requisitions by Location | 3 | 10 |
| RQ41.1 | Requisition Status | 4 | 9 |
| RQ42.1 | Requisitions by Item | 2 | 10 |
| RQ44.1 | Requisition Inquiry | 177 | 183 |
| RQ44.2 | Requisition Detail Inquiry | 4 | 17 |
| RQ50.1 | Issues History | 1 | 11 |
| RQ90.1 | Requisition Audit Inquiry | 1 | 2 |
| RQ91.1 | Requesting Location Audit Inquiry | 1 | 3 |
| RQ93.1 | Procedure Information Audit | 1 | 2 |
| RQ94.1 | Requester Audit Inquiry | 2 | 10 |
| RQBD.1 | RQ BOD Maintenance | 2 | 2 |
| RQBD.2 | RQ BOD Inquiry | 0 | 4 |
| RQBL.1 | Build Location Matrix List | 3 | 5 |
| RQBL.3 | Location Matrix Value Object | 2 | 3 |
| RQCP.1 | Copy Attachment Comments | 0 | 5 |
| RQD0.1 | Invoke for RQ Orphan Check | 22 | 20 |
| RQD1.1 | Invoke for RQ Integrity Check | 5 | 13 |
| RQIA.1 | RQREQPD Invoke Object | 2 | 28 |
| RQIB.1 | RQRQHUPD Invoke Object | 190 | 231 |
| RQIC.1 | Get Item List Invoke Object | 12 | 63 |
| RQID.1 | RQRQHUPD Invoke Object | 11 | 71 |
| RQIF.1 | RQRLNUPD Invoke Object | 193 | 244 |
| RQIG.1 | Get Shopping List Invoke Object | 12 | 65 |
| RQIH.1 | Invoke Determine Express Data | 4 | 30 |
| RQII.1 | Invoke for Reqheader Inquiry | 177 | 188 |
| RQIJ.1 | Requisition Copy | 190 | 241 |
Batch programs (26)
| Program | Description | Updates | References |
|---|
| MM280 | Departmental Procurement Expense Report | 4 | 36 |
| RQ111 | Print Requisitions | 3 | 23 |
| RQ140 | Requisition Status Report | 5 | 12 |
| RQ190 | Requisition Audit Report | 2 | 1 |
| RQ191 | Requesting Location Audit Rpt | 2 | 3 |
| RQ193 | Procedure Info Audit Report | 2 | 1 |
| RQ194 | Requester Audit Report | 2 | 2 |
| RQ201 | Location Listing | 1 | 3 |
| RQ202 | Approval Code Listing | 2 | 6 |
| RQ204 | Requester Listing | 2 | 5 |
| RQ230 | Department Usage Report | 2 | 15 |
| RQ235 | Issues Audit List | 3 | 12 |
| RQ240 | Requisition Volume Summary Report | 3 | 11 |
| RQ250 | Item Catalog | 1 | 5 |
| RQ260 | Requisitioned Items Report | 31 | 69 |
| RQ270 | RQ Fill Rate Analysis | 4 | 10 |
| RQ300 | Requisition Purge | 19 | 11 |
| RQ420 | RQ Orphan Check - Report Only | 1 | 1 |
| RQ421 | RQ Document Integrity Check - Report Only | 1 | 1 |
| RQ500 | Requisition Interface | 194 | 239 |
| RQ504 | Requester Setup Extract | 1 | 11 |
| RQ510 | Inventory Depletion Interface | 1 | 2 |
| RQ511 | HL7 Inventory Reorder-OmniCell | 1 | 1 |
| RQ512 | PO-EDI 850 Requisition Interface | 1 | 1 |
| RQ513 | Inventory Depletion Interface-HBOC/ESI | 1 | 2 |
| RQ810 | Request Location Load | 180 | 183 |
Other tables used by Requisitions programs (410)
ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACAMCODE, ACBILL, ACBILLX, ACBUDHDR, ACCAL, ACCALX, ACCATGRP, ACCATGRPX, ACCATSUM, ACCATSUMX, ACCNTRACT, ACCOMMIT, ACCOMMITX, ACCONSOL, ACDETAILAU, 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, AMSEGBLOCK, AMSYSOPTAU, AMTABLEPCT, AMTABLETAX, AMTAXAUTH, AMTEMPLATE, AMTRANS, AMTRANSBOD, AMTRANSUMM, AMTYPALLOC, AMTYPALLOX, AMUOPPDS, APACCRCODE, APAPIHIST, APAPPROVAL, APAUDIT, APAUTHOR, APCOMMENTS, APCOMPANY, APCONTACT, APCPYVND, APDISCCODE, APDISTCODE, APDISTHDR, APDISTRIB, APHLDINV, APHOLDCODE, APINCCODE, APINVOICE, APPAYMENT, APPROCGRP, APPROCLEV, APUAVAL, APUDISTCD, APUSRFLDEF, APVENADDR, APVENBAL, APVENCERT, APVENCLASS, APVENGROUP, APVENLOC, APVENMAST, APVENPAY, APVNMXVAL, ARCOMP, ARCUSTGRP, ARCUSTOMER, AUMXVALUAU, AUMXVLDTAU, BILLTO, BUYBOD, BUYCLASS, BUYCMPLOC, BUYER, BUYVENPF, CAALOCGPAU, CADETAILAU, CAHEADERAU, CBBANKINST, CBCASHCODE, CBCHECK, 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, GLACCTVLD, GLACMXVLAU, GLADDRESS, GLAMOUNTS, GLAUTMXVAU, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCHTDTLAU, GLCODES, GLCOMMIT, GLCOMMITX, GLCPYGRP, GLHISCOMBL, GLHISCOMX, GLINTCO, GLMASTER, GLMASTERAU, GLNAMES, GLNAMESAU, GLNLOCDTL, GLSYSTEM, GLSYSTEMAU, GLTRANS, GMFNDACT, GTMXVALUAU, HCCHRGITEM, HCHPPAUDIT, HCPATCHRG, HCPATPROC, HCPATVISIT, ICBIN, ICCATEGORY, ICCOMPANY, ICCOUT, ICFACILITY, ICHISTORY, ICICRAUDIT, ICITEMCODE, ICITEMGTIN, ICLOCATION, ICLOT, ICMANFCODE, ICMFGCODE, ICMFGDIST, ICRECEIPTS, ICRPTGRP, ICTRANS, ICTRANSDTL, ICUSRFLDEF, ICVALUOM, INDOCTPCD, INLINETYPE, INSTATPROC, INSTCMDTY, INSTCTRYCD, INSTDETAIL, INSTHEADER, INSTNBR, INSTNOTC, INSTPORTS, INSTREGN, ITEMGROUP, ITEMLOC, ITEMMAST, ITEMNDC, ITEMSKU, ITEMSPECL, ITEMSRC, ITEMSUB, ITEMUPC, ITEMUPN1, ITEMUPN2, ITSERIAL, JBKACCT, JBOOKHDR, KITITEM, KWDDETAIL, KWDMASTER, KWDSETUP, KWDSYNONYM, LMLEASE, LMLEASESEG, MAAOCDTL, MACAPDTL, MACOMPANY, MAELMGPREL, MAELMVALUE, MAINVDTL, MAINVHAND, MAINVMSG, MAJORCL, MAMAAHIST, MAMADHIST, MAMATCHTBL, MAMSGTOL, MAMTCHELEM, MAMTCHRULE, MAPOINV, MAREASONCD, MATCHCLASS, MFGSHPFAC, MINORCL, MLCOLEDGER, MMDIST, MMUAVAL, MXCATDEF, MXCATDEFAU, MXELEMENT, MXELEMNTAU, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXLSTDTLAU, MXLSTHDRAU, MXOBJCAT, MXOBJCATAU, MXTMPDTLAU, MXTMPHDRAU, MXTPEFDTAU, MXTPHEDTAU, MXVALIDATE, MXVALIDAU, MXVEWDTLAU, MXVEWHDRAU, NATACCT, NATBALANCE, OECOMPANY, OECUST, OEFRTCODE, OEROUTE, ORDERTYPE, PDCARD, PDCCHRGERR, PJLBOD, POAGMAUDIT, POAGMTPART, POAGMTPRIC, POAOCDTL, POAOCMAST, POAOCSPRD, POAPPCODE, POAPPROVE, POAUDIT, POAUDRULES, POAUDTYPE, POCODE, POCOMPANY, POCONTRACT, PODOCREF, POHDROUT, POHDRPVT, POINTAOC, POINTAUDIT, POINTERFAC, POITEMVEN, POIVACMNT, POLINE, POLINEOUT, POLINEPVT, POLINESRC, POMATCHOBJ, POMESSAGE, POMXVAL, POPCRUF, POPLIUF, POPOVUF, PORECADJHD, PORECADJLN, PORECEIVE, PORECLINE, PORETURNHD, PORETURNLN, POREVISION, POTRACK, POTRANSDTL, POUSRFLDEF, POVACOMMIT, POVACOMMIX, POVADIST, POVAGLNERR, POVAGRMTHD, POVAGRMTLN, POVAPARTLN, POVENDLOC, POVENDOR, PROCLEV, PROCTEMP, PROCTEMPLN, PROCTMPPAR, PROCUREGRP, PTHBOD, PURCHORDER, PVHBOD, REASON, RECAOCDTL, RJMXVALUAU, ROUTEDOC, ROUTEHDR, ROUTESTOP, SLSEGMENT, SLSEGVALUE, SOHDETAIL, STATICCUST, STCOMMCODE, SUBCKPOINT, SYSTEMCODE, TERMS, TXCODEMAST, TXCOMPANY, TXTAXCODE, TXTAXRATE, TXTAXTABLE, WFSETUP, WHDEMAND, WHDEMNDDTL, WHDEMNDHDR, WHDVAUDIT, WHLOCRULE, WHPROCTYPE, WHSHIPCOMP, WHSHIPLINE, WHSHIPMENT, WHSHLAUD, WHSHLDTL, WHSHTRK, WHSHTRKDTL