Lawson Insight Technical Documentation

                             ACRESRTX FILE

REFERENCED BY

AC217     AC190     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

RRX-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

RRX-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.

RRX-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.

RRX-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.

RRX-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     AC17.2  AC17.3
Element: Effective DateThe date a vendor's prices will be in     AC17.4  AC17.5
                       effect.                                   AC17.6

RRX-STD-RATE           Signed 13.5                               AC17.2  AC17.3
Element: Std Rate                                                AC17.4  AC17.5
                                                                 AC17.6

RRX-UNIT-MEASURE       Alpha 12                                  AC17.2  AC17.3
Element: Unit Measure                                            AC17.4  AC17.5
                                                                 AC17.6

RRX-CURRENCY-CODE      Alpha 5                                   AC17.2  AC17.3
Element: Currency Code This field contains the company base      AC17.4  AC17.5
                       currency code established in Company      AC17.6
                       (GL10.1 ).

RRX-BILL-RATE          Signed 13.4                               AC17.2  AC17.3
Element: Bill Rate     The billing rate that is set up for a     AC17.4  AC17.5
                       resource for a specific activity.         AC17.6

RRX-ACTIVE-FLAG        Alpha 1                                   AC17.2  AC17.3
Element: Active Flag   The Active flag of the credit card        AC17.4  AC17.5
                       type.                                     AC17.6
                       A = Active
                       I = Inactive

                         ACRESRTX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RRXSET1   RESOURCE-TYPE                                          AC17.2  AC17.3
          RESOURCE-CODE                                          AC17.4  AC17.5
          COMPANY                                                AC17.6  AC217
          EFFECTIVE-DATE

RRXSET2   ACTIVE-FLAG   KeyChange                                AC190   AC40.1
          RESOURCE-TYPE                                          AC40.4  AC41.1
          RESOURCE-CODE                                          AC41.4  AC42.1
          COMPANY                                                AC46.1  AC54.1
          EFFECTIVE-DATE*                                        AC540   ACAC.1
                                                                 BR190   BR20.6
                                                                 BR40.3  BR43.1
                                                                 BR46.1  BR46.2
                                                                 BR46.4  ET530
                                                                 ET540

RRXSET3   RESOURCE-TYPE KeyChange
          EMPLOYEE-ASSET
          COMPANY
          EFFECTIVE-DATE
          RESOURCE-CODE