MXVALIDATE

Attribute Validation

This file contains the valid values or value ranges that are assigned to the attribute.

REFERENCED BY
AC13.1 AC13.2 AC13.7 AC13.8 AC14.1 AC14.2
AC14.6 AC14.7 AC16.1 AC16.2 AC16.7 AC16.8
AC16.9 AC51.1 AC510 AC55.1 AC558 AC58.3
AC58.4 AM94.1 AP162 AP262 AP62.1 BR03.1
BR03.3 CB01.4 CB01.5 CB162 CB262 CB62.1
CA190 CA210 GL147 GL191 GL240 GL265
GL270 GL55.1 GL123 GL14.5 GL14.7 GL16.1
GL16.2 GL16.3 GL16.4 GL220 GL262 GL62.1
IFBO.1 MX05.1 MX06.1 MX10.1 MX100 MX135
MX201 MX205 MX260 MX60.1 ML170 ML190
ML265 ML270 ML70.1 ML70.2 ML70.3 ML70.6
MLIT.1 RQBL.3 SL00.5 SL00.6 SL40.1


UPDATED BY
AC03.2 AC03.3 AC03.4 AC03.5 AC03.6 AC135
AC213 AC247 AC256 AC290 AC295 AC298
AC40.1 AC40.4 AC41.1 AC41.4 AC410 AC42.1
AC45.1 AC460 AC471 AC472 AC480 AC50.1
AC500 AC52.1 AC520 AC54.1 AC540 AC560
ACAC.1 AM220 AM221 AM222 AM223 AM224
AM225 AM23.1 AM23.2 AM230 AM235 AM240
AM245 AM250 AM255 AM260 AM265 AM275
AM277 AM278 AM280 AM281 AM285 AM290
AM292 AM295 AM500 AP03.1 AP03.2 AR23.1
AR23.2 BR00.3 BR10.7 BR20.6 BR43.1 BR44.1
BR46.1 CA10.2 GL146 GL165 GL170 GL190
GL197 GL256 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL65.1 GL70.1 GL70.2
GL70.3 GL70.6 IC02.3 IC02.4 IC56.1 IC56.2
ICBL.1 ICBL.2 ICBL.3 ICLM.1 ICLM.3 GL124
GL162 GL20.5 GL20.7 GL20.8 GL20.9 IFGT.1
MX00.1 MX123 MX160 MX500 ML146 ML165
ML240 ML40.1 ML40.2 ML40.3 ML40.7 ML40.8
ML44.1 ML45.1 ML65.1 PA495 PO04.5 PO04.6
POBL.1 POBL.3 RQ01.2 RQ01.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MVL-MATRIX-CAT
Element: Matrix Category		Alpha 12
Attribute name assigned to an object (like an accounting unit) to track additional information. Attribute values may then be used in selection and sorting for reporting and analysis.
MX00.1 MX160
MVL-FR-MX-VAL
Element: From Matrix Value		Alpha 32
The beginning value in a range of values.
MX00.1 MX160
MVL-TH-MX-VAL
Element: To Matrix Value		Alpha 32
The ending value in a range of values.
MX00.1 MX160
MVL-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
MX00.1 MX160


MXVALIDATE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MVLSET1 MATRIX-CAT
TH-MX-VAL
...
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC13.1
AC13.2 AC13.7
AC13.8 AC135
AC14.1 AC14.2
AC14.6 AC14.7
AC16.1 AC16.2
AC16.7 AC16.8
AC16.9 AC213
AC247 AC256
AC290 AC295
AC298 AC40.1
AC40.4 AC41.1
AC41.4 AC410


MXVALIDATE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Mxcatdef MXCATDEF Required
MVL-MATRIX-CAT->MXC-MATRIX-CAT


MXVALIDATE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acblratex ACBLRATEX
MVL-MATRIX-CAT->ALX-MATRIX-CAT
  ALX-ACTIVITY
  ALX-SUM-ACCT-CAT
  ALX-CTR-CAT-GRP
  ALX-ACCT-CATEGORY
  ALX-SOURCE-CODE
  ALX-EFFECTIVE-DT
  ALX-MX-VALUE
Glsscat Ad GLSCCAT
MVL-MATRIX-CAT->GSC-MATRIX-CAT
"AD"->GSC-SOURCE-CODE
  GSC-SEQ-NBR

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

Home
Contact Us



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