MXCATDEF

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
AC03.2 AC03.3 AC03.4 AC03.5 AC03.6 AC112
AC113 AC120 AC121 AC123 AC128 AC130
AC135 AC145 AC147 AC160 AC165 AC169
AC190 AC191 AC196 AC197 AC198 AC200
AC203 AC206 AC207 AC210 AC213 AC218
AC220 AC225 AC240 AC246 AC247 AC256
AC261 AC265 AC290 AC295 AC297 AC298
AC30.3 AC310 AC311 AC32.1 AC346 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 AC52.1 AC520
AC527 AC54.1 AC560 AC580 AC583 AC90.1
AC92.1 AC93.1 AC94.1 AC95.1 AC97.1 ACAC.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 AM22.1 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 AM285 AM287
AM290 AM292 AM295 AM310 AM320 AM330
AM35.1 AM45.1 AM500 AM501 AM51.1 AM551
AM70.4 AM88.1 AM88.8 AM97.1 AMBL.1 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 AP271 AP30.2 AP30.4
AP300 AP305 AP510 AP90.1 AP91.1 API1.1
API2.1 API3.1 API4.1 ZA161 AR01.3 AR210
AR211 AR217 AR23.1 AR23.2 AR23.3 AR301
ARLL.1 BR00.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 BR265 BR300
BR400 BR405 BR422 BR43.1 BR430 BR44.1
BR450 BR46.1 BR521 BR530 BR580 CB145
CB170 CB175 CB180 CB186 CB187 CB215
CB220 CB221 CB222 CB260 CB286 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 CA10.1 CA10.2 CA10.7
GL110 GL122 GL170 GL256 GL292 GL293
GL299 GL65.1 GL70.1 GL70.2 GL70.3 GL70.6
GL95.4 GL99.1 RW100 DR100 IC02.1 IC02.3
IC02.4 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC56.1 IC56.2 IC64.1 IC64.2
IC64.3 IC64.4 IC64.5 IC64.6 IC64.7 IC64.8
IC64.9 IC66.1 IC802 IC81.1 IC811 IC83.1
IC840 ICBL.1 ICBL.2 ICBL.3 ICLM.1 ICLM.3
GL124 GL162 GLAC.1 IFSC.1 MX123 MX202
MX500 MA180 MA278 MA279 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAI1.1 ML240 ML65.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 PO136 PO15.1 PO15.2 PO15.4 PO150
PO190 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.2
PO22.3 PO22.4 PO22.5 PO220 PO222 PO223
PO224 PO225 PO229 PO23.1 PO230 PO233
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO253 PO254 PO26.4 PO26.5 PO27.2
PO275 PO276 PO277 PO278 PO28.2 PO280
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 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 PO54.5 POBL.1 POBL.3
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 RQ01.1 RQ01.2 RQ01.3 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ260 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.1 WH110 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH226 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 ZW130 AC01.1
AC105 AC13.1 AC13.2 AC13.3 AC13.7 AC13.8
AC14.1 AC14.2 AC14.3 AC14.6 AC14.7 AC16.1
AC16.2 AC16.3 AC16.7 AC16.8 AC16.9 AC208
AC255 AC34.1 AC35.1 AC36.1 AC51.1 AC510
AC55.1 AC558 AC58.3 AC58.4 ACBA.1 ACDL.1
ACDM.2 ACDM.8 ACDM.9 ACVW.1 ATVW.1 AM214
AM282 AM94.1 AMAS.1 AMDM.2 BR03.1 BR03.3
BR254 CB01.4 CB01.5 CB01.7 CB210 CBBC.1
CBDM.5 FB141 GL191 GL240 GL265 GL270
GL294 GL55.1 RW20.1 RW20.2 RW80.1 GL05.1
GL05.2 GL121 GL123 GL14.5 GL14.7 GL16.1
GL16.2 GL16.3 GL16.4 GL205 GL220 GLBL.1
IFAS.2 IFBA.1 IFBO.1 IFOS.2 IFOS.3 MX05.1
MX06.1 MX10.1 MX10.2 MX135 MX201 MX205
MX260 MX60.1 ML170 ML191 ML265 ML270
ML292 ML293 ML70.1 ML70.2 ML70.3 ML70.6
ML95.4 ML99.1 RQBL.1 RQBL.3 SL00.5 SL00.6
SLBL.1 SN02.1 SNAC.1 SNAU.1 SNGL.1 AP162
AP262 AP62.1 CB162 CB262 CB62.1 GL262
GL62.1


UPDATED BY
GL20.1 MX00.1 MX100 MX160

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MXC-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 MX100
MXC-CATEGORY-TYPE
Element: Category Type		Alpha 1
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
MX00.1 MX100
MXC-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
The attribute description.
MX00.1 MX100
MXC-COLM-HEADING
Element: Column Heading		Alpha 32 (Lower Case)
Text used for column headings on screens or reports. Heading size is limited to the size of the field.
MX00.1
MXC-HAS-VALIDATION
Element: Validation		Alpha 1
Identifies if valid values have been defined for the category. Yes = valid value records are defined and the entered value must cohere.
N = No
MX00.1 MX160
MXC-ELEMENT-NAME
Element: Element Name		Alpha 20
The Lawson or user-defined element name that identifies the field size and type.
MX00.1 MX100


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
AC147 AC16.1
AC16.2 AC16.3
MXCSET2 CATEGORY-TYPE
MATRIX-CAT
KeyChange
AP162 AP262
AP62.1 CB162
CB262 CB62.1
GL162 GL262
GL62.1 MX100
MXCSET3 ELEMENT-NAME
MATRIX-CAT
KeyChange
MX00.2 MX100


MXCATDEF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Matrix Element MXELEMENT Required
MXC-ELEMENT-NAME->MXE-ELEMENT-NAME


MXCATDEF FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:18:46 2016

Home
Contact Us



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