Lawson Insight Technical Documentation |
|
MXVALIDATE
MXVALIDATE FILE
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 AC213 AC256 AC40.1 AC40.4
AC41.1 AC41.4 AC42.1 AC45.1 AC50.1 AC500
AC51.1 AC510 AC52.1 AC520 AC54.1 AC540
AC55.1 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 AR23.1 AR23.2 AR515 BR00.3 BR03.1
BR03.3 BR10.7 BR20.6 BR43.1 BR44.1 CB01.4
CB01.5 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 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 IFBO.1 IFGT.1 MX05.1 MX06.1
MX10.1 MX100 MX135 MX201 MX205 MX260
MX500 MX60.1 PA495 SL00.5 SL00.6 SL40.1
UPDATED BY
MX00.1 MX160
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MVL-MATRIX-CAT Alpha 12 MX00.1 MX160
Element: Matrix CategorAttribute 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.
MVL-FR-MX-VAL Alpha 32 MX00.1 MX160
Element: From Matrix VaThe beginning value in a range of
values.
MVL-TH-MX-VAL Alpha 32 MX00.1 MX160
Element: To Matrix ValuThe ending value in a range of values.
MVL-DESCRIPTION Alpha 30 (Lower Case) MX00.1 MX160
Element: Description This field displays the description.
MXVALIDATE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MVLSET1 MATRIX-CAT AC03.2 AC03.3
TH-MX-VAL AC03.4 AC03.5
AC03.6 AC13.1
AC13.2 AC13.7
AC13.8 AC135
AC14.1 AC14.2
AC14.6 AC14.7
AC213 AC256
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC50.1 AC500
AC51.1 AC510
AC52.1 AC520
AC54.1 AC540
...
MXVALIDATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mxcatdef MXCATDEF Required
MVL-MATRIX-CAT -> MXC-MATRIX-CAT
MXVALIDATE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|