AC310 – Transaction Consolidation
- System
- Activity Management (AC)
- Type
- Batch program
- Updates
- 14 tables
- References
- 38 tables
AC310 (Transaction Consolidation) is a Lawson Activity Management batch program. It updates ACASNROLE, ACBRDNADJ, ACBRDNADTR, ACBRDNTRAN, ACMONITOR, ACTRANS, ACTRANSEG, ACTRANSGL and 6 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE and 30 more.
About AC310
Run Activity Purge (AC310) to consolidate transactions for an activity or activity group to reduce the number of transactions without removing the activity from the system. The system purges all transactions associated with the activity and creates a consolidation transaction instead; balances are retained for the activity. Budgets associated with the activity can also be removed. You can consolidate transactions into one record based on the lowest level of detail. NOTE You can not consolidate activity transactions unless all associated invoices have already been purged. Use Invoice Purge (BR300) to purgeinvoices. You also can not delete activities that have commitment records associated with them. 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. IMPORTANT Before you run AC310 for update, use the Report Only update option to produce a listing of records to be consolidated or purged.
Updated files (14)
| Table | Description | System |
|---|---|---|
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACBRDNADJ | No description in the Lawson data dictionary | AC |
| ACBRDNADTR | The Burden Additional Transaction file is updated by the Activity Posting (AC190) program. | AC |
| ACBRDNTRAN | The Burden Transactions file is updated by the Activity Posting (AC190) program. | AC |
| ACMONITOR | 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 |
| ACTRANSGL | No description in the Lawson data dictionary | AC |
| CKPOINT | No description in the Lawson data dictionary | — |
| IFMONITOR | No description in the Lawson data dictionary | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| SUBCKPOINT | Subledger Check Point | IF |
Referenced files (38)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACACTMXVAL | Activity List Attribute Values | 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 |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDDTL | Activity Budget | AC |
| ACBUDHDR | Activity Budget Header | AC |
| ACBUDRATE | Activity Budget Rate | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATMXVAL | No description in the Lawson data dictionary | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCHGORDER | Activity Change Order | AC |
| ACCHGORDX | Activity Change Order Detail | AC |
| ACCLGTRANS | Ceiling Level Transactions | BR |
| ACCNTRACT | Activity Contract | BR |
| ACCTRCATGX | Contract Category Group Dtl | BR |
| ACCUAMT | Activity Currency Amount | AC |
| ACGRPMXVAL | The ACGRPMXVAL file is the primary file updated by AC13. | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACPURGE | No description in the Lawson data dictionary | AC |
| ACROLE | The Activity Management Role file stores resource roles and descriptions. | AC |
| ACSTATUS | Activity Status | AC |
| ACTRANSERR | No description in the Lawson data dictionary | BR |
| GMAWARD | Grant Management Award | GM |
| MXCATDEF | Attribute Definition | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| STRUCTURE | Category Structure | AC |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (13)
ACAC, ACSR, ACTA, API4, IFAC, IFCU, IFIM, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU