Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AC500


AC500 - Activity Interface

**Form Purpose
Run Activity Interface (AC500) to import non-Lawson activity information to
the Lawson Project and Activity Accounting application.

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 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 iSeries 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

    ACACRESRT  -

    ACACRESRTX -

    ACACTIVITY - This is the primary file maintained by this program. Maintains
                 activity information.

    ACACTMXVAL - Updates this file with the activity's level values.

    ACACTREL   - References this file to determine the activity name from the
                 old activity name. Also, will create this file if it does not
                 exist.  Creation of the record allows the ability to import
                 resources and attributes at a later time and reference the
                 activity by the old activity name.

    ACACTSEG   -

    ACADDASSGN - References this file to validate that an address assignment
                 record exists. Also, will create a record in this file if the
                 address does not exist.

    ACASNROLE  -

    ACASSIGN   - Updates this file with the activity manager.

    ACBLACTV   -

    ACCNTRACTX -

    ACIFACTV   - This is the primary file maintained by this program. Maintains
                 the activity information to be imported to Activity Management
                 system.  Records in this file are deleted once an activity
                 record is created.

    ADDRDATA   -

    CKPOINT    - Used for restart capability.

    MXLISTHDR  - Updates the Last Build Time and Last Build Date fields on this
                 file.

    MXOBJCAT   - Updates the usage count on the activity object category
                 record.


Referenced Files

    ACACCTCAT  - References this file to validate the account category.

    ACACCTCATX - References this file to validate the account categories
                 assigned to the activity group.

    ACACTCOPY  -

    ACACTGPREL - References this file to validate the old activity group and
                 determine the activity group.

    ACACTGRP   - References this file to validate the activity group.

    ACADDRESS  - References this file to validate the activity address.

    ACAUDIT    - References this file to validate the activities in the audit
                 file in the process of being copied or moved.

    ACBILL     -

    ACBILLX    -

    ACBLMAST   -

    ACCATSUMX  -

    ACCNTRACT  -

    ACCTRCATGX -

    ACRESOURCE - References this file to validate the Activity Management
                 person resource being assigned as the activity manager.

    ACROLE     -

    ACSTATUS   - References this file to validate the activity status.

    ACUOM      - References this file to validate the unit of measure code.

    ACWBSCODE  -

    APCOMPANY  - References this file to validate the Accounts Payable Company
                 for vendor resources assigned as the activity manager.

    APVENGROUP - This file is used by a common routine that is used by this
                 program.

    EMPLOYEE   - References this file to validate the Human Resource employee
                 assigned as the activity manager.

    GLADDRESS  - This file is used by a common routine that is used by this
                 program.

    GLCHART    - This file is used by a common routine that is used by this
                 program.

    GLSYSTEM   - References this file to validate the General Ledger company
                 assigned as the activity's responsible company.

    HRSECLEV   - This file is used by a common routine that is used by this
                 program.

    INSTCTRYCD -

    MXCATDEF   - This file is used by a common routine that is used by this
                 program.

    MXELEMENT  - This file is used by a common routine that is used by this
                 program.

    MXLISTMBR  -

    MXVALIDATE - This file is used by a common routine that is used by this
                 program.

    PRSYSTEM   - References this file to validate the Human Resource company
                 assigned to the employee resource assigned as the activity
                 manager.

    WFSETUP    -


INVOKED Programs

    API4
    ACAC
    ACCL
    ACTA
    IFCU
    IFAC
    IFAU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU