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 FB141 FB20.1 FB20.6 FB20.7 FB21.1
FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
GL256 GL292 GL293 GL294 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 GLAV.1 GLCV.1 GLVW.1
IFBA.1 IFBO.1 MX202 MX223 SLVW.1 AC541
AC741 GR741 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 AC160 AC165
AC190 AC191 AC196 AC198 AC203 AC206
AC207 AC210 AC213 AC218 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 SE90.1 AM120 AM220 AM221 AM222
AM223 AM224 AM225 AM23.3 AM23.4 AM23.5
AM230 AM235 AM240 AM245 AM25.2 AM250
AM255 AM260 AM265 AM270 AM275 AM277
AM278 AM280 AM281 AM282 AM285 AM290
AM292 AM295 AM320 AM35.1 AM45.1 AM70.4
AM88.1 AMBL.1 AR250 AR251 AR30.5 BR120
BR121 BR142 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
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
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
AC541 AC55.1
AC741 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 AC160
the selection and sorting. A attribute AC165 AC190
list can then be used for reporting on AC191 AC196
and processing "objects." AC198 AC203
AC206 AC207
AC210 AC213
AC218 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 AC541
AC55.1 AC741
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
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
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 AM120
...
MLM-OBJ-ID Numeric 12 AC01.1 AC105
Object ID The unique object identifier. AC112 AC120
AC121 AC123
AC13.3 AC13.4
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
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
AC541 AC55.1
AC741 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
AC160 AC165
AC190 AC191
AC196 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC203
AC206 AC207
AC210 AC213
AC218 AC240
AC256 AC258
...
MLMSET2 OBJ-TYPE AC13.1 AC13.4
OBJ-ID AC130 AC190
MATRIX-LIST AC191 AC256
AC530 AC541
AC741 GR741
AM120 AM125
AM135 AM145
AM220 AM221
AM222 AM223
AM224 AM225
AM23.4 AM23.5
AM230 AM235
AM240 AM245
AM25.1 AM25.3
AM250 AM255
...
MXLISTMBR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Not Required
MLM-OBJ-ID -> ACV-OBJ-ID
Acct Unit GLNAMES Required
When (MLM-OBJ-TYPE = "ACCTU" )
MLM-OBJ-ID -> GLN-OBJ-ID
Mxlisthdr MXLISTHDR Required
MLM-OBJ-TYPE -> MLH-OBJ-TYPE
MLM-MATRIX-LIST -> MLH-MATRIX-LIST
|
