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

AC131     AC17.2    AC17.6    AC18.1    AC18.5    AC210
AC217     AC218     AC240     AC295     AC297     AC41.1
AC41.4    AC42.1    AC50.1    AC500     AC52.1    AC54.1
AC540     AC92.2    AC92.4    AC92.6    ACAC.1    BR40.3
BR43.1    BR430

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-RESOURCE-CLASS     Alpha 3                                   AC03.1  AC520
Element: Resource ClassThis is the resource class for the
                       activity 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       The company number represents an
                       established company and is entered on
                       all function codes.

RSC-ACCT-UNIT          Alpha 15                                  AC03.1  AC520
Element: Accounting UniThe 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: Subaccount    This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

                         ACRESOURCE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RSCSET1   RESOURCE-CODE                                          AC03.1  AC03.2
          RESOURCE-TYPE                                          AC03.6  AC131
                                                                 AC17.2  AC17.6
                                                                 AC18.1  AC18.5
                                                                 AC210   AC217
                                                                 AC218   AC240
                                                                 AC295   AC297
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC50.1
                                                                 AC500   AC52.1
                                                                 AC520   AC54.1
                                                                 AC540   AC92.2
                                                                 AC92.4  AC92.6
                                                                 ACAC.1  BR40.3
                                                                 BR43.1  BR430

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

                         ACRESOURCE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acresclass     ACRESCLASS   Not Required

                            RSC-RESOURCE-TYPE     -> RCL-RESOURCE-TYPE
                            RSC-RESOURCE-CLASS    -> RCL-RESOURCE-CLASS

                         ACRESOURCE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acassign       ACASSIGN

                            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