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

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
AM23.1 AP03.1
AR23.1 AR501
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
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


File created: Wed Jun 08 20:49:46 2016

Home
Contact Us



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