MXLISTDTL

Attribute List Detail

This file consists of attribute list detail records which are used to define and access accounting unit detail information.

REFERENCED BY
AC01.1 AC105 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 AC34.1 AC346 AC35.1 AC36.1 AC400
AC401 AC410 AC412 AC420 AC421 AC440
AC460 AC471 AC472 AC473 AC480 AC490
AC493 AC494 AC527 AC55.1 AC580 AC583
AC90.1 AC92.1 AC93.1 AC94.1 AC95.1 AC97.1
ACBA.1 ACDL.1 ACDM.2 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 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 AP271 AP30.2
AP30.4 AP300 AP305 AP510 AP90.1 AP91.1
API1.1 API2.1 API3.1 API4.1 ZA161 AR210
AR211 AR217 AR301 ARLL.1 BR120 BR121
BR130 BR131 BR140 BR142 BR145 BR151
BR152 BR153 BR154 BR155 BR156 BR157
BR165 BR19.2 BR190 BR20.9 BR200 BR202
BR204 BR205 BR210 BR212 BR215 BR220
BR245 BR251 BR252 BR253 BR254 BR265
BR300 BR400 BR405 BR422 BR430 BR450
BR521 BR530 BR580 CB145 CB170 CB175
CB180 CB186 CB187 CB210 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.4 CA10.7 GL122
GL146 GL191 GL197 GL299 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL70.1
GL70.2 GL70.3 GL70.6 RW80.1 DR100 IC12.1
IC140 IC141 IC142 IC145 IC243 IC330
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 IC840
ICBL.1 ICBL.2 ICLM.1 GL121 GL14.1 GL14.5
GL14.7 GL14.8 GL16.1 GL16.2 GL16.3 GL16.4
GL20.7 GL20.8 GL20.9 GL20.1 GLAC.1 GLBL.1
MX00.1 MX00.2 MX00.3 MX05.1 MX05.2 MX06.1
MX06.2 MX123 MX135 MX20.1 MX20.2 MX20.4
MX20.5 MX210 MX500 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
ML191 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD230 PD235 PD570 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.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
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
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 RQIB.1 RQIF.1 RQII.1
RQIJ.1 SL40.1 SLBL.1 SN02.1 SNAC.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
GL00.1 GL00.3 GL124 IFLU.1 MX100


UPDATED BY
AC13.4 AC13.5 AC14.4 AC14.5 AC16.4 AC16.5
AM23.5 AM23.4 AP03.4 AR23.5 AR23.4 CB01.6
GL21.2 GL22.2 MX10.1 MX10.2 MX10.3 IC02.6
IC56.4 PO04.8 RQ01.5

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."
AC13.5 AC14.5
AC16.5 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
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC13.3 AC13.4
AC13.5 AC130
AC135 AC14.3
AC14.4 AC14.5
AC145 AC147
AC16.3 AC16.4
AC16.5 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
MLDSET2 OBJ-TYPE
MATRIX-CAT
MATRIX-LIST
OR-GROUP
SEQ-NUMBER
KeyChange
AC13.1 AC13.2
AC14.1 AC14.2
AC16.1 AC16.2
AM23.1 AM23.2
AM23.5 AP150
AP155 AP160
AP161 AP265
ZA161 AR23.1
AR23.2 AR23.5
GL00.1 GL00.3
GL124 GL20.1
IFLU.1 MX00.2
MX00.3 MX100


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


MXLISTDTL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Mxlstdtlau MXLSTDTLAU
MLD-OBJ-TYPE->LDA-OBJ-TYPE
MLD-MATRIX-LIST->LDA-MATRIX-LIST
MLD-OR-GROUP->LDA-OR-GROUP
MLD-MATRIX-CAT->LDA-MATRIX-CAT
MLD-SEQ-NUMBER->LDA-SEQ-NUMBER
  LDA-ACTION
  LDA-DATE
  LDA-TIME
  LDA-UNIQUE-I-D


File created: Thu Jun 09 02:20:54 2016

Home
Contact Us



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