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 GL146 GL197 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL70.1 GL70.2
GL70.3 GL70.6 GL14.1 GL14.5 GL14.7 GL14.8
GL16.1 GL16.2 GL16.3 GL16.4 GL20.7 GL20.8
GL20.9 MX00.1 MX00.2 MX00.3 MX05.1 MX05.2
MX10.1 MX10.2 MX135 MX20.1 MX20.2 MX20.4
MX20.5 MX205 SL40.1


UPDATED BY
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 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL14.1 GL14.5
GL14.7 GL14.8
GL16.1 GL16.2
GL16.3 GL16.4
GL20.7 GL20.8
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


MXTMPLEFDT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Mxtpefdtau MXTPEFDTAU
MTE-OBJ-TYPE->TEU-OBJ-TYPE
MTE-TEMPLATE-NAME->TEU-TEMPLATE-NAME
MTE-MATRIX-CAT->TEU-MATRIX-CAT
MTE-EFFECTIVE-DATE->TEU-EFFECTIVE-DATE
  TEU-ACTION
  TEU-DATE
  TEU-TIME
  TEU-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.