MXLISTMBR FILE
Attribute List
This file stores list member records, including the object type, sequence
number, and object ID. This information is used to perform queries on
accounting units, and accounts.
REFERENCED BY
AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC256 AC52.1 AC520 AM180 CA110 FB100
FB101 FB11.1 FB141 FB20.1 FB20.6 FB20.7
FB21.1 FB211 FB296 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL256 GL292 GL293
GL294 GL298 GL94.1 GL94.2 GL94.3 GL94.4
GL94.5 GL94.6 GL94.7 GL95.1 GL95.2 GL95.3
GL95.4 GL95.5 GL95.6 GL95.7 GL95.8 GL95.9
GL96.1 GL96.2 GL96.3 GL96.4 GL96.5 GL97.1
GL97.2 GL97.3 GL97.4 GL97.5 GL97.6 GL97.7
GL97.8 GL97.9 GL98.1 GL98.2 GL98.3 GL98.4
GL98.5 GL99.1 GL99.2 GL99.3 GL99.4 GL99.5
GL99.6 RW00.1 RW100 RW230 RW270 RW299
RW30.1 RW70.1 GL16.4 GLAV.1 GLCV.1 GLVW.1
IFBA.1 IFBO.1 MX202 MX223 SLVW.1 AC541
AM125 AM135 AM145 AMAS.1 AMDL.1 CB10.1
CB15.1 CB15.2 CB20.1 CB500 IC222 IFAC.1
UPDATED BY
AC01.1 AC105 AC112 AC120 AC121 AC123
AC13.3 AC13.4 AC13.5 AC13.1 AC135 AC160
AC165 AC190 AC191 AC196 AC198 AC203
AC206 AC207 AC210 AC213 AC218 AC220
AC240 AC258 AC261 AC265 AC290 AC295
AC297 AC298 AC30.3 AC310 AC32.1 AC34.1
AC35.1 AC36.1 AC400 AC401 AC410 AC412
AC420 AC421 AC440 AC460 AC471 AC472
AC473 AC480 AC490 AC493 AC494 AC530
AC55.1 AC90.1 AC92.1 AC93.1 AC94.1 AC95.1
AC97.1 ACBA.1 ACVW.1 DA233 DA240 GR240
SE90.1 AM120 AM214 AM220 AM221 AM222
AM223 AM224 AM225 AM23.3 AM23.4 AM23.5
AM230 AM235 AM240 AM245 AM25.2 AM250
AM255 AM260 AM265 AM267 AM270 AM275
AM277 AM278 AM280 AM281 AM282 AM285
AM287 AM290 AM292 AM295 AM320 AM35.1
AM45.1 AM70.4 AM88.1 AMBL.1 AR250 AR251
AR30.5 BR120 BR121 BR130 BR131 BR142
BR165 BR200 BR202 BR204 BR205 BR210
BR220 BR265 BR400 BR405 BR420 BR430
BR450 BRCC.1 CA10.1 CA10.7 GL191 RW80.1
GL21.2 GL22.2 GLAC.1 GLBL.1 MX10.2 MX10.3
MX123 MX500 SLBL.1 GL110 GL20.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLM-OBJ-TYPE Alpha 5 AC01.1 AC105
Object Type This field determines the type of AC112 AC120
object used by the Attribute. These AC121 AC123
values are not user maintainable. AC13.3 AC13.4
AC135 AC160
AC165 AC190
AC191 AC196
AC198 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC240 AC258
AC261 AC265
AC290 AC295
AC297 AC298
AC30.3 AC310
AC32.1 AC34.1
AC35.1 AC36.1
AC400 AC401
AC410 AC412
AC420 AC421
AC440 AC460
AC471 AC472
AC473 AC480
AC490 AC493
AC494 AC530
AC55.1 AC90.1
AC92.1 AC93.1
AC94.1 AC95.1
AC97.1 ACBA.1
...
MLM-MATRIX-LIST Alpha 12 AC01.1 AC105
Matrix List Attribute categories are selection AC112 AC120
parameters used to build a list of AC121 AC123
objects (accounting units). Attribute AC13.3 AC13.4
categories and values are the basis of AC13.5 AC135
the selection and sorting. A attribute AC160 AC165
list can then be used for reporting on AC190 AC191
and processing "objects." AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC258 AC261
AC265 AC290
AC295 AC297
AC298 AC30.3
AC310 AC32.1
AC34.1 AC35.1
AC36.1 AC400
AC401 AC410
AC412 AC420
AC421 AC440
AC460 AC471
AC472 AC473
AC480 AC490
AC493 AC494
AC530 AC55.1
AC90.1 AC92.1
AC93.1 AC94.1
AC95.1 AC97.1
...
MLM-SEQ-NUMBER Numeric 6 AC01.1 AC105
Sequence Number A unique number assigned to each AC112 AC120
transaction transferred into the Lawson AC121 AC123
system. AC13.3 AC13.4
AC135 AC160
AC165 AC190
AC191 AC196
AC198 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC240 AC258
AC261 AC265
AC290 AC295
AC297 AC298
AC30.3 AC310
AC32.1 AC34.1
AC35.1 AC36.1
AC400 AC401
AC410 AC412
AC420 AC421
AC440 AC460
AC471 AC472
AC473 AC480
AC490 AC493
AC494 AC530
AC55.1 AC90.1
AC92.1 AC93.1
AC94.1 AC95.1
AC97.1 ACBA.1
...
MLM-OBJ-ID Numeric 12 AC01.1 AC105
Object ID The unique object identifier. AC112 AC120
AC121 AC123
AC13.3 AC13.4
AC135 AC160
AC165 AC190
AC191 AC196
AC198 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC240 AC258
AC261 AC265
AC290 AC295
AC297 AC298
AC30.3 AC310
AC32.1 AC34.1
AC35.1 AC36.1
AC400 AC401
AC410 AC412
AC420 AC421
AC440 AC460
AC471 AC472
AC473 AC480
AC490 AC493
AC494 AC530
AC55.1 AC90.1
AC92.1 AC93.1
AC94.1 AC95.1
AC97.1 ACBA.1
...
MXLISTMBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLMSET1 OBJ-TYPE AC01.1 AC105
MATRIX-LIST AC112 AC120
SEQ-NUMBER AC121 AC123
AC13.3 AC13.4
AC13.5 AC130
AC135 AC160
AC165 AC190
AC191 AC196
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
...
MLMSET2 OBJ-TYPE AC13.1 AC13.4
OBJ-ID AC130 AC190
MATRIX-LIST AC191 AC256
AC530 AC541
AM120 AM125
AM135 AM145
AM214 AM220
AM221 AM222
AM223 AM224
AM225 AM23.4
AM23.5 AM230
AM235 AM240
AM245 AM25.1
AM25.3 AM250
AM255 AM260
...
MXLISTMBR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Abassign ABASSIGN Not Required
MLM-OBJ-ID -> ASN-OBJ-ID
Acactivity ACACTIVITY Not Required
MLM-OBJ-ID -> ACV-OBJ-ID
Account GLCHARTDTL Not Required
MLM-OBJ-ID -> GDT-OBJ-ID
Acct Unit GLNAMES Not Required
Valid When (MLM-OBJ-TYPE = "ACCTU" )
MLM-OBJ-ID -> GLN-OBJ-ID
Amasset AMASSET Not Required
MLM-OBJ-ID -> AST-OBJ-ID
Analysis SLSEGVALUE Not Required
MLM-OBJ-ID -> SVL-OBJ-ID
Lease LMLEASE Not Required
MLM-OBJ-ID -> LSE-OBJ-ID
Mxlisthdr MXLISTHDR Required
MLM-OBJ-TYPE -> MLH-OBJ-TYPE
MLM-MATRIX-LIST -> MLH-MATRIX-LIST
|
