MXTMPLEFDT FILE
This file stores the detail records for the attribute value effective date
attribute templates. The file is updated by Attribute Value Effective Date
Template (MX06.1).
REFERENCED BY
AC13.1 AC13.7 GL20.7 GL20.8 MX205
UPDATED BY
MX06.1 MX06.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MTE-OBJ-TYPE Alpha 5 MX06.1
Object Type Ths file determine the attribute object
type. For this fype of template, the
object type is always ACCTU.
MTE-TEMPLATE-NAME Alpha 12 MX06.1
Template Name This is the name of the template.
MTE-MATRIX-CAT Alpha 12 MX06.1
Attribute This is an accounting unit attribute to
which to template assigns a value.
MTE-MX-VALUE Alpha 32 MX06.1
Attribute Value This is the value assigned to the
accounting unit attribute by the
template.
MTE-EFFECTIVE-DATE Numeric 8 (yyyymmdd) MX06.1
Effective Date This is the effective date for the
value.
MXTMPLEFDT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MTESET1 OBJ-TYPE AC13.1 AC13.7
TEMPLATE-NAME GL20.7 GL20.8
MATRIX-CAT MX06.1 MX06.2
EFFECTIVE-DATE MX205
MTESET2 OBJ-TYPE
EFFECTIVE-DATE
MATRIX-CAT
TEMPLATE-NAME
MTESET3 OBJ-TYPE
MATRIX-CAT
EFFECTIVE-DATE
TEMPLATE-NAME
MXTMPLEFDT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Matrix Cat MXCATDEF Required
MTE-MATRIX-CAT -> MXC-MATRIX-CAT (MXCSET1)
Mxtmplhedt MXTMPLHEDT Required
MTE-OBJ-TYPE -> MTI-OBJ-TYPE
MTE-TEMPLATE-NAME -> MTI-TEMPLATE-NAME
|