Case Carts – Lawson CX tables and programs

Case Carts (CX) in Lawson S3 v10 MSP6 has 20 tables, 17 online screens and 17 batch programs.

Tables (20)

TablePrefixDescriptionPrimary keyFields
CXBURDENCXBCase Cart BurdenCOMPANY, REQ-LOCATION, JOB-CODE, SCHEDULE, PAY-GRADE21
CXCASEHEADCXHCase Cart HeaderCOMPANY, REQ-LOCATION, CASE36
CXCASEPREFCXPCase Cart PreferencesCOMPANY, REQ-LOCATION, CASE, SEQ39
CXCOMPANYCXCCase Cart CompanyCOMPANY18
CXCPIUAVALCXVNo description in the Lawson data dictionaryCOMPANY, REQ-LOCATION, CASE, SEQ, LINE-NBR6
CXCTIUAVALCXTNo description in the Lawson data dictionaryCOMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, LINE-NBR8
CXDIAGNOSTCDICase Cart DiagnosticsDIAG-TYPE, DIAG-CODE9
CXITEMHISTCIHCase Cart Item HistoryCOMPANY, REQ-LOCATION, CASE, SEQ, LINE-NBR, REASON-CODE, REASON-TYPE22
CXLABRHISTCLHCase Cart Labor HistoryCOMPANY, REQ-LOCATION, CASE, SEQ, JOB-CODE, SCHEDULE, PAY-GRADE, PRFJOB-SEQ12
CXPRACASSTCPACase Cart Practitioner AssistPRACTNR-ID, PA-LAST-NAME, PA-FIRST-NAME, PA-MIDDLE-INIT12
CXPRACPROCCPPPractitioner ProceduresCOMPANY, PRACTNR-ID, PROC-TYPE, PROC-CODE4
CXPRACTNRCPRCase Cart PractitionersPRACTNR-ID20
CXPREFDIAGCPDPreference DiagnosticsCOMPANY, REQ-LOCATION, CASE, SEQ, DIAG-TYPE, DIAG-CODE13
CXPREFITEMCPIPreference ItemsCOMPANY, REQ-LOCATION, CASE, SEQ, LINE-NBR68
CXPREFJOBSCPJPreference BurdensCOMPANY, REQ-LOCATION, CASE, SEQ, JOB-CODE, SCHEDULE, PAY-GRADE, PRFJOB-SEQ23
CXPREFTEMPCPTPreference TemplateCOMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID28
CXPROCEDRCPCCase Cart ProceduresPROC-TYPE, PROC-CODE5
CXPTMPDIAGCTDTemplate DiagnosticsCOMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, DIAG-TYPE, DIAG-CODE8
CXPTMPITEMCTITemplate ItemsCOMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, LINE-NBR52
CXTMPJOBSCTJTemplate BurdensCOMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, JOB-CODE, SCHEDULE, PAY-GRADE, TMPJOB-SEQ21

Online screens (17)

ScreenDescriptionUpdatesReferences
CX01.1Healthcare Company11
CX02.1Procedures10
CX03.1Diagnostics10
CX04.1Practitioner32
CX05.1Preference Template1643
CX05.2Preference Template Diagnostics1437
CX15.1Burden13
CX20.1Case Build188188
CX20.2Case Detail188187
CX20.3Case Diagnostics13
CX20.4Substitute Items188187
CX20.5Insert line188187
CX30.1Case Completion Feedback190186
CX50.1Preference List Status05
CX55.1Case Procedure Inquiry010
CXCP.1Copy preference to case180188
CXMC.1Case cart mimic40

Batch programs (17)

ProgramDescriptionUpdatesReferences
CX100Pick List Print189190
CX205Preference Template Items415
CX207Preference List Value19
CX220Case, Preference Listing189188
CX225Practitioner Case Load17
CX230Waste, Return Items16
CX235Procedure Cost versus Diagnosis Related Group17
CX240Item Returns19
CX300Preference List Purge189187
CX502Procedure Code Import20
CX503Diagnostic File Build20
CX504HR Labor Import22
CX506HL7 Schedules Import Interface191185
CX507HL7 Practitioner and Staff Import31
CX512Procedure Sequential File Build10
CX513Diagnostic File Build10
CX805Template Card Conversion1537

