MXTMPLEFDT

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 MX205


UPDATED BY
GL20.7 GL20.8 MX06.1 MX06.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MTE-OBJ-TYPE
Element: Obj Type
Alpha 5
Ths file determine the attribute object type. For this fype of template, the object type is always ACCTU.
MX06.1
MTE-TEMPLATE-NAME
Element: Template Name
Alpha 12
This is the name of the template.
MX06.1
MTE-MATRIX-CAT
Element: Matrix Cat
Alpha 12
This is an accounting unit attribute to which to template assigns a value.
MX06.1
MTE-MX-VALUE
Element: Mx Value
Alpha 32
This is the value assigned to the accounting unit attribute by the template.
MX06.1
MTE-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
This is the effective date for the value.
MX06.1


MXTMPLEFDT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MTESET1 OBJ-TYPE
TEMPLATE-NAME
MATRIX-CAT
EFFECTIVE-DATE
AC13.1 AC13.7
AC14.1 AC14.6
AC16.1 AC16.2
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
NAME
RELATED 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


File created: Thu Jun 09 11:18:50 2016

Home
Contact Us



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