Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            MXTMPLEFDT FILE

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    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
Object 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
Template Name        This is the name of the template.

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

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

MTE-EFFECTIVE-DATE   Numeric 8  (yyyymmdd)                       MX06.1
Effective Date       This 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                                          GL20.7  GL20.8
          MATRIX-CAT                                             MX06.1  MX06.2
          EFFECTIVE-DATE                                         MX205

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

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