Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACRESRT


                              ACRESRT FILE

REFERENCED BY

AC190     AC217     AC40.1    AC40.4    AC41.1    AC41.4
AC42.1    AC46.1    AC54.1    AC540     ACAC.1    BR190
BR20.6    BR40.3    BR43.1    BR46.1    BR46.2    BR46.4
ET530     ET540

UPDATED BY

AC17.2    AC17.3    AC17.4    AC17.5    AC17.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RRT-RESOURCE-TYPE      Alpha 1                                   AC17.2  AC17.3
Element: Resource Type The type of resource.  Valid values       AC17.4  AC17.5
                       include:                                  AC17.6
                       P - AC Person
                       Q - Equipment
                       E - Employee
                       V - Vendor
                       A - Asset
                       P = Person
                       E = Employee
                       V = Vendor
                       Q = Equipment
                       A = Asset

RRT-RESOURCE-CODE      Alpha 10                                  AC17.2  AC17.3
Element: Resource Code The code identifying the resource         AC17.4  AC17.5
                       assigned to the activity or activity      AC17.6
                       group.

RRT-COMPANY            Numeric 4                                 AC17.3  AC17.4
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.

RRT-EMPLOYEE-ASSET     Numeric 10                                AC17.3  AC17.5
Element: Asset         The asset number contains up to ten
                       numeric characters that uniquely
                       identify an asset. Assets are
                       automatically numbered system-wide.

                         ACRESRT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RRTSET1   RESOURCE-TYPE                                          AC17.2  AC17.3
          RESOURCE-CODE                                          AC17.4  AC17.5
          COMPANY                                                AC17.6  AC190
                                                                 AC217   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC46.1  AC54.1
                                                                 AC540   ACAC.1
                                                                 BR190   BR20.6
                                                                 BR40.3  BR43.1
                                                                 BR46.1  BR46.2
                                                                 BR46.4  ET530
                                                                 ET540