Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXTMPLEFDT


                            MXTMPLEFDT FILE

                      Attr Template Effective Date

This file stores the detail records for the attribute value effective date
attribute templates. The file is updated by Attribute Value Effective Date
Template  (MX06.1).

REFERENCED BY

AC13.1    AC13.7    AC14.1    AC14.6    AC16.1    AC16.2
AC16.7    GL20.7    GL20.8    MX205

UPDATED BY

MX06.1    MX06.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MTE-OBJ-TYPE           Alpha 5                                   MX06.1
Element: Obj Type      Ths file determine the attribute object
                       type. For this fype of template, the
                       object type is always ACCTU.

MTE-TEMPLATE-NAME      Alpha 12                                  MX06.1
Element: Template Name This is the name of the template.

MTE-MATRIX-CAT         Alpha 12                                  MX06.1
Element: Matrix Cat    This is an accounting unit attribute to
                       which to template assigns a value.

MTE-MX-VALUE           Alpha 32                                  MX06.1
Element: Mx Value      This is the value assigned to the
                       accounting unit attribute by the
                       template.

MTE-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     MX06.1
Element: Effective DateThis is the effective date for the
                       value.

                         MXTMPLEFDT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MTESET1   OBJ-TYPE                                               AC13.1  AC13.7
          TEMPLATE-NAME                                          AC14.1  AC14.6
          MATRIX-CAT                                             AC16.1  AC16.2
          EFFECTIVE-DATE                                         AC16.7  GL20.7
                                                                 GL20.8  MX06.1
                                                                 MX06.2  MX205

MTESET3   OBJ-TYPE
          MATRIX-CAT
          EFFECTIVE-DATE
          TEMPLATE-NAME

                         MXTMPLEFDT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Matrix Cat     MXCATDEF     Required

                            MTE-MATRIX-CAT       -> MXC-MATRIX-CAT  (MXCSET1)

Mxtmplhedt     MXTMPLHEDT   Required

                            MTE-OBJ-TYPE         -> MTI-OBJ-TYPE
                            MTE-TEMPLATE-NAME    -> MTI-TEMPLATE-NAME