MXLISTDTL

Attribute List Detail

This file consists of attribute list detail records which are used to define and access accounting unit detail information.
UPDATED BY
AM23.5 AM23.3 AM23.4 AM23.1 AM23.2 AP03.4
AP03.3 AR23.5 AR23.3 AR23.4 AR23.1 AR23.2
CB01.6 CB01.7 GL21.2 GL22.2 MX10.1 MX10.2
MX10.3 AC200 AC210 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
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 AM97.1 AMBL.1 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 AR210 AR211
AR217 AR301 CB145 CB170 CB175 CB180
CB186 CB187 CB210 CB215 CB220 CB221
CB222 CB260 CB286 CA10.1 CA10.7 GL122
GL191 GL299 RW80.1 ICLM.1 GL121 GLAC.1
GLBL.1 MX123 MX210 MX500 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MAI1.1 PO04.8 PO10.1 PO136
PO190 PO300 PO520 POBL.1 POCP.1 POI3.1
POII.1 POIJ.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1 RQ01.5 RQBL.1
SLBL.1 SN02.1 SNAC.1 GL00.1 GL00.3 GL124
GL20.1 IFLU.1 MX00.2 MX00.3 MX100 MX202

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLD-OBJ-TYPE
Element: Object Type
Alpha 5
Determines the type of object to be used by the Attribute. These values are not user maintainable.
MX10.1
MLD-MATRIX-LIST
Element: Matrix List
Alpha 12
Attributes are selection parameters used to build a list of objects (accounting units). Attributes and values are the basis of the selection and sorting. An attribute list can then be used for reporting on and processing "objects."
AM23.5 AR23.5
MX10.1 MX10.3
MLD-OR-GROUP
Element: Group
Alpha 1
A single value used to group multiple selections together. Each group of value selections will be treated internally as an "and" and externally as an "or."
MX10.1
MLD-SEQ-NUMBER
Element: Sequence Number
Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
MX10.1
MLD-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.
MX10.1
MLD-FR-MX-VAL
Element: From Matrix Value
Alpha 32
The beginning value in a range of values.
MX10.1
MLD-TH-MX-VAL
Element: To Matrix Value
Alpha 32
The ending value in a range of values.
MX10.1


MXLISTDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLDSET1 OBJ-TYPE
MATRIX-LIST
OR-GROUP
MATRIX-CAT
SEQ-NUMBER
...
AC200 AC210
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.3
AM23.4 AM23.5
AM230 AM235
AM240 AM245
MLDSET2 OBJ-TYPE
MATRIX-CAT
MATRIX-LIST
OR-GROUP
SEQ-NUMBER
KeyChange
AM23.1 AM23.2
AM23.5 AP150
AP155 AP160
AP161 AP265
AR23.1 AR23.2
AR23.5 GL00.1
GL00.3 GL124
GL20.1 IFLU.1
MX00.2 MX00.3
MX100 MX202


MXLISTDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Matrix Cat MXOBJCAT Required
MLD-OBJ-TYPE->MOC-OBJ-TYPE
MLD-MATRIX-CAT->MOC-MATRIX-CAT
Mxlisthdr MXLISTHDR Required
MLD-OBJ-TYPE->MLH-OBJ-TYPE
MLD-MATRIX-LIST->MLH-MATRIX-LIST
Mxvalidate MXVALIDATE Not Required
MLD-MATRIX-CAT->MVL-MATRIX-CAT
MLD-TH-MX-VAL->MVL-TH-MX-VAL


File created: Wed Jun 08 20:49:46 2016

Home
Contact Us



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