Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AUMXVALDT


                             AUMXVALDT FILE

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

REFERENCED BY

MX202     RW100     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
Element: Obj Id        This is the unique object identifier.     GL20.8  GL20.9

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

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

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

AVD-COMPANY            Numeric 4                                 GL162   GL20.7
Element: Company       Identifies the AP company if the          GL20.8  GL20.9
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

                         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

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