MXCATDEF – Attribute Definition

System
General Ledger Setup (IF)
Prefix
MXC
Primary key
MATRIX-CAT
Fields
6
Updated by
3 programs
Referenced by
680 programs

MXCATDEF is the Attribute Definition table in Lawson General Ledger Setup (prefix MXC). It is indexed by MATRIX-CAT (MXCSET1); alternate indexes: MXCSET2 and MXCSET3. It is related 1:1 to MXELEMENT and 1:M to ACCATMXVDT, MXLISTDTL, MXCATDEFAU, MXOBJCAT, MXVALIDATE and GLSCCAT. It is updated by MX00.1, MX100 and MX160 and referenced by AC01.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC105, AC112 and 672 more. The table has 6 fields, 3 indexes and 9 documented relations.

About MXCATDEF

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.

Fields (6)

Column = COBOL field name without the MXC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MXC-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute 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 SET2
CATEGORY_TYPE		Alpha 1Defines 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
DESCRIPTION		Alpha 30 (Lower Case)The attribute description.MX00.1, MX100
#MXC-COLM-HEADING
COLM_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
HAS_VALIDATION		Alpha 1Identifies 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 SET3
ELEMENT_NAME		Alpha 20The Lawson or user-defined element name that identifies the field size and type.MX00.1, MX100

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MXCSET1
  1. MATRIX-CAT
PrimaryAC01.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC105, AC112 +22 more (list truncated in source)
MXCSET2
  1. CATEGORY-TYPE
  2. MATRIX-CAT
KeyChangeAP162, AP262, AP62.1, CB162, CB262, CB62.1, GL162, GL262 +2 more
MXCSET3
  1. ELEMENT-NAME
  2. MATRIX-CAT
KeyChangeMX00.2, MX100

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
MXELEMENTACCATMXVDTMXLISTDTLMXCATDEFAUMXOBJCATMXVALIDATEGLSCCATMXCATDEF

One to one (1) — lookups and parents

RelationTableRulesConditionField map
Matrix ElementMXELEMENTRequired
MXC-ELEMENT-NAME→MXE-ELEMENT-NAME

One to many (8) — child tables

RelationTableRulesConditionField map
AccatmxvdtACCATMXVDT
MXC-MATRIX-CAT→MXB-MATRIX-CAT
—→MXB-EFFECTIVE-DATE
—→MXB-OBJ-ID
Listdtl AcgrpMXLISTDTL
"ACGRP"→MLD-OBJ-TYPE
MXC-MATRIX-CAT→MLD-MATRIX-CAT
—→MLD-MATRIX-LIST
—→MLD-OR-GROUP
—→MLD-SEQ-NUMBER
MxcatdefauMXCATDEFAU
MXC-MATRIX-CAT→MCU-MATRIX-CAT
—→MCU-ACTION
—→MCU-DATE
—→MCU-TIME
—→MCU-UNIQUE-I-D
Mxlistdtl AcMXLISTDTL
"ACTVY"→MLD-OBJ-TYPE
MXC-MATRIX-CAT→MLD-MATRIX-CAT
—→MLD-MATRIX-LIST
—→MLD-OR-GROUP
—→MLD-SEQ-NUMBER
Mxlistdtl AuMXLISTDTL
"ACCTU"→MLD-OBJ-TYPE
MXC-MATRIX-CAT→MLD-MATRIX-CAT
—→MLD-MATRIX-LIST
—→MLD-OR-GROUP
—→MLD-SEQ-NUMBER
MxobjcatMXOBJCATDelete Restricted
MXC-MATRIX-CAT→MOC-MATRIX-CAT
—→MOC-OBJ-TYPE
MxvalidateMXVALIDATEDelete Cascades
MXC-MATRIX-CAT→MVL-MATRIX-CAT
—→MVL-TH-MX-VAL
Src Code CatsGLSCCATDelete Restricted
MXC-MATRIX-CAT→GSC-MATRIX-CAT
—→GSC-SOURCE-CODE
—→GSC-SEQ-NBR

Programs

Updated by (3)

Referenced by (680)