EE520 – Expense Interface
- System
- Employee Expense (EE)
- Type
- Batch program
- Updates
- 39 tables
- References
- 71 tables
EE520 (Expense Interface) is a Lawson Employee Expense batch program. It updates ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, APDISTRIB, APHLDINV, APINVOICE, APMONITOR and 31 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 63 more.
About EE520
Run Expense Interface (EE520) to interface employee expense and expense distribution information from a desktop application or a non-Lawson system to the Lawson Employee Expense system. The program also updates the Lawson Accounts Payable system for released (open) status expenses that you interface. After the appropriate expense information has been loaded into the interface files, run EE520 to edit the information for completeness and accuracy, create new expense and expense distribution records in the Lawson Employee Expense system, and purge the corresponding records from the interface files. You can use Expense Update (EE52) to maintain expense and distribution information in the expense interface files before you run EE520 or after you run EE520 to correct records that did not interface. You can maintainunreleased expense records on Expense Entry (EE20.2) after you interface them.
Updated files (39)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ACTRANS | Activity Transaction | AC |
| ADDRDATA | Address Code | IF |
| APDISTRIB | Invoice Distribution | AP |
| APHLDINV | Hold | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APMONITOR | Accounts Payable Monitor | AP |
| APPAYMENT | Invoice Payment | AP |
| APUAVAL | No description in the Lawson data dictionary | AP |
| APVENBAL | Vendor Balance | AP |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCPYCASH | Company-Cash Code Relationship | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| EEADVANCE | Employee Advance | AP |
| EECDISTRIB | Expense Distribution Interface | AP |
| EECEXPENSE | Expense Interface | AP |
| EEDISTRIB | Expense Distribution | AP |
| EEEXPENSE | Employee Expense | AP |
| EEMATCHING | Advance Expense Matching | AP |
| EEUAVAL | No description in the Lawson data dictionary | AP |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| ICLOCATION | Company Location | IC |
| JBKSEQNBR | Journal Book Sequence Number | GL |
| JBOOKHDR | Journal Book Header | IF |
| SUBCKPOINT | Subledger Check Point | IF |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
| TXTAXTRAN | Tax Transaction | TX |
Referenced files (71)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCONSOL | Activity Consolidation | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACTRANS | Activity Transaction | AC |
| APACCRCODE | Invoice Accrual Code | AP |
| APAPPROVAL | Invoice Approval | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APDRAFTS | AP Bill of Exchange | AP |
| APHOLDCODE | Hold Code | AP |
| APPAYGROUP | Pay Group | AP |
| APPMTBOD | No description in the Lawson data dictionary | AP |
| APPROCLEV | Accounts Payable Process Level | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENCLASS | Vendor Class | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLCBOD | No description in the Lawson data dictionary | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| CBBANKENT | Bank | CB |
| CBCASHFORM | Cash Payment Format | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBPAYMENT | Cash Payment | CB |
| CBRECPTHDR | Cash Receipt Deposit | CB |
| CBTRANS | Bank Transaction | CB |
| CBTRANSBOD | No description in the Lawson data dictionary | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| EEAPPROVAL | Expense Advance Approval Code | AP |
| EECATEGORY | Expense Advance Category Code | AP |
| EEUACATEG | No description in the Lawson data dictionary | AP |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JBKOPCODE | Journal Book Operator Code | IF |
| JBKSYSCODE | Journal Book System | IF |
| PODOCREF | Document Reference | PO |
| PURCHORDER | Purchase Order Master | PO |
| SYSTEMCODE | System Code | IF |
| TXTAXRATE | Tax Rate | TX |
| VBABOD | No description in the Lawson data dictionary | AP |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (13)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, SLSE, SLSS, SLSU