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    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
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 20                                    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                                          GL20.1  GL20.7
          MATRIX-CAT                                             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