MXVALIDATE

Attribute Validation

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

REFERENCED BY
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
AC42.1 AC45.1 AC460 AC471 AC472 AC480
AC50.1 AC500 AC51.1 AC510 AC52.1 AC520
AC54.1 AC540 AC55.1 AC558 AC560 AC58.3
AC58.4 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 AM94.1 AP03.1
AP03.2 AP162 AP262 AP62.1 AR23.1 AR23.2
BR00.3 BR03.1 BR03.3 BR10.7 BR20.6 BR43.1
BR44.1 BR46.1 CB01.4 CB01.5 CB162 CB262
CB62.1 CA10.2 CA190 CA210 GL146 GL147
GL165 GL170 GL190 GL191 GL197 GL240
GL256 GL265 GL270 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL55.1 GL65.1
GL65.4 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 GL123 GL124 GL14.1 GL14.5
GL14.7 GL14.8 GL16.1 GL16.2 GL16.3 GL16.4
GL162 GL20.5 GL20.7 GL20.8 GL20.9 GL220
GL262 GL62.1 IFBO.1 IFGT.1 MX05.1 MX05.2
MX06.1 MX06.2 MX10.1 MX10.2 MX100 MX123
MX135 MX20.1 MX20.2 MX20.4 MX20.5 MX201
MX205 MX260 MX500 MX60.1 ML146 ML165
ML170 ML190 ML240 ML265 ML270 ML40.1
ML40.2 ML40.3 ML40.7 ML40.8 ML44.1 ML45.1
ML65.1 ML70.1 ML70.2 ML70.3 ML70.6 MLIT.1
PA495 PO04.5 PO04.6 POBL.1 POBL.3 RQ01.2
RQ01.3 RQBL.3 SL00.5 SL00.6 SL40.1


UPDATED BY
MX00.1 MX160

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
Mxvalidau MXVALIDAU
MVL-MATRIX-CAT->MVU-MATRIX-CAT
MVL-TH-MX-VAL->MVU-TH-MX-VAL
  MVU-ACTION
  MVU-DATE
  MVU-TIME
  MVU-UNIQUE-I-D

File created: Thu Jun 09 02:21:01 2016

Home
Contact Us



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