AR301 – Customer Purge

System
Accounts Receivable (AR)
Type
Batch program
Updates
32 tables
References
30 tables

AR301 (Customer Purge) is a Lawson Accounts Receivable batch program. It updates ARACMUF, ARAUDIT, ARCOMMENT, ARCONTACTS, ARCSTMXVAL, ARCUSTFLDS, ARCUSTGRP, ARCUSTOMER and 24 more and references AGEUSERONE, ARAPPLDBOD, ARAPPLIED, ARCOMP, ARCSTMXVAL, ARCUSTBOD, ARCYCLE, ARDUNCODE and 22 more.

About AR301

Run Customer Purge (AR301) to delete all customers assigned to a specific company or customer group from the Lawson Accounts Receivable system. Any related customer audit records are also deleted. You can run AR301 to delete customers or to set a customer's status to D (eligible for deletion). The report creates a listing of deleted customers or customers you set for deletion. You have the option to archive deleted records to disk. The output file contains the information included in the listing. WARNING This program permanently deletes data. Before you run this program, back up your data according to your organization's procedures. Before you submit the report, carefully review the parameters. **Processing Effect If you want to archive records to disk, choose Yes in the Archive Records field. AR301 generates a comma-separated value (CSV) file in the $LAWDIR/productline/work/PUREXXX-FILE directory (UNIX) or the /LAWDIR/productline/work/PUREXXX-FILE directory (System i) where XXX is the three character file prefix for each file you select for purging. The filename becomes the jobname.date time (MMDDHHMMSSSS). For example, a file name run on July 28th would be AR301PROD.072812392145

Updated files (32)

TableDescriptionSystem
ARACMUFThe Customer User Fields file contains extra user fields that can be entered for a customer.AR
ARAUDITNo description in the Lawson data dictionaryAR
ARCOMMENTCustomer CommentsAR
ARCONTACTSAR Customer ContactsAR
ARCSTMXVALThis file contains an attribute value for a customer.AR
ARCUSTFLDSAR Customer User FieldsAR
ARCUSTGRPAccounts Receivable Cust GroupAR
ARCUSTOMERAR Company CustomerAR
ARCUSTPERAR Customer Period TotalsAR
ARCUSTTOTSAR Customer PL InclusionsAR
ARLOCKBOXLock Box LocationAR
ARMICRCUSTAR MICR Customer Cross RefAR
BALFWDTOTAR Balance Forward Cust TotalsAR
BILLTOBill ToAR
CBBANKINSTBank Transaction CodeCB
CKPOINTNo description in the Lawson data dictionary
CRANALYSTAR Credit AnalystsAR
CUSTDEFLTSAR Customer DefaultsAR
CUSTDESCAR Group CustomerAR
CUSTEPNo description in the Lawson data dictionaryBL
DTCUSTBANKAR Customer Paying BankDT
FTCUSTNOTEEFT Customer NotificationAR
HOLDCODESAR Hold CodeAR
MAJCUSTCLMajor Customer ClassAR
MINCUSTCLMinor Customer ClassAR
MXLISTHDRAttribute List HeaderIF
MXLISTMBRAttribute ListIF
NATACCTAccounts Receivable Natl AcctAR
NATBALANCEAR National Account BalanceAR
OECUSTCustomer Order ProcessingAR
STATICCUSTAR Ovrd Credit Trans ReviewAR
TERMSPayment Terms MaintenanceTE

Referenced files (30)

TableDescriptionSystem
AGEUSERONENo description in the Lawson data dictionaryAR
ARAPPLDBODNo description in the Lawson data dictionaryAR
ARAPPLIEDAcct Receivables ApplicationAR
ARCOMPAccounts Receivable CompanyAR
ARCSTMXVALThis file contains an attribute value for a customer.AR
ARCUSTBODNo description in the Lawson data dictionaryAR
ARCYCLEAccounts Receivable Cycle CodeAR
ARDUNCODEDunning Process CodeAR
AROIHDRAcct Receivables Trans HeaderAR
AROITEMSAcct Receivables TransactionAR
ARPAYMENTAcct Receivables PaymentAR
ARREMITPayment RemittanceAR
BILLTOBODNo description in the Lawson data dictionaryAR
CBBANKENTBankCB
CONBODNo description in the Lawson data dictionaryAR
CUCODESCurrency CodesIF
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
EPTRANSNo description in the Lawson data dictionaryBL
FTCUSTGRPEFT Customer GroupAR
FTTRANSEFT TransactionAR
GLINTCOGeneral Ledger IntercompanyIF
GLSYSTEMGeneral Ledger CompanyIF
MXCATDEFAttribute DefinitionIF
MXELEMENTAttribute ElementIF
MXLISTDTLAttribute List DetailIF
MXOBJCATAttribute ObjectIF
OECOMPANYOrder Entry CompanyBL
SALESREPAccounts Receivables Sales RepAR
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (11)

ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU