AC500 – Activity Interface

System: Activity Management (AC)
Type: Batch program
Updates: 17 tables
References: 33 tables

AC500 (Activity Interface) is a Lawson Activity Management batch program. It updates ACACRESRT, ACACRESRTX, ACACTIVITY, ACACTMXVAL, ACACTREL, ACACTSEG, ACADDASSGN, ACASNROLE and 9 more and references ACACCTCAT, ACACCTCATX, ACACTCOPY, ACACTGPREL, ACACTGRP, ACADDRESS, ACAUDIT, ACBILL and 25 more.

About AC500

Run Activity Interface (AC500) to import activity information from a non-Lawson system to Project Accounting. The activity import adds new activities, a manager resource for an activity, up to ten activity attributes, and grant award information (if applicable). Use Activity Interface Adjustment (AC50.1) to view and edit your imported records. NOTE If you need to assign a manager resource to an activity group, use Resource Interface Adjustment (AC52.1) and Resource Interface (AC520). **Processing Effect For UNIX/Windows platforms: The data is stored in the ACIFACTV (Activity Import) file. When you run AC500, it updates the ACACTIVITY (Activity), ACLEVEL (Activity Levels), ACASSIGN (Activity Resource Assignment), ACADDASSGN (Activity Address Assignment), and ACACTMXVAL (Activity List Attribute Values) files. For the System i platform: The data is stored in the DBACAIV (Activity Import) file. When you run AC500, it updates the DBACACV (Activity), DBACLVL (Activity Levels), DBACAAN (Activity Resource Assignment), DBACAAS (Activity Address Assignment), and DBACAJV (Activity List Attribute Values) files.

Updated files (17)

Table	Description	System
ACACRESRT	Resource Standard Cost	AC
ACACRESRTX	AC Resource Standard Cost Dtl	AC
ACACTIVITY	Activity	AC
ACACTMXVAL	Activity List Attribute Values	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
ACASNROLE	The Assignment Role file will store the roles associated with a resource assignment.	AC
ACASSIGN	Activity Resource Assignment	AC
ACCNTRACTX	Activity Contract Detail	BR
ACHISTORY	Activity Audit	AC
ACIFACTV	This file contains activity import information from AC500 (Activity Import).	AC
ADDRDATA	Address Code	IF
CKPOINT	No description in the Lawson data dictionary	—
GMCOSTSHR	Grant Management Cost Share	GM
MXLISTHDR	Attribute List Header	IF
MXOBJCAT	Attribute Object	IF

Referenced files (33)

Table	Description	System
ACACCTCAT	Activity Account Categories	AC
ACACCTCATX	Account Category Detail	AC
ACACTCOPY	This file contains parameters used to mass copy activities from existing activity structures.	AC
ACACTGPREL	Activity Group Relation	AC
ACACTGRP	Activity Group	AC
ACADDRESS	Activity Address	AC
ACAUDIT	Activity Audit	AC
ACBILL	Activity Billing	BR
ACBILLX	Activity Billing Detail	BR
ACBLMAST	Activity Billing Balances	BR
ACCATSUMX	Account Category Summ Detail	AC
ACCNTRACT	Activity Contract	BR
ACRESOURCE	Activity Resource	AC
ACROLE	The Activity Management Role file stores resource roles and descriptions.	AC
ACSTATUS	Activity Status	AC
ACUOM	Activity Unit of Measure	AC
ACWBSCODE	No description in the Lawson data dictionary	BR
APCOMPANY	Accounts Payable Company	AP
APVENGROUP	Vendor Group	AP
EMPLOYEE	Employee	HR
GLADDRESS	General Ledger Company Address	IF
GLCHART	General Ledger Chart	IF
GLSYSTEM	General Ledger Company	IF
GMCOSTSHR	Grant Management Cost Share	GM
GMSALCAP	Grant Salary Cap Schedule	GM
HRSECLEV	Employee Security Level	HR
INSTCTRYCD	Intrastat Country Codes	TX
MXCATDEF	Attribute Definition	IF
MXELEMENT	Attribute Element	IF
MXLISTMBR	Attribute List	IF
MXVALIDATE	Attribute Validation	IF
PRSYSTEM	HR Company and Process Levels	HR
WFSETUP	No description in the Lawson data dictionary	WF

Program calls

Invoked programs (12)

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