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
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
AC16.7 AC16.8 AC16.9 AC160 AC165 AC169
AC190 AC191 AC196 AC197 AC198 AC200
AC203 AC206 AC207 AC208 AC210 AC213
AC218 AC220 AC225 AC240 AC246 AC247
AC255 AC256 AC261 AC265 AC290 AC295
AC297 AC298 AC30.3 AC310 AC311 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 AC97.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 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 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 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 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 BR46.1 BR521 BR530
BR580 CB01.4 CB01.5 CB01.7 CB145 CB170
CB175 CB180 CB186 CB187 CB210 CB215
CB220 CB221 CB222 CB260 CB286 CBBC.1
CBDM.5 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 CA10.1
CA10.2 CA10.4 CA10.7 FB141 GL110 GL122
GL146 GL170 GL191 GL197 GL240 GL256
GL265 GL270 GL292 GL293 GL294 GL299
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1
GL45.1 GL55.1 GL65.1 GL65.4 GL70.1 GL70.2
GL70.3 GL70.6 GL95.4 GL99.1 RW100 RW20.1
RW20.2 RW80.1 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 GL05.1
GL05.2 GL121 GL123 GL124 GL14.1 GL14.5
GL14.7 GL14.8 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 MX05.2 MX06.1
MX06.2 MX10.1 MX10.2 MX123 MX135 MX20.1
MX20.2 MX20.4 MX20.5 MX201 MX202 MX205
MX260 MX500 MX60.1 MA126 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
MA540 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
ML170 ML191 ML240 ML265 ML270 ML292
ML293 ML65.1 ML70.1 ML70.2 ML70.3 ML70.6
ML95.4 ML99.1 PA495 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD230 PD235 PD570
PO04.1 PO04.2 PO04.5 PO04.6 PO10.1 PO10.2
PO100 PO101 PO115 PO120 PO122 PO131
PO132 PO136 PO15.1 PO15.2 PO15.4 PO150
PO17.1 PO190 PO192 PO195 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.3 PO26.4 PO26.5 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 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
PO529 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 RQ01.1 RQ01.2 RQ01.3
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1 RQ44.1
RQ500 RQ810 RQBL.1 RQBL.3 RQIB.1 RQIF.1
RQII.1 RQIJ.1 SL00.5 SL00.6 SL40.1 SLBL.1
SN02.1 SNAC.1 SNAU.1 SNGL.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 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
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
Mxcatdefau MXCATDEFAU
MXC-MATRIX-CAT->MCU-MATRIX-CAT
  MCU-ACTION
  MCU-DATE
  MCU-TIME
  MCU-UNIQUE-I-D
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 02:20:53 2016

Home
Contact Us



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