|
|
MXTMPLEFDT FILE
Attr Template Effective Date
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 AC14.1 AC14.6 AC16.1 AC16.2
AC16.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
Element: Obj 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
Element: Template Name This is the name of the template.
MTE-MATRIX-CAT Alpha 12 MX06.1
Element: Matrix Cat This is an accounting unit attribute to
which to template assigns a value.
MTE-MX-VALUE Alpha 32 MX06.1
Element: Mx Value This is the value assigned to the
accounting unit attribute by the
template.
MTE-EFFECTIVE-DATE Numeric 8 (yyyymmdd) MX06.1
Element: Effective DateThis 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 AC14.1 AC14.6
MATRIX-CAT AC16.1 AC16.2
EFFECTIVE-DATE AC16.7 GL20.7
GL20.8 MX06.1
MX06.2 MX205
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
|
