AP300 – Invoice and Vendor History Purge
- System
- Accounts Payable (AP)
- Type
- Batch program
- Updates
- 67 tables
- References
- 73 tables
AP300 (Invoice and Vendor History Purge) is a Lawson Accounts Payable batch program. It updates APAPDHIST, APAPIHIST, APAPPHIST, APAPPROVAL, APAPSHIST, APASTDTL, APAUDIT, APCOMMENTS and 59 more and references APACCRCODE, APAPDHIST, APAPPHIST, APAUTHOR, APCOMPANY, APCRMEMO, APCRMHIST, APDFLHIST and 65 more.
About AP300
Run Invoice and Vendor History Purge (AP300) to delete historical Accounts Payable transactions, records, and contact information from Accounts Payable database files and archive the records to a .csv file. Before you deleteinformation, consider running Bank Account Payment History (AP255), Vendor Payment History (AP270), and Invoice Distribution History (AP275) through the cut-off date you define to list information you are deleting. You cannot inquire or report on the information this form deletes. WARNING This form permanently deletes data. Before you run this form, back up your data according to your company's procedures. Before you submit the report, carefully review the parameters.
Updated files (67)
| Table | Description | System |
|---|---|---|
| APAPDHIST | No description in the Lawson data dictionary | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPHIST | AP Payment History | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAPSHIST | No description in the Lawson data dictionary | AP |
| APASTDTL | Asset Detail | AP |
| APAUDIT | Vendor Invoice Audit | AP |
| APCOMMENTS | Comments | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APCRMEMO | Credit Memo Application | AP |
| APCRMHIST | No description in the Lawson data dictionary | AP |
| APDFLHIST | No description in the Lawson data dictionary | AP |
| APDISCACC | Discount | AP |
| APDISTPAY | For invoices with retainage, it is required to track what has been paid against a vendor agreement or purchase order… | AP |
| APDISTRIB | Invoice Distribution | AP |
| APDSKHIST | No description in the Lawson data dictionary | AP |
| APDSUSRFLD | Accounts Payable User Fields | AP |
| APHLDINV | Hold | AP |
| APINUSRFLD | AP Invoice User Fields | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APISRHIST | No description in the Lawson data dictionary | AP |
| APMONITOR | Accounts Payable Monitor | AP |
| APPAYMENT | Invoice Payment | AP |
| APPOVNXREF | No description in the Lawson data dictionary | AP |
| APUAVAL | No description in the Lawson data dictionary | AP |
| APUAVHIST | No description in the Lawson data dictionary | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENDIV | The APVENDIV file stores the diversity codes and their certification dates for the related vendor in APVENMAST | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| APVENPAY | No description in the Lawson data dictionary | AP |
| APVENTABLE | Vendor Table | AP |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUSTDESC | AR Group Customer | AR |
| EEADVANCE | Employee Advance | AP |
| EEDISTRIB | Expense Distribution | AP |
| EEEXPENSE | Employee Expense | AP |
| EEMATCHING | Advance Expense Matching | AP |
| EEUAVAL | No description in the Lawson data dictionary | AP |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| ITEMSRC | Item Source | IC |
| MAAOCDTL | Invoice Add On Cost Detail | MA |
| MAAOIHIST | No description in the Lawson data dictionary | MA |
| MAINVDTL | Invoice Line Detail | MA |
| MAINVMSG | Invoice and PO Cost Message | MA |
| MAMAAHIST | No description in the Lawson data dictionary | MA |
| MAMADHIST | No description in the Lawson data dictionary | MA |
| MAPOINV | Multiple PO Invoice | MA |
| MMDIST | Account Distributions | PO |
| MMUAVAL | No description in the Lawson data dictionary | PO |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| POAOCSPRD | Add On Cost Spread | PO |
| POPOVUF | No description in the Lawson data dictionary | PO |
| POPSPHIST | No description in the Lawson data dictionary | PO |
| POVENDLOC | Vendor Location Master | PO |
| POVENDOR | PO Vendor Master | PO |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (73)
| Table | Description | System |
|---|---|---|
| APACCRCODE | Invoice Accrual Code | AP |
| APAPDHIST | No description in the Lawson data dictionary | AP |
| APAPPHIST | AP Payment History | AP |
| APAUTHOR | Authority Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCRMEMO | Credit Memo Application | AP |
| APCRMHIST | No description in the Lawson data dictionary | AP |
| APDFLHIST | No description in the Lawson data dictionary | AP |
| APDISCACC | Discount | AP |
| APDISCCODE | Discount Code | AP |
| APDISTHDR | Distribution Code Header | AP |
| APDISTRIB | Invoice Distribution | AP |
| APDRAFTS | AP Bill of Exchange | AP |
| APDSKHIST | No description in the Lawson data dictionary | AP |
| APDSUSRFLD | Accounts Payable User Fields | AP |
| APHLDINV | Hold | AP |
| APHOLDCODE | Hold Code | AP |
| APINCCODE | Income Code | AP |
| APPAYMENT | Invoice Payment | AP |
| APPMTBOD | No description in the Lawson data dictionary | AP |
| APPROCGRP | Process Group | AP |
| APUSRFLDEF | AP User Field Definition | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENCLASS | Vendor Class | AP |
| APVENLCBOD | No description in the Lawson data dictionary | AP |
| APVNMXVAL | No description in the Lawson data dictionary | AP |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| 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 |
| EEDISTRIB | Expense Distribution | AP |
| EEMATCHING | Advance Expense Matching | AP |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTREGN | Intrastat Region Code | TX |
| ITEMSRC | Item Source | IC |
| MAAOCDTL | Invoice Add On Cost Detail | MA |
| MAAOIHIST | No description in the Lawson data dictionary | MA |
| MAINVDTL | Invoice Line Detail | MA |
| MAINVHAND | Invoice Handling Code | MA |
| MAINVMSG | Invoice and PO Cost Message | MA |
| MAMAAHIST | No description in the Lawson data dictionary | MA |
| MAMADHIST | No description in the Lawson data dictionary | MA |
| MAMATCHTBL | Match Table | MA |
| MAMSGTOL | No description in the Lawson data dictionary | MA |
| MAMTCHRULE | Matching Rules | MA |
| MAPOINV | Multiple PO Invoice | MA |
| MMDIST | Account Distributions | PO |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| POAOCDTL | Add On Cost Detail | PO |
| POAOCSPRD | Add On Cost Spread | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POPSPHIST | No description in the Lawson data dictionary | PO |
| POVAGRMTHD | Vendor Agreement | PO |
| PROCUREGRP | Procurement Group | PO |
| PURCHORDER | Purchase Order Master | PO |
| 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 (11)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU