Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            MXTMPLHEDT FILE

This file contain the header records for the attribute value effective date
templates.  It is updated by Define Attibute Value Effective Date Template
(MX06.2).

REFERENCED BY

GL20.7    GL20.8    MX205

UPDATED BY

MX06.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MTI-OBJ-TYPE         Alpha 5                                     MX06.2
Object Type          This field determines the object type
                     associated with the tempalte. The object
                     type is always ACCTU.

MTI-TEMPLATE-NAME    Alpha 12                                    MX06.2
Template Name        This field contains the name of the
                     template.

MTI-MATRIX-CAT       Alpha 12
Attribute            This field contains the attribute name.

MTI-DESCRIPTION      Alpha 30  (Lower Case)                      MX06.2
Description          This field contains the attribute
                     description.

                         MXTMPLHEDT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MTISET1   OBJ-TYPE                                               GL20.7  GL20.8
          TEMPLATE-NAME                                          MX06.1  MX06.2
                                                                 MX205

                         MXTMPLHEDT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Object Id      OBJID        Required

                            MTI-OBJ-TYPE         -> OBI-OBJ-TYPE

                         MXTMPLHEDT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxtmplefdt     MXTMPLEFDT   Delete Cascades

                            MTI-OBJ-TYPE         -> MTE-OBJ-TYPE
                            MTI-TEMPLATE-NAME    -> MTE-TEMPLATE-NAME
                                                    MTE-MATRIX-CAT
                                                    MTE-EFFECTIVE-DATE