Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             AUMXVALDT FILE

This file is used to store the effective date values for attribute unit
attributes.

REFERENCED BY

MX202     MX135

UPDATED BY

GL162     GL20.7    GL20.8    GL20.9

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AVD-OBJ-ID           Numeric 12                                  GL162   GL20.7
Object               This is the unique object identifier.       GL20.8  GL20.9
Identification

AVD-MATRIX-CAT       Alpha 12                                    GL162   GL20.7
Attribute            This is the accounting unit attribute       GL20.8  GL20.9
                     to which a value is assigned.

AVD-MX-VALUE         Alpha 32                                    GL162   GL20.7
Attribute Value      This is the value of the attribute.         GL20.8  GL20.9

AVD-EFFECTIVE-DATE   Numeric 8  (yyyymmdd)                       GL162   GL20.7
Effective Date       This is the date the value takes effect.    GL20.8  GL20.9

                         AUMXVALDT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AVDSET1   OBJ-ID                                                 GL162   GL20.7
          MATRIX-CAT                                             GL20.8  GL20.9
          EFFECTIVE-DATE                                         MX202

AVDSET2   MATRIX-CAT                                             MX202
          EFFECTIVE-DATE
          OBJ-ID

AVDSET3   EFFECTIVE-DATE*
          MATRIX-CAT
          OBJ-ID

AVDSET4   OBJ-ID                                                 MX135
          MATRIX-CAT
          EFFECTIVE-DATE*