AC300 – Activity Group Purge

System: Activity Management (AC)
Type: Batch program
Updates: 89 tables
References: 10 tables

AC300 (Activity Group Purge) is a Lawson Activity Management batch program. It updates ACACCTCATX, ACACRESRT, ACACRESRTX, ACACTGPREL, ACACTGRP, ACACTGRPAU, ACACTIVITY, ACACTMXVAL and 81 more and references ACHISTDTL, ACHISTHDR, ACINVORD, ACPURGE, BRMONITOR, GMGMASEG, GMGMHSEG, MXLISTHDR and 2 more.

About AC300

Run Activity Group Purge (AC300) to purge activity information. You can delete activity information for an activity group or activity group list. You can either completely delete activities or zero out the balances based on your selection in the Purge Selection field. All activities or activities balances associated with the activity group will also be purged. Change the status on Activity Group Purge Status (AC00.3) to match the purge selection on the AC300 parameters. You can not purge an activity group unless all associated invoices have already been purged. Use Invoice Purge (BR300) to purge invoices. NOTE Activities assigned to the activity group will be purged regardless of activity status. Consider moving activities you want to purge to a dummy activity group using AC10.5 and then delete the dummy group using AC300. 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. **Process at a Glance 1. Use Activity Group Purge Status (AC00.3) to define or change the status of the activity group. 2. Run Activity Group Purge (AC300) to purge activity information.

Updated files (89)

Table	Description	System
ACACCTCATX	Account Category Detail	AC
ACACRESRT	Resource Standard Cost	AC
ACACRESRTX	AC Resource Standard Cost Dtl	AC
ACACTGPREL	Activity Group Relation	AC
ACACTGRP	Activity Group	AC
ACACTGRPAU	Activity Group Audit	AC
ACACTIVITY	Activity	AC
ACACTMXVAL	Activity List Attribute Values	AC
ACACTMXVDT	No description in the Lawson data dictionary	AC
ACACTREL	Activity Relationship	AC
ACACTSEG	The Activity Management Activity Segment file stores the user analysis data associated with each activity defined in…	AC
ACADDASSGN	Activity Address Assignment	AC
ACADDLCNTR	Additional Contract Info	BR
ACAMCODE	Activity Asset	AC
ACASNROLE	The Assignment Role file will store the roles associated with a resource assignment.	AC
ACASSIGN	Activity Resource Assignment	AC
ACAUDIT	Activity Audit	AC
ACBILL	Activity Billing	BR
ACBILLX	Activity Billing Detail	BR
ACBLMAST	Activity Billing Balances	BR
ACBLRATE	Activity Billing Rates Header	BR
ACBLRATEX	Activity Billing Rates Detail	BR
ACBRDNADJ	No description in the Lawson data dictionary	AC
ACBRDNBLRT	Activity Burden Billing Rate	AC
ACBRDNBLRX	Activity Brdn Billing Rate Dtl	BR
ACBRDNDTL	Burden Codes Assignment	AC
ACBRDNTRAN	The Burden Transactions file is updated by the Activity Posting (AC190) program.	AC
ACBUDDTL	Activity Budget	AC
ACBUDHDR	Activity Budget Header	AC
ACBUDRATE	Activity Budget Rate	AC
ACBUDREL	Activity Budget Relation	AC
ACCATRANS	AC Allocation Transaction	AC
ACCEILING	Activity Ceiling	BR
ACCEILINGX	Activity Ceiling Detail	BR
ACCHGORDER	Activity Change Order	AC
ACCHGORDX	Activity Change Order Detail	AC
ACCLGTRANS	Ceiling Level Transactions	BR
ACCNTMOD	Activity Comment Type	BR
ACCNTRACCT	Activity Contract Accounts	BR
ACCNTRACT	Activity Contract	BR
ACCNTRACTX	Activity Contract Detail	BR
ACCNTRWBS	Activity Contract WBS	BR
ACCOMMIT	Activity Commitments	AC
ACCOMMITX	Activity Commitments Detail	AC
ACCONSOL	Activity Consolidation	AC
ACCONTACTS	Contract Customer Contacts	BR
ACCTRCATG	Contract Category Group	BR
ACCTRCATGX	Contract Category Group Dtl	BR
ACCUAMT	Activity Currency Amount	AC
ACFEEBAL	The fee balance file stores cumulative costs, fee and overage which will be used in calculating the billing and revenue…	BR
ACFEEDTL	Activity Management Fee Detail	BR
ACGLACCT	Activity GL Accounts	AC
ACGLCONSL	AC GL Acct Unit Consolidation	AC
ACGLMAST	AC GL Acct Unit Master	AC
ACGLTOTREV	Activity Total Revenue Amount	BR
ACGRPMXVAL	The ACGRPMXVAL file is the primary file updated by AC13.	AC
ACGRPMXVDT	This file is used to store the effective date values for activity group attributes.	AC
ACHISTORY	Activity Audit	AC
ACINVORD	No description in the Lawson data dictionary	BR
ACMASTER	Activity Balances	AC
ACMILESTN	Activity Milestones	BR
ACMILESTNX	Activity Milestones Detail	BR
ACMXVAL	AC Trans Attribute Values	AC
ACOVERRIDE	This file will contain a record for each record created in the assignment files ACGLACCT, ACBRDNDTL, and ACEMPEXPX.	AC
ACPERCCMPL	Activity Percent Complete	AC
ACPERCMPLX	Activity Percent Complete Dtl	AC
ACPRDPERF	Activity Period Performance	AC
ACRESHIST	No description in the Lawson data dictionary	AC
ACRETAIN	No description in the Lawson data dictionary	BR
ACRETAINX	No description in the Lawson data dictionary	BR
ACRETNG	Activity Bill Retention	BR
ACRETNGX	Activity Bill Retention Detail	BR
ACSUMBAL	No description in the Lawson data dictionary	AC
ACTOTBAL	No description in the Lawson data dictionary	AC
ACTRANS	Activity Transaction	AC
ACTRANSEG	The Activity Management Transaction Segment file stores the user analysis values associated with an Activity Management…	AC
ACTRANSERR	No description in the Lawson data dictionary	BR
ACTRANSGL	No description in the Lawson data dictionary	AC
CKPOINT	No description in the Lawson data dictionary	—
GMAWARD	Grant Management Award	GM
GMCOSTSHR	Grant Management Cost Share	GM
GMDELIV	Grant Sponsor Deliverables	GM
GMGMASEG	No description in the Lawson data dictionary	GM
GMGMHSEG	No description in the Lawson data dictionary	GM
GMLABDISTX	Grant Labor Distribution Dtl	GM
GMPGMINC	Grant Program Income	GM
GMPROTOCOL	Grant Management Protocol	GM
GMRETDISTX	Grant Retro Labor Dist Detail	GM
MXLISTMBR	Attribute List	IF

Referenced files (10)

Table	Description	System
ACHISTDTL	Invoice Detail	BR
ACHISTHDR	Invoice Header	BR
ACINVORD	No description in the Lawson data dictionary	BR
ACPURGE	No description in the Lawson data dictionary	AC
BRMONITOR	No description in the Lawson data dictionary	AC
GMGMASEG	No description in the Lawson data dictionary	GM
GMGMHSEG	No description in the Lawson data dictionary	GM
MXLISTHDR	Attribute List Header	IF
SYSTEMCODE	System Code	IF
WFSETUP	No description in the Lawson data dictionary	WF