AC50.1 - Activity Interface Adjustment
Use AC50.1 (Activity Interface Adjustment) to adjust activity information
that you want to import from your existing non-Lawson system to the Activity
Management system. AC500 (Activity Import) uses the data from this program
during the import process. This import allows the addition of new activities,
a manager resource, and up to ten activity attributes.
Use a transfer utility program (such as the winptxfr or ftp command) to
transfer the non-Lawson file to the target machine. When you transfer the
non-Lawson file, you rename the file. For example, if you are transferring
from Excel, use:
winptxfr -u filename c:\\Data\\Excel\\filename
where the filename is the Lawson Activity Import file.
Use an Import command such as:
importdb productline ACIFACTV filename
where the filename is the name you assigned when you transferred the file
to the Lawson system
to load the activity import file into the ACIFACTV file for use in this
program.
If you are adding activities that have revenue history or billed history
(prior to going up on Lawson), you must update the fields on the Bill Totals
form tab on AC50.1.
If you are adding or changing an activity record that will be imported to a
General Ledger-only activity group, the only fields required on AC50.1 are
Activity, Activity Description, and Old Activity Group.
Updated Files
ACIFACTV - This is the primary file maintained by this program. Maintains
the activity information to be imported to Activity Management
system.
CKPOINT - Used for restart capability.
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.
ACACTGPREL - References this file to validate the old activity group and
determine the activity group.
ACACTGRP - References this file to validate the activity group.
ACACTIVITY - References this file to validate the activity does not already
exist.
ACACTREL - References this file to validate the old activity and
determine the
activity.
ACADDRESS - References this file to validate the activity address.
ACAMCODE -
ACASSIGN - References this file to validate the activity resource
assignment.
ACAUDIT - References this file to validate the activities in the audit
file in the process of being copied or moved.
ACBILL -
ACBLMAST -
ACCNTRACT -
ACCNTRACTX -
ACCOLGRP -
ACCOLGRPX -
ACCOMMIT -
ACLEVEL - References this file to validate the activity level does not
already exist and validate a parent activity exists for this
activity group.
ACRESCLASS - References this file to validate the resource class.
ACRESOURCE - References this file to validate the Activity Management
person resource being assigned as the activity manager.
ACSTATUS - References this file to validate the activity status.
ACTRANS -
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.
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.
MXOBJCAT - This file is used by a common routine that is used by this
program.
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.
INVOKED Programs
API4
ACAC
ACCL
IFCU
IFSG
IFAC
IFAU
SLSE
SLSU
HRFN
|