Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             AUMXCONV FILE

                     Acct Unit Attribute Conversion

The Accounting Unit Attribute Conversion file contains the information needed
to maintain accounting unit attribute information defined in GL62.1 (AU
Attribute Interface Maint).


REFERENCED BY

GL262

UPDATED BY

GL162     GL62.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AUC-RUN-GROUP        Alpha 15                                    GL62.1
Run Group            The name you assigned when you
                     transferred the non-Lawson file to the
                     target machine.


AUC-OLD-COMPANY      Alpha 35                                    GL62.1
Old Company          The old company structure associated
                     with the Lawson Company/Accounting Unit.



AUC-MATRIX-CAT       Alpha 12                                    GL62.1
Matrix Category      Attribute name assigned to an object
                     (like an accounting unit) to track
                     additional information.  Attribute
                     values may then be used in selection and
                     sorting for reporting and analysis.


AUC-MX-VALUE         Alpha 32                                    GL62.1
Matrix Value         The valid value for the Attribute.

AUC-EFFECTIVE-DATE   Numeric 8  (yyyymmdd)                       GL62.1
Effective Date       The date a vendor's prices will be in
                     effect.

                         AUMXCONV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AUCSET1   RUN-GROUP                                              GL162   GL262
          OLD-COMPANY                                            GL62.1
          MATRIX-CAT
          EFFECTIVE-DATE

AUCSET2   MATRIX-CAT
          OLD-COMPANY
          RUN-GROUP
          EFFECTIVE-DATE

AUCSET3   OLD-COMPANY
          RUN-GROUP
          MATRIX-CAT
          EFFECTIVE-DATE

                         AUMXCONV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glcomprel      GLCOMPREL    Not Required

                            AUC-OLD-COMPANY    -> GCR-OLD-COMPANY  (GCRSET1)

                         AUMXCONV FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxobjcat       MXOBJCAT

                            AUC-MATRIX-CAT     -> MOC-MATRIX-CAT
                                                  MOC-OBJ-TYPE