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 AC200
AC210 ACAC.1 ACVW.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 AR210 AR211 AR217 AR23.1
AR23.2 AR23.3 AR301 CB01.4 CB01.5 CB01.7
CB145 CB170 CB175 CB180 CB186 CB187
CB210 CB215 CB220 CB221 CB222 CB260
CB286 CBBC.1 CBDM.5 CA10.1 CA10.2 CA10.7
FB141 GL110 GL122 GL170 GL191 GL240
GL256 GL265 GL270 GL292 GL293 GL294
GL299 GL55.1 GL65.1 GL70.1 GL70.2 GL70.3
GL70.6 GL95.4 GL99.1 RW100 RW20.1 RW20.2
RW80.1 ICLM.1 ICLM.3 GL05.1 GL05.2 GL121
GL123 GL124 GL14.5 GL14.7 GL16.1 GL16.2
GL16.3 GL16.4 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
MX202 MX205 MX260 MX500 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MAI1.1 PA495 PO04.1 PO04.2
PO04.5 PO04.6 PO10.1 PO10.2 PO136 PO15.1
PO15.2 PO15.4 PO190 PO204 PO300 PO520
POBL.1 POBL.3 POCP.1 POI3.1 POII.1 POIJ.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1 RQ01.1 RQ01.2 RQ01.3 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 GL162 GL262 GL62.1


UPDATED BY
MX00.1 MX00.2 MX100 MX160 GL20.1 MX201
MX60.1

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
...
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC200
AC210 ACAC.1
ACVW.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
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: Wed Jun 08 20:49:46 2016

Home
Contact Us



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