Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXTMPLHEDT


                            MXTMPLHEDT FILE

                      Attr Template Header Detail

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

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

UPDATED BY

MX06.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

MTI-MATRIX-CAT         Alpha 12
Element: Matrix Cat    This field contains the attribute name.

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

                         MXTMPLHEDT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MTISET1   OBJ-TYPE                                               AC13.1  AC13.7
          TEMPLATE-NAME                                          AC14.1  AC14.6
                                                                 AC16.1  AC16.2
                                                                 AC16.7  GL20.7
                                                                 GL20.8  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