|
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
AC01.1 AC03.2 AC03.3 AC03.4 AC03.5 AC03.6
AC105 AC112 AC113 AC120 AC121 AC123
AC13.1 AC13.2 AC13.3 AC13.7 AC13.8 AC130
AC135 AC160 AC165 AC190 AC191 AC196
AC198 AC203 AC206 AC207 AC210 AC213
AC218 AC220 AC240 AC255 AC256 AC258
AC261 AC265 AC290 AC295 AC297 AC298
AC30.3 AC310 AC32.1 AC34.1 AC35.1 AC36.1
AC40.1 AC40.4 AC400 AC401 AC41.1 AC41.4
AC410 AC412 AC42.1 AC420 AC421 AC440
AC45.1 AC460 AC471 AC472 AC473 AC480
AC490 AC493 AC494 AC50.1 AC500 AC51.1
AC510 AC52.1 AC520 AC530 AC54.1 AC55.1
AC90.1 AC92.1 AC93.1 AC94.1 AC95.1 AC97.1
ACBA.1 ACDM.8 ACDM.9 ACVW.1 SE90.1 AM120
AM214 AM220 AM221 AM222 AM223 AM224
AM225 AM23.1 AM23.2 AM23.3 AM230 AM235
AM240 AM245 AM25.2 AM250 AM255 AM260
AM265 AM267 AM270 AM275 AM277 AM278
AM280 AM281 AM282 AM285 AM287 AM290
AM292 AM295 AM320 AM330 AM35.1 AM45.1
AM500 AM501 AM70.4 AM88.1 AM88.8 AM94.1
AMAS.1 AMBL.1 AMDM.2 AR01.3 AR250 AR251
AR30.1 AR30.2 AR30.3 AR30.5 BR00.3 BR03.1
BR03.3 BR10.1 BR120 BR121 BR130 BR131
BR142 BR151 BR152 BR153 BR154 BR155
BR156 BR157 BR165 BR20.6 BR200 BR202
BR204 BR205 BR210 BR215 BR220 BR251
BR252 BR253 BR254 BR265 BR400 BR405
BR420 BR43.1 BR430 BR450 BR521 BR530
BR900 BRCC.1 CA10.1 CA10.2 CA10.7 GL110
GL170 GL191 GL240 GL256 GL265 GL270
GL55.1 GL65.1 GL70.1 GL70.2 GL70.3 GL70.6
RW80.1 GL05.1 GL05.2 GL123 GL124 GL14.5
GL14.7 GL16.1 GL16.2 GL16.3 GL16.4 GL20.1
GL20.5 GL20.7 GL20.8 GL20.9 GL205 GL220
GLAC.1 GLBL.1 IFAS.2 IFBA.1 IFBO.1 IFOS.2
IFOS.3 IFSC.1 MX05.1 MX06.1 MX07.1 MX10.1
MX10.2 MX123 MX135 MX201 MX202 MX205
MX207 MX260 MX500 MX60.1 SL00.5 SL00.6
SLBL.1 GL162 GL262 GL62.1
UPDATED BY
MX00.1 MX100 MX160
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MXC-MATRIX-CAT Alpha 12 MX00.1 MX100
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.
MXC-CATEGORY-TYPE Alpha 1 MX00.1 MX100
Element: Category Type Defines whether the attribute category
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
Element: Description The attribute description.
MXC-COLM-HEADING Alpha 32 (Lower Case) MX00.1
Element: Column HeadingText used for column headings on
screens or reports. Heading size is
limited to the size of the field.
MXC-HAS-VALIDATION Alpha 1 MX00.1 MX160
Element: Validation Identifies if valid values have been
defined for the category. Yes = valid
value records are defined and the
entered value must cohere.
N = No
MXC-ELEMENT-NAME Alpha 20 MX00.1 MX100
Element: Element Name The Lawson or user-defined element name
that identifies the field size and type.
MXCATDEF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MXCSET1 MATRIX-CAT AC01.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC105 AC112
AC113 AC120
AC121 AC123
AC13.1 AC13.2
AC13.3 AC13.7
AC13.8 AC130
AC135 AC160
AC165 AC190
AC191 AC196
AC198 AC203
AC206 AC207
AC210 AC213
...
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
|