MXTMPLDTL

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 AC16.1 AC16.2 AC560 AM23.1
AP03.1 AR23.1 AR501 AR550 CB01.4 GL146
GL197 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8
GL44.1 GL45.1 GL70.1 GL70.2 GL70.3 GL70.6
GL124 GL125 GL14.1 GL14.5 GL14.7 GL14.8
GL16.1 GL16.2 GL16.3 GL16.4 GL20.1 GL20.7
GL20.8 GL20.9 MX00.1 MX00.2 MX00.3 MX06.1
MX06.2 MX10.1 MX10.2 MX135 MX20.1 MX20.2
MX20.4 MX20.5 MX205 SL00.5 SL40.1


UPDATED BY
MX05.1 MX05.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MTD-OBJ-TYPE
Element: Object Type
Alpha 5
This field determines the type of object used by the Attribute. These values are not user maintainable.
MX05.1
MTD-TEMPLATE-NAME
Element: Template Name
Alpha 12
The name associated with the attribute template.
MX05.1
MTD-MATRIX-CAT
Element: Matrix Category
Alpha 12
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.
MX05.1
MTD-MX-VALUE
Element: Matrix Value
Alpha 32
The category value assigned to the object.
MX05.1


MXTMPLDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MTDSET1 OBJ-TYPE
TEMPLATE-NAME
MATRIX-CAT
...
AC13.1 AC14.1
AC16.1 AC16.2
AC560 AM23.1
AP03.1 AR23.1
AR501 AR550
CB01.4 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL124 GL125
GL14.1 GL14.5
GL14.7 GL14.8
MTDSET2 OBJ-TYPE
MATRIX-CAT
TEMPLATE-NAME


MXTMPLDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


MXTMPLDTL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Mxtmpdtlau MXTMPDTLAU
MTD-OBJ-TYPE->TDA-OBJ-TYPE
MTD-TEMPLATE-NAME->TDA-TEMPLATE-NAME
MTD-MATRIX-CAT->TDA-MATRIX-CAT
  TDA-ACTION
  TDA-DATE
  TDA-TIME
  TDA-UNIQUE-I-D


File created: Thu Jun 09 02:21:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.