MXVALIDATE

Attribute Validation

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

REFERENCED BY
IFBO.1


UPDATED BY
MX00.1 MX160 AC03.2 AC03.3 AC03.4 AC03.5
AC03.6 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
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 GL70.1 GL70.2
GL70.3 GL70.6 ICLM.1 ICLM.3 GL123 GL124
GL14.5 GL14.7 GL16.1 GL16.2 GL16.3 GL16.4
GL162 GL20.5 GL20.7 GL20.8 GL20.9 GL220
GL262 GL62.1 IFGT.1 MX05.1 MX06.1 MX10.1
MX100 MX123 MX135 MX201 MX205 MX260
MX500 MX60.1 PA495 PO04.5 PO04.6 POBL.1
POBL.3 RQ01.2 RQ01.3 RQBL.3 SL00.5 SL00.6
SL40.1

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 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


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: Wed Jun 08 20:49:47 2016

Home
Contact Us



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