|
|
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
AC121 AC127 AC22.1 AC256 ACBO.1 ACVW.1
CA110 FB100 FB101 FB141 FB20.1 FB20.6
FB20.7 FB20.3 FB20.4 FB21.1 FB700 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 GL223 GLCV.1 GLOB.1 GLVW.1
MX500 AC65.1 CB10.1 CB15.1 CB15.2 CB20.1
CB500 FB121 FB165 FB230 FB231 FB30.1
FB31.1 FB65.1 GL170 GL230 GL270 IC222
IFAC.1 RQ10.1
UPDATED BY
AC105 AC110 AC112 AC115 AC120 AC123
AC13.3 AC13.4 AC13.5 AC13.1 AC130 AC14.1
AC160 AC165 AC170 AC190 AC191 AC196
AC20.1 AC20.2 AC20.3 AC20.4 AC203 AC206
AC207 AC210 AC214 AC215 AC216 AC240
AC265 AC290 AC295 AC297 AC30.2 AC30.3
AC310 AC32.1 AC401 AC410 AC412 AC415
AC416 AC420 AC421 AC440 AC450 AC460
AC470 AC471 AC472 AC473 AC480 AC490
AC530 AC55.1 AC79.1 ACBA.1 AM220 AM221
AM222 AM223 AM224 AM225 AM23.3 AM23.4
AM23.1 AM230 AM235 AM240 AM245 AM250
AM255 AM260 AM265 AM275 AM277 AM280
AM285 AM290 AM292 AM295 CA10.1 CA10.8
GL191 RW80.1 GL21.2 GLBL.1 MX10.2 MX10.3
MX123 SLBL.1 GL110 GL20.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLM-OBJ-TYPE Alpha 5 AC105 AC110
Object Type This field determines the type of AC112 AC115
object used by the Attribute. These AC120 AC123
values are not user maintainable. AC13.3 AC13.4
AC130 AC14.1
AC160 AC165
AC170 AC190
AC191 AC196
AC20.1 AC20.2
AC20.3 AC20.4
AC203 AC206
AC207 AC210
AC214 AC215
AC216 AC240
AC265 AC290
AC295 AC297
AC30.2 AC30.3
AC310 AC32.1
AC401 AC410
AC412 AC415
AC416 AC420
AC421 AC440
AC450 AC460
AC470 AC471
AC472 AC473
AC480 AC490
AC530 AC55.1
AC79.1 ACBA.1
AM220 AM221
AM222 AM223
...
MLM-MATRIX-LIST Alpha 12 AC105 AC110
Matrix List Attribute categories are selection AC112 AC115
parameters used to build a list of AC120 AC123
objects (accounting units). Attribute AC13.3 AC13.4
categories and values are the basis of AC13.5 AC130
the selection and sorting. A attribute AC14.1 AC160
list can then be used for reporting on AC165 AC170
and processing "objects." AC190 AC191
AC196 AC20.1
AC20.2 AC20.3
AC20.4 AC203
AC206 AC207
AC210 AC214
AC215 AC216
AC240 AC265
AC290 AC295
AC297 AC30.2
AC30.3 AC310
AC32.1 AC401
AC410 AC412
AC415 AC416
AC420 AC421
AC440 AC450
AC460 AC470
AC471 AC472
AC473 AC480
AC490 AC530
AC55.1 AC79.1
ACBA.1 AM220
AM221 AM222
...
MLM-SEQ-NUMBER Numeric 6 AC105 AC110
Sequence Number A unique number assigned to each AC112 AC115
transaction transferred into the Lawson AC120 AC123
system. AC13.3 AC13.4
AC130 AC14.1
AC160 AC165
AC170 AC190
AC191 AC196
AC20.1 AC20.2
AC20.3 AC20.4
AC203 AC206
AC207 AC210
AC214 AC215
AC216 AC240
AC265 AC290
AC295 AC297
AC30.2 AC30.3
AC310 AC32.1
AC401 AC410
AC412 AC415
AC416 AC420
AC421 AC440
AC450 AC460
AC470 AC471
AC472 AC473
AC480 AC490
AC530 AC55.1
AC79.1 ACBA.1
AM220 AM221
AM222 AM223
...
MLM-OBJ-ID Numeric 12 AC105 AC110
Object ID The unique object identifier. AC112 AC115
AC120 AC123
AC13.3 AC13.4
AC130 AC14.1
AC160 AC165
AC170 AC190
AC191 AC196
AC20.1 AC20.2
AC20.3 AC20.4
AC203 AC206
AC207 AC210
AC214 AC215
AC216 AC240
AC265 AC290
AC295 AC297
AC30.2 AC30.3
AC310 AC32.1
AC401 AC410
AC412 AC415
AC416 AC420
AC421 AC440
AC450 AC460
AC470 AC471
AC472 AC473
AC480 AC490
AC530 AC55.1
AC79.1 ACBA.1
AM220 AM221
AM222 AM223
...
MXLISTMBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLMSET1 OBJ-TYPE AC105 AC110
MATRIX-LIST AC112 AC115
SEQ-NUMBER AC120 AC121
AC123 AC127
AC13.3 AC13.4
AC13.5 AC130
AC14.1 AC160
AC165 AC170
AC190 AC191
AC196 AC20.1
AC20.2 AC20.3
AC20.4 AC203
AC206 AC207
AC210 AC214
AC215 AC216
...
MLMSET2 OBJ-TYPE AC13.1 AC13.4
OBJ-ID AC130 AC165
MATRIX-LIST AC170 AC191
AC256 AC530
AC65.1 AM220
AM221 AM222
AM223 AM224
AM225 AM23.1
AM23.4 AM230
AM235 AM240
AM245 AM250
AM255 AM260
AM265 AM275
AM277 AM280
AM285 AM290
...
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
|