Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             MXTMPLDTL FILE

                       Attribute Template Detail

This file contains attribute template detail records including the object
type, template name, attribute, and attribute value. Templates are used to
group several attribute categories together and defined in MX05.1 (Attribute
Template).


REFERENCED BY

AC13.1    AM23.1    GL124     GL14.1    GL14.7    GL16.1
GL16.2    GL20.1    GL20.7    MX205

UPDATED BY

MX05.1    MX05.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MTD-OBJ-TYPE         Alpha 5                                     MX05.1
Object Type          This field determines the type of
                     object used by the Attribute. These
                     values are not user maintainable.


MTD-TEMPLATE-NAME    Alpha 12                                    MX05.1
Template Name        The name associated with the attribute
                     template.


MTD-MATRIX-CAT       Alpha 12                                    MX05.1
Matrix Category      Attribute name assigned to an object
                     (like an accounting unit) to track
                     additional information.  Attribute
                     values are used in selection and sorting
                     for reporting and analysis.


MTD-MX-VALUE         Alpha 32                                    MX05.1
Matrix Value         The category value assigned to the
                     object.


                         MXTMPLDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MTDSET1   OBJ-TYPE                                               AC13.1  AM23.1
          TEMPLATE-NAME                                          GL124   GL14.1
          MATRIX-CAT                                             GL14.7  GL16.1
                                                                 GL16.2  GL20.1
                                                                 GL20.7  MX05.1
                                                                 MX05.2  MX205

MTDSET2   OBJ-TYPE
          MATRIX-CAT
          TEMPLATE-NAME

                         MXTMPLDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Matrix Cat     MXOBJCAT     Required

                            MTD-OBJ-TYPE         -> MOC-OBJ-TYPE  (MOCSET1)
                            MTD-MATRIX-CAT       -> MOC-MATRIX-CAT

Mxtmplhdr      MXTMPLHDR    Required

                            MTD-OBJ-TYPE         -> MTH-OBJ-TYPE
                            MTD-TEMPLATE-NAME    -> MTH-TEMPLATE-NAME

Objid          OBJID        Not Required

                            MTD-OBJ-TYPE         -> OBI-OBJ-TYPE