Employee Expense – Lawson EE tables and programs

Employee Expense (EE) in Lawson S3 v10 MSP6 has 1 table, 24 online screens and 7 batch programs.

Tables (1)

TablePrefixDescriptionPrimary keyFields
EXPBODEEBNo description in the Lawson data dictionaryCOMPANY, VENDOR, EXPENSE-NBR9

Online screens (24)

ScreenDescriptionUpdatesReferences
EE05.1Category67
EE05.2Approval Code11
EE11.1Expense Line Detail1136
EE20.1Employee Advance937
EE20.2Employee Expense1340
EE20.3Expense Detail1136
EE20.4Employee Payback1025
EE20.5Distribution Options01
EE30.1Expense and Advance Matching16
EE35.1Advance Release2963
EE35.2Expense Release2964
EE52.1Expense Update22
EE52.2Distribution68
EE90.1Advance Inquiry06
EE90.2Expense Inquiry06
EE90.3Expense Category Inquiry17
EEBD.1EE BOD Maintenance11
EEBD.2EE BOD Inquiry02
EEI1.1EE Comment Routine03
ET01.1Expense Categories10
ET02.1Non-Travel Expense Header21
ET02.2Non-Travel Expense Detail10
ET03.1Travel Expense Header21
ET03.2Travel Expense Detail10

Batch programs (7)

ProgramDescriptionUpdatesReferences
EE135Mass Employee Release2965
EE175Company Expense Posting510
EE220Expense, Advance, or Payback Edit213
EE230Expense or Advance Report213
EE235Expense Release Edit16
EE275Expense Analysis Report210
EE520Expense Interface3971

Other tables used by Employee Expense programs (115)

ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL, ACCALX, ACCATGRP, ACCATGRPX, ACCATSUM, ACCATSUMX, ACCNTRACT, ACCOMMIT, ACCOMMITX, ACCONSOL, ACIFACTV, ACTRANS, ADDRDATA, APACCRCODE, APAPIHIST, APAPPROVAL, APAUTHOR, APCOMPANY, APCONTACT, APCPYVND, APDISTRIB, APDRAFTS, APHLDINV, APHOLDCODE, APINVOICE, APMONITOR, APPAYGROUP, APPAYMENT, APPMTBOD, APPROCLEV, APUAVAL, APVENADDR, APVENBAL, APVENCLASS, APVENGROUP, APVENLCBOD, APVENLOC, APVENMAST, CBBANKENT, CBBANKINST, CBCASHCODE, CBCASHFORM, CBCHECK, CBCPYCASH, CBPAYMENT, CBRECPTHDR, CBTRANS, CBTRANSBOD, CBUSER, CBUSRCLASS, CUCODES, CUCONV, CURELAT, EEADVANCE, EEAPPROVAL, EECATEGORY, EECDISTRIB, EECEXPENSE, EEDISTRIB, EEEXPENSE, EEMATCHING, EENONDETL, EENONHEAD, EETRAVELDT, EETRAVELHD, EEUACATEG, EEUAVAL, EMPEXPENSE, FBDETAIL, FBFUNDAMT, FBFUNDDTL, FBHEADER, FBTRANS, FBYETR, GLADDRESS, GLAMOUNTS, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCODES, GLCOMMIT, GLCOMMITX, GLHISCOMBL, GLHISCOMX, GLINTCO, GLMASTER, GLNAMES, GLSYSTEM, GLTRANS, GMFNDACT, ICLOCATION, INSTCTRYCD, JBKOPCODE, JBKSEQNBR, JBKSYSCODE, JBOOKHDR, PODOCREF, PURCHORDER, SUBCKPOINT, SYSTEMCODE, TXCODEMAST, TXCOMPANY, TXTAXCODE, TXTAXRATE, TXTAXTABLE, TXTAXTRAN, VBABOD, WFSETUP