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)

TablePrefixDescriptionPrimary keyFields
PORLNUFUFQNo description in the Lawson data dictionaryCOMPANY, REQ-NUMBER, LINE-NBR8
PORQHUFUFHNo description in the Lawson data dictionaryCOMPANY, REQ-NUMBER7
REQBODRBANo description in the Lawson data dictionaryCOMPANY, REQUESTER8
REQHEADERRQHRequisition HeaderCOMPANY, REQ-NUMBER134
REQLINERLNRequisition LineCOMPANY, REQ-NUMBER, LINE-NBR113
REQUESTERREQRequesterCOMPANY, REQUESTER49
RQACCTURQURequesters Accounting UnitsCOMPANY, REQUESTER, ACCT-UNIT, DIST-COMPANY4
RQAOCDTLRAONo description in the Lawson data dictionaryCOMPANY, REQ-NUMBER, LINE-NBR, AOC-CODE22
RQAOCSPRDRSPNo description in the Lawson data dictionaryCOMPANY, REQ-NUMBER, AOC-CODE24
RQAPPCODERACRequisition Approval CodesCOMPANY, APPROVE-CD8
RQAPPROVERAPRequisition ApprovalsCOMPANY, AUTH-ID, APPROVE-CD, REQ-NUMBER5
RQAUDITRHARequisition AuditCOMPANY, REQ-NUMBER, LINE-NBR, LINE-SEQ, BIN, LOT-SERIAL, UOM, DATE, TIME, FLD-NBR, AUDIT-TYPE16
RQHBODRBBNo description in the Lawson data dictionaryCOMPANY, REQ-NUMBER8
RQLINEDTLRQDRequisition Line DetailsCOMPANY, REQ-NUMBER, LINE-NBR, BIN, LOT-SERIAL, UOM8
RQLMXVALRQVNo description in the Lawson data dictionaryRQL-OBJ-ID, MATRIX-CAT3
RQLOCRQLRequesting LocationsCOMPANY, REQ-LOCATION36
RQPURCHCLSRQPRequesters Purchasing ClassesCOMPANY, REQUESTER, PURCH-MAJOR, PURCH-MINOR4
RQREQAUDITRQARequester AuditCOMPANY, REQUESTER, PURCH-MAJOR, PURCH-MINOR, ACCT-UNIT, DIST-COMPANY, DATE, TIME, FLD-NBR14
RQRQLAUDITRLARequesting Location AuditCOMPANY, REQ-LOCATION, DATE, TIME, FLD-NBR10
RQTRANSRQTRequisition TransactionsFROM-COMPANY, FROM-LOCATION, DOC-TYPE, REQ-NUMBER, DOC-NBR-NUM, SEQ, LINE-NBR22

Online screens (52)

ScreenDescriptionUpdatesReferences
MM80.1Departmental Procurement Expense Inquiry Selection333
MM80.2Departmental Procurement Expense Inquiry Detail334
RQ01.1Requesting Locations179188
RQ01.2RQ Location Attributes07
RQ01.3Values by RQ Location Attributes07
RQ01.4Query List Members02
RQ01.5Manual RQ Location List32
RQ02.1Approval Codes28
RQ04.1Requesters715
RQ10.1Requisition193241
RQ10.2Account Distribution177186
RQ10.3Select and Copy192237
RQ10.4Requisition Line Entry Detail179195
RQ10.5Substitutes178196
RQ11.1Kit Accessories191238
RQ11.3AOC Spread1333
RQ11.4Miscellaneous AOC1334
RQ11.5Item AOC1437
RQ12.1Approval Review178187
RQ13.1Direct Approval178187
RQ13.2Direct Line Approval191235
RQ23.1Procedure Information43
RQ35.1Requisition Returns193240
RQ39.1Serial Feedback29
RQ39.2Lot Feedback28
RQ39.3Bin Feedback27
RQ40.1Requisitions by Location310
RQ41.1Requisition Status49
RQ42.1Requisitions by Item210
RQ44.1Requisition Inquiry177183
RQ44.2Requisition Detail Inquiry417
RQ50.1Issues History111
RQ90.1Requisition Audit Inquiry12
RQ91.1Requesting Location Audit Inquiry13
RQ93.1Procedure Information Audit12
RQ94.1Requester Audit Inquiry210
RQBD.1RQ BOD Maintenance22
RQBD.2RQ BOD Inquiry04
RQBL.1Build Location Matrix List35
RQBL.3Location Matrix Value Object23
RQCP.1Copy Attachment Comments05
RQD0.1Invoke for RQ Orphan Check2220
RQD1.1Invoke for RQ Integrity Check513
RQIA.1RQREQPD Invoke Object228
RQIB.1RQRQHUPD Invoke Object190231
RQIC.1Get Item List Invoke Object1263
RQID.1RQRQHUPD Invoke Object1171
RQIF.1RQRLNUPD Invoke Object193244
RQIG.1Get Shopping List Invoke Object1265
RQIH.1Invoke Determine Express Data430
RQII.1Invoke for Reqheader Inquiry177188
RQIJ.1Requisition Copy190241

Batch programs (26)

ProgramDescriptionUpdatesReferences
MM280Departmental Procurement Expense Report436
RQ111Print Requisitions323
RQ140Requisition Status Report512
RQ190Requisition Audit Report21
RQ191Requesting Location Audit Rpt23
RQ193Procedure Info Audit Report21
RQ194Requester Audit Report22
RQ201Location Listing13
RQ202Approval Code Listing26
RQ204Requester Listing25
RQ230Department Usage Report215
RQ235Issues Audit List312
RQ240Requisition Volume Summary Report311
RQ250Item Catalog15
RQ260Requisitioned Items Report3169
RQ270RQ Fill Rate Analysis410
RQ300Requisition Purge1911
RQ420RQ Orphan Check - Report Only11
RQ421RQ Document Integrity Check - Report Only11
RQ500Requisition Interface194239
RQ504Requester Setup Extract111
RQ510Inventory Depletion Interface12
RQ511HL7 Inventory Reorder-OmniCell11
RQ512PO-EDI 850 Requisition Interface11
RQ513Inventory Depletion Interface-HBOC/ESI12
RQ810Request Location Load180183

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