Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXTMPLDTL


                             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    AC14.1    AM23.1    AP03.1    AR23.1    AR501
AR515     AR550     CB01.4    GL124     GL14.1    GL14.7
GL16.1    GL16.2    GL20.1    GL20.7    MX205     SL00.5

UPDATED BY

MX05.1    MX05.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MTD-OBJ-TYPE           Alpha 5                                   MX05.1
Element: 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
Element: Template Name The name associated with the attribute
                       template.


MTD-MATRIX-CAT         Alpha 12                                  MX05.1
Element: Matrix CategorAttribute 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
Element: 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  AC14.1
          TEMPLATE-NAME                                          AM23.1  AP03.1
          MATRIX-CAT                                             AR23.1  AR501
                                                                 AR515   AR550
                                                                 CB01.4  GL124
                                                                 GL14.1  GL14.7
                                                                 GL16.1  GL16.2
                                                                 GL20.1  GL20.7
                                                                 MX05.1  MX05.2
                                                                 MX205   SL00.5

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