|
|
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
AC128 AC13.1 AC13.2 AC13.3 AC13.7 AC13.8
AC130 AC135 AC14.1 AC14.2 AC14.3 AC14.6
AC14.7 AC145 AC16.1 AC16.2 AC16.3 AC16.7
AC16.8 AC16.9 AC160 AC165 AC169 AC190
AC191 AC197 AC198 AC200 AC203 AC206
AC207 AC208 AC210 AC213 AC218 AC220
AC225 AC240 AC246 AC255 AC256 AC261
AC265 AC290 AC295 AC298 AC30.3 AC310
AC32.1 AC34.1 AC346 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 AC527 AC54.1 AC55.1 AC558
AC560 AC58.3 AC58.4 AC580 AC583 AC90.1
AC92.1 AC93.1 AC94.1 AC95.1 ACAC.1 ACBA.1
ACDL.1 ACDM.2 ACDM.8 ACDM.9 ACVW.1 ATVW.1
SE90.1 AM115 AM117 AM120 AM15.1 AM15.2
AM15.3 AM15.4 AM19.1 AM19.2 AM20.1 AM20.3
AM21.1 AM21.3 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 AM310 AM320
AM330 AM35.1 AM45.1 AM500 AM501 AM51.1
AM551 AM70.4 AM88.1 AM88.8 AM94.1 AM97.1
AMAS.1 AMBL.1 AMDM.2 AP03.1 AP03.2 AP03.3
AP110 AP115 AP125 AP126 AP131 AP150
AP155 AP160 AP161 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP210 AP211
AP220 AP23.1 AP25.1 AP25.2 AP26.1 AP265
AP27.1 AP30.2 AP30.4 AP305 AP510 AP90.1
AP91.1 API1.1 API2.1 API3.1 API4.1 AR01.3
AR120 AR129 AR130 AR131 AR135 AR170
AR21.2 AR210 AR211 AR217 AR222 AR223
AR227 AR228 AR229 AR23.1 AR23.2 AR23.3
AR230 AR232 AR233 AR235 AR237 AR238
AR239 AR245 AR250 AR251 AR253 AR257
AR258 AR264 AR265 AR27.2 AR271 AR275
AR282 AR285 AR29.1 AR290 AR291 AR292
AR293 AR294 AR296 AR30.1 AR30.5 AR300
AR301 AR32.1 AR33.1 AR33.2 AR38.5 AR39.1
AR39.2 AR39.3 AR39.4 AR42.1 AR42.2 AR42.7
AR42.8 AR43.1 AR502 AR503 AR515 AR55.1
AR560 AR575 AR72.1 AR800 AR91.1 ARLL.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL232 BL29.1 BL29.2 BL290 BL520
BL820 BL92.1 BR00.3 BR03.1 BR03.3 BR10.7
BR120 BR121 BR130 BR131 BR140 BR142
BR145 BR151 BR152 BR153 BR154 BR155
BR156 BR157 BR165 BR19.2 BR190 BR20.6
BR20.9 BR200 BR202 BR204 BR205 BR210
BR212 BR215 BR220 BR245 BR251 BR252
BR253 BR254 BR265 BR300 BR400 BR405
BR422 BR43.1 BR430 BR44.1 BR450 BR521
BR530 BR580 CB01.4 CB01.5 CB01.7 CB145
CB170 CB175 CB180 CB186 CB187 CB210
CB215 CB220 CB221 CB260 CB286 CBBC.1
CBDM.5 ET700 CA10.1 CA10.2 CA10.7 FB141
GL110 GL170 GL191 GL240 GL256 GL265
GL270 GL292 GL293 GL294 GL55.1 GL65.1
GL70.1 GL70.2 GL70.3 GL70.6 GL95.4 GL99.1
RW100 RW20.1 RW20.2 RW80.1 IC02.1 IC02.3
IC02.4 IC12.1 IC330 IC811 ICBL.1 ICBL.2
ICBL.3 ICLM.1 ICLM.3 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
MX10.1 MX10.2 MX123 MX135 MX201 MX202
MX205 MX260 MX500 MX60.1 MA180 MA278
MA279 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA53.1
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA66.3 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PA495 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD230 PD235 PO04.1 PO04.2
PO04.5 PO04.6 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO15.1 PO15.2
PO150 PO20.1 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO220 PO223 PO224
PO225 PO229 PO23.1 PO230 PO233 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO253 PO254 PO27.2 PO275 PO276 PO277
PO278 PO280 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.1 PO54.2 PO54.3 PO54.4 POBL.1 POBL.3
POI3.1 POID.1 POII.1 POIJ.1 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1
PW110 PW510 RQ01.1 RQ01.2 RQ01.3 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ13.2 RQ35.1 RQ44.1
RQ500 RQ810 RQBL.1 RQBL.3 RQIB.1 RQIF.1
RQII.1 RQIJ.1 SL00.5 SL00.6 SLBL.1 SN02.1
SNAC.1 SNAU.1 SNGL.1 WH110 WH130 WH20.2
WH20.7 WH226 AP162 AP262 AP62.1 CB162
CB262 CB62.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
AC128 AC13.1
AC13.2 AC13.3
AC13.7 AC13.8
AC130 AC135
AC14.1 AC14.2
AC14.3 AC14.6
AC14.7 AC145
AC16.1 AC16.2
AC16.3 AC16.7
...
MXCSET2 CATEGORY-TYPE KeyChange AP162 AP262
MATRIX-CAT AP62.1 CB162
CB262 CB62.1
GL162 GL262
GL62.1 MX100
MXCSET3 ELEMENT-NAME KeyChange MX00.2 MX100
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
Accatmxvdt ACCATMXVDT
MXC-MATRIX-CAT -> MXB-MATRIX-CAT
MXB-EFFECTIVE-DATE
MXB-OBJ-ID
Listdtl Acgrp MXLISTDTL
"ACGRP" -> MLD-OBJ-TYPE
MXC-MATRIX-CAT -> MLD-MATRIX-CAT
MLD-MATRIX-LIST
MLD-OR-GROUP
MLD-SEQ-NUMBER
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
|
