Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACRESOURCE


                            ACRESOURCE FILE

                           Activity Resource

This file contains resource definition information from AC03.1 (Resource). It
includes resource code, type, description, standard cost, resource class, as
well as resource names, title, telephone number, and E-mail address.

REFERENCED BY

AC145     AC17.2    AC17.6    AC18.1    AC18.5    AC210
AC217     AC218     AC240     AC295     AC41.1    AC41.4
AC42.1    AC46.1    AC50.1    AC500     AC52.1    AC54.1
AC540     AC69.2    AC92.2    AC92.4    AC92.6    ACAC.1
BR40.3    BR43.1    BR46.1    ET530     ET540     PW110
PW510

UPDATED BY

AC03.1    AC520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RSC-RESOURCE-CODE      Alpha 10                                  AC03.1  AC520
Element: Resource Code Required key. This code identifies a
                       personnel or equipment resource assigned
                       to an activity. The resource must first
                       be defined in HR11 (Employee) or AC03.1
                       (Resource).

RSC-RESOURCE-TYPE      Alpha 1                                   AC03.1  AC520
Element: Resource Type This is the resource type, indicating
                       whether the resource is equipment or a
                       person.
                       Q = Equipment
                       P = Person

RSC-DESCRIPTION        Alpha 30  (Lower Case)                    AC03.1  AC217
Element: Resource DescrRequired. This is the description of      AC218   AC520
                       the resource.

RSC-LAST-NAME          Alpha 30  (Lower Case)                    AC03.1  AC217
Element: Last Name     Required. This is the last name of the    AC218   AC520
                       personnel resource.

RSC-FIRST-NAME         Alpha 15  (Lower Case)                    AC03.1  AC217
Element: First Name    Required. This is the first name of the   AC218   AC520
                       personnel resource.

RSC-MIDDLE-INIT        Alpha 1                                   AC03.1  AC520
Element: Middle InitialOptional. This is the middle initial of
                       the personnel resource.

RSC-TITLE              Alpha 30  (Lower Case)                    AC03.1  AC520
Element: Title         Optional. This is the title of the
                       personnel resource.

RSC-PHONE-COUNTRY      Alpha 6                                   AC03.1  AC520
Element: Telephone (CouOptional. This is the prefix of the
                       telephone number for the resource. For
                       example, the country or city telephone
                       code.

RSC-PHONE              Alpha 15                                  AC03.1  AC520
Element: Phone         This is the telephone number.

RSC-PHONE-EXT          Alpha 5                                   AC03.1  AC520
Element: Telephone ExteOptional. This is the telephone
                       extension for the resource.

RSC-E-MAIL-ADDR        Alpha 60                                  AC03.1  AC520
Element: Email Address This is the E-mail address for the
                       resource.

RSC-COMPANY            Numeric 4                                 AC03.1  AC520
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

RSC-ACCT-UNIT          Alpha 15                                  AC03.1  AC520
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


RSC-ACCOUNT            Numeric 6                                 AC03.1  AC520
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

RSC-SUB-ACCT           Numeric 4                                 AC03.1  AC520
Element: Sub Acct      This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

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

                         ACRESOURCE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RSCSET1   RESOURCE-CODE                                          AC03.1  AC03.2
          RESOURCE-TYPE                                          AC03.6  AC03.7
                                                                 AC145   AC17.2
                                                                 AC17.6  AC18.1
                                                                 AC18.5  AC210
                                                                 AC217   AC218
                                                                 AC240   AC295
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC46.1
                                                                 AC50.1  AC500
                                                                 AC52.1  AC520
                                                                 AC54.1  AC540
                                                                 AC69.2  AC92.2
                                                                 AC92.4  AC92.6
                                                                 ACAC.1  BR40.3
                                                                 ...

RSCSET2   LAST-NAME     KeyChange                                AC03.1
          FIRST-NAME
          MIDDLE-INIT
          RESOURCE-CODE
          RESOURCE-TYPE

                         ACRESOURCE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acassign       ACASSIGN

                            Zeroes               -> AAN-COMPANY
                            RSC-RESOURCE-CODE    -> AAN-RESOURCE-CODE
                            RSC-RESOURCE-TYPE    -> AAN-RESOURCE-TYPE
                                                    AAN-ACTIVITY-GRP
                                                    AAN-ACTIVITY

Acresrtx       ACRESRTX

                            RSC-RESOURCE-TYPE    -> RRX-RESOURCE-TYPE
                            RSC-RESOURCE-CODE    -> RRX-RESOURCE-CODE
                                                    RRX-COMPANY
                                                    RRX-EFFECTIVE-DATE