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     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
Element: Attribute     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: Attribute ValuThis is the value of the attribute.       GL20.8  GL20.9

AVD-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     GL162   GL20.7
Element: 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*