Other tables used by Case Carts programs (338)

ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACAMCODE, ACBILL, ACBILLX, ACBUDHDR, ACCAL, ACCALX, ACCATGRP, ACCATGRPX, ACCATSUM, ACCATSUMX, ACCNTRACT, ACCOMMIT, ACCOMMITX, ACCONSOL, ACIFACTV, ACMXVAL, 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, AMDIVISION, AMDIVISNAU, AMINTER, AMINTERAU, AMLOCATION, AMLOCAUDIT, AMLOCDTL, AMMETHOD, AMMONITOR, AMPOASTDTL, AMPOASTHDR, AMPODFLTS, AMPUCODE, AMPUHIS, AMSEGBLOCK, AMTABLEPCT, AMTABLETAX, AMTAXAUTH, AMTEMPLATE, AMTRANS, AMTRANSBOD, AMTRANSUMM, AMTYPALLOC, AMTYPALLOX, AMUOPPDS, APACCRCODE, APAPIHIST, APAPPROVAL, APAUDIT, APAUTHOR, APCOMMENTS, APCOMPANY, APCONTACT, APCPYVND, APDISCCODE, APDISTHDR, APHLDINV, APHOLDCODE, APINCCODE, APINVOICE, APPAYMENT, APPROCGRP, APPROCLEV, APUAVAL, APUSRFLDEF, APVENADDR, APVENBAL, APVENCERT, APVENCLASS, APVENGROUP, APVENLOC, APVENMAST, APVENPAY, APVNMXVAL, ARCOMP, ARCUSTGRP, ARCUSTOMER, BILLTO, BUYBOD, BUYCLASS, BUYCMPLOC, BUYER, BUYVENPF, CBBANKINST, CBCASHCODE, CBCHECK, CBUSER, CBUSRCLASS, COCOMP, COLINE, COMPONENT, COSGBLK, CUCODES, CUCONV, CURELAT, CUSTDESC, CUSTORDER, EEADVANCE, EEAPPROVAL, EEEXPENSE, FBDETAIL, FBFUNDAMT, FBFUNDDTL, FBHEADER, FBTRANS, FBYETR, GLADDRESS, GLAMOUNTS, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCODES, GLCOMMIT, GLCOMMITX, GLHISCOMBL, GLHISCOMX, GLINTCO, GLMASTER, GLNAMES, GLNLOCDTL, GLSYSTEM, GLTRANS, GMFNDACT, HCCHRGITEM, HCHPPAUDIT, HCPATCHRG, HCPATIENT, HCPATPROC, HCPATVISIT, ICBIN, ICCATEGORY, ICCOMPANY, ICCOUT, ICFACILITY, ICHISTORY, ICICRAUDIT, ICITEMCODE, ICITEMGTIN, ICLOCATION, ICLOT, ICMANFCODE, ICMFGCODE, ICMFGDIST, ICRECEIPTS, ICTRANS, ICTRANSDTL, ICVALUOM, INDOCTPCD, INLINETYPE, INSTATPROC, INSTCMDTY, INSTCTRYCD, INSTDETAIL, INSTHEADER, INSTNBR, INSTNOTC, INSTPORTS, INSTREGN, ITEMGROUP, ITEMLOC, ITEMLOCBIN, ITEMMAST, ITEMSPECL, ITEMSRC, ITEMSUB, ITSERIAL, KITITEM, KWDDETAIL, KWDMASTER, KWDSETUP, KWDSYNONYM, LMLEASE, LMLEASESEG, MAAOCDTL, MACOMPANY, MAELMGPREL, MAELMVALUE, MAINVDTL, MAINVHAND, MAMAAHIST, MAMADHIST, MAMATCHTBL, MAMSGTOL, MAMTCHELEM, MAMTCHRULE, MAPOINV, MAREASONCD, MATCHCLASS, MFGSHPFAC, MMDIST, MMUAVAL, MXCATDEF, MXELEMENT, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXOBJCAT, NATACCT, NATBALANCE, OECOMPANY, OECUST, OEFRTCODE, OEROUTE, ORDERTYPE, PDCARD, PDCCHRGERR, PJLBOD, POAGMAUDIT, POAGMTPART, POAGMTPRIC, POAOCDTL, POAOCMAST, POAOCSPRD, POAPPCODE, POAPPROVE, POAUDIT, POAUDRULES, POAUDTYPE, POCODE, POCOMPANY, 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, PORLNUF, PORQHUF, POTRACK, POTRANSDTL, POVACOMMIT, POVACOMMIX, POVADIST, POVAGLNERR, POVAGRMTHD, POVAGRMTLN, POVAPARTLN, POVENDLOC, POVENDOR, PROCLEV, PROCTEMPLN, PROCUREGRP, PTHBOD, PURCHORDER, PVHBOD, REASON, RECAOCDTL, REQHEADER, REQLINE, REQUESTER, ROUTEDOC, ROUTEHDR, ROUTESTOP, RQAUDIT, RQLOC, RQTRANS, SOHDETAIL, STATICCUST, STCOMMCODE, SUBCKPOINT, SYSTEMCODE, TERMS, TXCODEMAST, TXCOMPANY, TXTAXCODE, TXTAXRATE, TXTAXTABLE, WFSETUP, WHDEMAND, WHDEMNDDTL, WHDEMNDHDR, WHPROCTYPE, WHSHIPCOMP, WHSHIPLINE, WHSHIPMENT, WHSHLAUD, WHSHLDTL, WHSHTRK, WHSHTRKDTL