|
|
MXCATDEF FILE
Attribute Definition
This file contains the valid Lawson and user-type attribute header records
including, the attribute type, description, column headings, and element names
defined in MX00.1 (Attribute). The attributes can be applied to various
objects. Attribute values can be assigned to an object and used for analysis,
grouping, and sorting.
REFERENCED BY
AC105 AC110 AC112 AC115 AC120 AC123
AC13.1 AC13.2 AC13.3 AC130 AC14.1 AC160
AC165 AC17.1 AC170 AC190 AC191 AC196
AC20.1 AC20.2 AC20.3 AC20.4 AC203 AC206
AC207 AC210 AC214 AC215 AC216 AC240
AC255 AC256 AC265 AC290 AC295 AC297
AC30.2 AC30.3 AC310 AC32.1 AC40.1 AC401
AC41.1 AC410 AC412 AC415 AC416 AC42.1
AC420 AC421 AC440 AC450 AC460 AC470
AC471 AC472 AC473 AC480 AC490 AC50.1
AC500 AC51.1 AC510 AC530 AC55.1 AC79.1
ACBA.1 AM220 AM221 AM222 AM223 AM224
AM225 AM23.1 AM23.2 AM23.3 AM230 AM235
AM240 AM245 AM250 AM255 AM260 AM265
AM275 AM277 AM280 AM285 AM290 AM292
AM295 AM500 AM94.1 CA10.1 CA10.2 CA10.8
GL110 GL170 GL191 GL240 GL256 GL265
GL270 GL55.1 GL65.1 GL70.1 GL70.2 GL70.3
GL70.7 RW80.1 GL05.1 GL05.2 GL20.1 GL20.5
GL20.7 GL205 GL220 GLBL.1 IFSC.1 MX05.1
MX10.1 MX10.2 MX123 MX201 MX205 MX500
SL00.5 SL00.6 SLBL.1 GL162 GL262 GL62.1
UPDATED BY
AM951 AM952 MX00.1 MX100
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MXC-MATRIX-CAT Alpha 12 AM951 AM952
Matrix Category Attribute name assigned to an object MX00.1 MX100
(like an accounting unit) to track
additional information. Attribute values
may then be used in selection and
sorting for reporting and analysis.
MXC-CATEGORY-TYPE Alpha 1 AM951 AM952
Category Type Defines whether the attribute category MX00.1 MX100
is a Lawson type (maintained by the
system), or a User type (maintained by
the user). Both types are available for
selection and reporting.
L = Lawson
U = User
MXC-DESCRIPTION Alpha 30 (Lower Case) MX00.1 MX100
Description The attribute description.
MXC-COLM-HEADING Alpha 20 (Lower Case) AM951 AM952
Column Heading Text used for column headings on MX00.1
screens or reports. Heading size is
limited to the size of the field.
MXC-HAS-VALIDATION Alpha 1 AM951 AM952
Validation Identifies if valid values have been MX00.1
defined for the category. Yes = valid
value records are defined and the
entered value must cohere.
N = No
MXC-ELEMENT-NAME Alpha 20 AM951 AM952
Element Name The Lawson or user-defined element name MX00.1 MX100
that identifies the field size and type.
MXCATDEF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MXCSET1 MATRIX-CAT AC105 AC110
AC112 AC115
AC120 AC123
AC13.1 AC13.2
AC13.3 AC130
AC14.1 AC160
AC165 AC17.1
AC170 AC190
AC191 AC196
AC20.1 AC20.2
AC20.3 AC20.4
AC203 AC206
AC207 AC210
AC214 AC215
AC216 AC240
...
MXCSET2 CATEGORY-TYPE KeyChange GL162 GL262
MATRIX-CAT GL62.1
MXCSET3 ELEMENT-NAME KeyChange MX00.2
MATRIX-CAT
MXCATDEF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Matrix Element MXELEMENT Required
MXC-ELEMENT-NAME -> MXE-ELEMENT-NAME
MXCATDEF FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mxlistdtl Ac MXLISTDTL
"ACTVY" -> MLD-OBJ-TYPE
MXC-MATRIX-CAT -> MLD-MATRIX-CAT
MLD-MATRIX-LIST
MLD-OR-GROUP
MLD-SEQ-NUMBER
Mxlistdtl Au MXLISTDTL
"ACCTU" -> MLD-OBJ-TYPE
MXC-MATRIX-CAT -> MLD-MATRIX-CAT
MLD-MATRIX-LIST
MLD-OR-GROUP
MLD-SEQ-NUMBER
Mxobjcat MXOBJCAT Delete Restricted
MXC-MATRIX-CAT -> MOC-MATRIX-CAT
MOC-OBJ-TYPE
Mxvalidate MXVALIDATE Delete Cascades
MXC-MATRIX-CAT -> MVL-MATRIX-CAT
MVL-TH-MX-VAL
Src Code Cats GLSCCAT Delete Restricted
MXC-MATRIX-CAT -> GSC-MATRIX-CAT
GSC-SOURCE-CODE
GSC-SEQ-NBR
|