Lawson Insight Technical Documentation

                             ACRESRTX FILE

REFERENCED BY

AC217     AC170     AC190     AC40.1    AC40.4    AC41.1
AC41.4    AC42.1    AC530     AC54.1    AC540     AC70.1
AC70.4    ACAC.1    BR40.3

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
Resource Type        P = Person                                  AC17.4  AC17.5
                     E = Employee                                AC17.6
                     V = Vendor
                     Q = Equipment
                     A = Asset

RRX-RESOURCE-CODE    Alpha 10                                    AC17.2  AC17.3
Resource Code                                                    AC17.4  AC17.5
                                                                 AC17.6

RRX-COMPANY          Numeric 4                                   AC17.3  AC17.4
Company              The company number represents an
                     established company and is entered on
                     all function codes.

RRX-EMPLOYEE-ASSET   Numeric 10                                  AC17.3  AC17.5
Employee Asset

RRX-EFFECTIVE-DATE   Numeric 8  (yyyymmdd)                       AC17.2  AC17.3
Effective Date       The 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
Std Rate                                                         AC17.4  AC17.5
                                                                 AC17.6

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

RRX-CURRENCY-CODE    Alpha 5                                     AC17.2  AC17.3
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
Bill Rate                                                        AC17.4  AC17.5
                                                                 AC17.6

RRX-ACTIVE-FLAG      Alpha 1                                     AC17.2  AC17.3
Status               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                                AC170   AC190
          RESOURCE-TYPE                                          AC40.1  AC40.4
          RESOURCE-CODE                                          AC41.1  AC41.4
          COMPANY                                                AC42.1  AC530
          EFFECTIVE-DATE*                                        AC54.1  AC540
                                                                 AC70.1  AC70.4
                                                                 ACAC.1  BR40.3

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