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)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| EXPBOD | EEB | No description in the Lawson data dictionary | COMPANY, VENDOR, EXPENSE-NBR | 9 |
Online screens (24)
| Screen | Description | Updates | References |
|---|---|---|---|
| EE05.1 | Category | 6 | 7 |
| EE05.2 | Approval Code | 1 | 1 |
| EE11.1 | Expense Line Detail | 11 | 36 |
| EE20.1 | Employee Advance | 9 | 37 |
| EE20.2 | Employee Expense | 13 | 40 |
| EE20.3 | Expense Detail | 11 | 36 |
| EE20.4 | Employee Payback | 10 | 25 |
| EE20.5 | Distribution Options | 0 | 1 |
| EE30.1 | Expense and Advance Matching | 1 | 6 |
| EE35.1 | Advance Release | 29 | 63 |
| EE35.2 | Expense Release | 29 | 64 |
| EE52.1 | Expense Update | 2 | 2 |
| EE52.2 | Distribution | 6 | 8 |
| EE90.1 | Advance Inquiry | 0 | 6 |
| EE90.2 | Expense Inquiry | 0 | 6 |
| EE90.3 | Expense Category Inquiry | 1 | 7 |
| EEBD.1 | EE BOD Maintenance | 1 | 1 |
| EEBD.2 | EE BOD Inquiry | 0 | 2 |
| EEI1.1 | EE Comment Routine | 0 | 3 |
| ET01.1 | Expense Categories | 1 | 0 |
| ET02.1 | Non-Travel Expense Header | 2 | 1 |
| ET02.2 | Non-Travel Expense Detail | 1 | 0 |
| ET03.1 | Travel Expense Header | 2 | 1 |
| ET03.2 | Travel Expense Detail | 1 | 0 |
Batch programs (7)
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