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)
| Table | Prefix | Description | Primary key | Fields |
|---|
| CXBURDEN | CXB | Case Cart Burden | COMPANY, REQ-LOCATION, JOB-CODE, SCHEDULE, PAY-GRADE | 21 |
| CXCASEHEAD | CXH | Case Cart Header | COMPANY, REQ-LOCATION, CASE | 36 |
| CXCASEPREF | CXP | Case Cart Preferences | COMPANY, REQ-LOCATION, CASE, SEQ | 39 |
| CXCOMPANY | CXC | Case Cart Company | COMPANY | 18 |
| CXCPIUAVAL | CXV | No description in the Lawson data dictionary | COMPANY, REQ-LOCATION, CASE, SEQ, LINE-NBR | 6 |
| CXCTIUAVAL | CXT | No description in the Lawson data dictionary | COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, LINE-NBR | 8 |
| CXDIAGNOST | CDI | Case Cart Diagnostics | DIAG-TYPE, DIAG-CODE | 9 |
| CXITEMHIST | CIH | Case Cart Item History | COMPANY, REQ-LOCATION, CASE, SEQ, LINE-NBR, REASON-CODE, REASON-TYPE | 22 |
| CXLABRHIST | CLH | Case Cart Labor History | COMPANY, REQ-LOCATION, CASE, SEQ, JOB-CODE, SCHEDULE, PAY-GRADE, PRFJOB-SEQ | 12 |
| CXPRACASST | CPA | Case Cart Practitioner Assist | PRACTNR-ID, PA-LAST-NAME, PA-FIRST-NAME, PA-MIDDLE-INIT | 12 |
| CXPRACPROC | CPP | Practitioner Procedures | COMPANY, PRACTNR-ID, PROC-TYPE, PROC-CODE | 4 |
| CXPRACTNR | CPR | Case Cart Practitioners | PRACTNR-ID | 20 |
| CXPREFDIAG | CPD | Preference Diagnostics | COMPANY, REQ-LOCATION, CASE, SEQ, DIAG-TYPE, DIAG-CODE | 13 |
| CXPREFITEM | CPI | Preference Items | COMPANY, REQ-LOCATION, CASE, SEQ, LINE-NBR | 68 |
| CXPREFJOBS | CPJ | Preference Burdens | COMPANY, REQ-LOCATION, CASE, SEQ, JOB-CODE, SCHEDULE, PAY-GRADE, PRFJOB-SEQ | 23 |
| CXPREFTEMP | CPT | Preference Template | COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID | 28 |
| CXPROCEDR | CPC | Case Cart Procedures | PROC-TYPE, PROC-CODE | 5 |
| CXPTMPDIAG | CTD | Template Diagnostics | COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, DIAG-TYPE, DIAG-CODE | 8 |
| CXPTMPITEM | CTI | Template Items | COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, LINE-NBR | 52 |
| CXTMPJOBS | CTJ | Template Burdens | COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, JOB-CODE, SCHEDULE, PAY-GRADE, TMPJOB-SEQ | 21 |
Batch programs (17)
| Program | Description | Updates | References |
|---|
| CX100 | Pick List Print | 189 | 190 |
| CX205 | Preference Template Items | 4 | 15 |
| CX207 | Preference List Value | 1 | 9 |
| CX220 | Case, Preference Listing | 189 | 188 |
| CX225 | Practitioner Case Load | 1 | 7 |
| CX230 | Waste, Return Items | 1 | 6 |
| CX235 | Procedure Cost versus Diagnosis Related Group | 1 | 7 |
| CX240 | Item Returns | 1 | 9 |
| CX300 | Preference List Purge | 189 | 187 |
| CX502 | Procedure Code Import | 2 | 0 |
| CX503 | Diagnostic File Build | 2 | 0 |
| CX504 | HR Labor Import | 2 | 2 |
| CX506 | HL7 Schedules Import Interface | 191 | 185 |
| CX507 | HL7 Practitioner and Staff Import | 3 | 1 |
| CX512 | Procedure Sequential File Build | 1 | 0 |
| CX513 | Diagnostic File Build | 1 | 0 |
| CX805 | Template Card Conversion | 15 | 37 |
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