Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACIFRESC


                             ACIFRESC FILE

                      Activity Resource Interface

This file contains resource import information from AC520 (Resource Import).

UPDATED BY

AC52.1    AC520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AFR-RUN-GROUP          Alpha 15                                  AC52.1
Element: Run Group     Key field. This is the run group for
                       the import information.

AFR-SEQ-NUMBER         Numeric 6                                 AC52.1
Record Sequence        A unique numeric identifier for
Number                 interfaced record.

AFR-OLD-ACT-GRP        Alpha 35                                  AC52.1
Element: Old Activity GThis field will contain the name of the
                       activity group the resource will be
                       assigned to.

AFR-OLD-ACTIVITY       Alpha 35                                  AC52.1
Element: Old Activity  This field will contain the name of the
                       activity that the resources will be
                       assigned to.

AFR-RESOURCE-TYPE      Alpha 1                                   AC52.1
Element: Resource Type Key field. This is the type for the
                       resource. Use E for employee, P for AC
                       person, Q for AC equipment, A for asset
                       , and V for vendor.
                       A = Asset
                       P = AC Person
                       E = Employee
                       V = Vendor
                       Q = Equipment

AFR-RESOURCE-CODE      Alpha 10                                  AC52.1
Element: Resource Code Key field. This is the code for the
                       resource. Use E for employee, P for AC
                       person, Q for AC equipment, A for asset
                       , and V for vendor.

AFR-LAST-NAME          Alpha 30  (Lower Case)                    AC52.1
Element: Last Name     This is the last name for the resource.

AFR-FIRST-NAME         Alpha 15  (Lower Case)                    AC52.1
Element: First Name    This is the first name for the
                       resource.

AFR-MIDDLE-INIT        Alpha 1                                   AC52.1
Element: Middle InitialThis is the middle initial for the
                       resource.

AFR-COMPANY            Numeric 4                                 AC52.1
Element: Company       This is the company for the resource.
                       This field is required if the Resource
                       Type is Human Resources employee or
                       vendor.

AFR-TITLE              Alpha 30  (Lower Case)                    AC52.1
Element: Title         This is the title for the resource.

AFR-PHONE-COUNTRY      Alpha 6                                   AC52.1
Telephone Country      This is the country code for the
Code                   resource person's telephone number.

AFR-PHONE              Alpha 15                                  AC52.1
Element: Telephone NumbThis is the resource person's telephone
                       number.

AFR-PHONE-EXT          Alpha 5                                   AC52.1
Element: Telephone ExteThis is the resource person's telephone
                       number.

AFR-E-MAIL-ADDR        Alpha 60                                  AC52.1
Element: E Mail Addr   This is E-mail for the resource person.

AFR-EMPLOYEE-ASSET     Numeric 10                                AC52.1
Element: Asset Number  This field contains the Lawson Human
                       Resources employee number (9 digits) or
                       the Lawson Asset Management asset number
                       (10 digits). The field is required for
                       the Asset and HR Employee resource
                       types.

AFR-ROLE               Alpha 12                                  AC52.1
Element: Role          The code that identifies a role that a
                       resource has in relation to activities.

AFR-DESCRIPTION        Alpha 30  (Lower Case)                    AC52.1  AC520
Element: Description   Required. This is the resource
                       description.

AFR-STD-RATE           Signed 13.5                               AC52.1
Element: Std Rate      This field contains the standard cost
                       rate for the resource.

AFR-UNIT-MEASURE       Alpha 12                                  AC52.1
Element: Unit Measure  This is the unit of measure code. It
                       must be a valid unit of measure code
                       defined in the ACUOM (Activity Unit of
                       Measure) file. This field is required if
                       you enter a standard rate.

AFR-TO-COMPANY         Numeric 4                                 AC52.1
Element: Company       This is the post-to company for the
                       default expense account.

AFR-ACCT-UNIT          Alpha 15                                  AC52.1
Element: Accounting UniThis is the accounting unit for the
                       default expense account.

AFR-ACCOUNT            Numeric 6                                 AC52.1
Element: Account       This is the account for the default
                       expense account.

AFR-SUB-ACCT           Numeric 4                                 AC52.1
Element: Subaccount    This is the subaccount for the default
                       expense account.

AFR-MATRIX-CAT         Alpha 12                                  AC52.1
Element: Attribute     Attribute name assigned to an object
                       (like accounting unit) to track
                       additional information.  Attribute
                       values may then be used in selection and
                       sorting for report and analysis.

AFR-MX-VALUE           Alpha 32                                  AC52.1
Element: Attribute ValuThe attribute value.

AFR-BEGIN-DATE         Numeric 8  (yyyymmdd)                     AC52.1
Element: Begin Date    The begin date for this effort period.

AFR-END-DATE           Numeric 8  (yyyymmdd)                     AC52.1
Element: Ending Date   The end date for this effort period.

AFR-CURRENCY-CODE      Alpha 5                                   AC52.1
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

AFR-UPDATE-FLAG        Alpha 1                                   AC52.1
Element: Update Flag

AFR-MATRIX-LIST        Alpha 12                                  AC52.1
Element: Attribute ListAttribute categories are selection
                       parameters used to build a list of
                       objects (accounting units). Attribute
                       categories and values are the basis of
                       the selection and sorting. A attribute
                       list can then be used for reporting on
                       and processing objects.


AFR-DELETE-FLAG        Alpha 1                                   AC52.1
Element: Delete Flag

AFR-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     AC52.1
Element: Effective DateThe effective date for the rate
                       assignment for the resource.

AFR-BILL-RATE          Signed 13.4                               AC52.1
Element: Bill Rate     Billing rate for the resource.

AFR-ACTIVE-FLAG        Alpha 1                                   AC52.1
Element: Status        The status of the rate assignment for
                       this resource.

                         ACIFRESC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AFRSET1   RUN-GROUP                                              AC52.1  AC520
          SEQ-NUMBER