AC490 – Activity Reconciliation
- System
- Activity Management (AC)
- Type
- Batch program
- Updates
- 8 tables
- References
- 65 tables
AC490 (Activity Reconciliation) is a Lawson Activity Management batch program. It updates ACASNROLE, ACTRANS, ADDRDATA, CKPOINT, MXLISTHDR, MXLISTMBR, RATOTALS and ULTOTALS and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE and 57 more.
About AC490
Run Activity Reconciliation (AC490) to reconcile activity transactions toGeneral Ledger accounts. You can run the report for a range of dates and accounts. A summary version of the report contains account or activity/accountcategory totals. A detail version includes transaction detail and the account or activity/account category totals. It is sorted by activity or account.
Updated files (8)
| Table | Description | System |
|---|---|---|
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACTRANS | Activity Transaction | AC |
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| RATOTALS | Ratio Totals | GL |
| ULTOTALS | No description in the Lawson data dictionary | GL |
Referenced files (65)
| 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 |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATMXVAL | No description in the Lawson data dictionary | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCMPPARAM | Activity Compute Parameters | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCOMMIT | Activity Commitments | AC |
| ACCONSOL | Activity Consolidation | AC |
| ACCTRCATGX | Contract Category Group Dtl | BR |
| ACCUAMT | Activity Currency Amount | AC |
| ACGLCONSL | AC GL Acct Unit Consolidation | AC |
| ACGLMAST | AC GL Acct Unit Master | 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 |
| ACMASTER | Activity Balances | AC |
| ACPERCCMPL | Activity Percent Complete | AC |
| ACPOOLHDR | Allocation Pool Header | AC |
| ACRANGEDTL | Activity Total Range Detail | AC |
| ACRETAIN | No description in the Lawson data dictionary | BR |
| ACROLE | The Activity Management Role file stores resource roles and descriptions. | AC |
| ACSTATUS | Activity Status | AC |
| ACTOTALS | Activity Total Names | AC |
| ACTRANS | Activity Transaction | AC |
| CMPUTE | Compute Statements | GL |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GMAWARD | Grant Management Award | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MLCALMAP | Multi-Book Ledger Calendar Map | ML |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| RWGRPDET | Report Writer Group Detail | GL |
| RWROWDET | RW Row File Detail | GL |
| STRUCTURE | Category Structure | AC |
| SYSTEMCODE | System Code | IF |
| ULPOST | This file is used to store the last posting date and time. | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (17)
ACAC, ACSR, ACTA, API4, GLAC, GLBL, GLRV, IFAC, IFAU, IFCU, IFLU, IFOB, IFSG, IFUP, MLRV, SLSE, SLSU