|
|
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
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC256
AC37.1 AC52.1 AC520 AM145 AM180 CA110
FB100 FB101 FB11.1 FB111 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 GLOP.1 GLVW.1 IFBA.1 IFBO.1 IFOS.3
MX202 MX223 SLVW.1 AC541 AM125 AM135
AMAS.1 AMDL.1 AP125 AP126 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 API1.1 API2.1 CB10.1
CB15.1 CB15.2 CB20.1 CB500 IC222 IFAC.1
MA41.2 MA41.7 MA43.2 MA61.1 MAI1.1 MM280
MM80.1 MM80.2
UPDATED BY
AC01.1 AC105 AC112 AC113 AC120 AC121
AC123 AC13.3 AC13.4 AC13.5 AC13.1 AC130
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 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 AM330 AM35.1
AM45.1 AM501 AM70.4 AM88.1 AMBL.1 AR250
AR251 AR30.5 BR120 BR121 BR130 BR131
BR142 BR151 BR152 BR153 BR154 BR155
BR156 BR157 BR165 BR200 BR202 BR204
BR205 BR210 BR215 BR220 BR251 BR252
BR253 BR254 BR265 BR400 BR405 BR420
BR430 BR450 BR521 BR530 BR900 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
Element: Object Type This field determines the type of AC112 AC113
object used by the Attribute. These AC120 AC121
values are not user maintainable. AC123 AC13.3
AC13.4 AC130
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
...
MLM-MATRIX-LIST Alpha 12 AC01.1 AC105
Element: Matrix List Attribute categories are selection AC112 AC113
parameters used to build a list of AC120 AC121
objects (accounting units). Attribute AC123 AC13.3
categories and values are the basis of AC13.4 AC13.5
the selection and sorting. A attribute AC130 AC135
list can then be used for reporting on AC160 AC165
and processing "objects." 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
...
MLM-SEQ-NUMBER Numeric 6 AC01.1 AC105
Element: Sequence NumbeA unique number assigned to each AC112 AC113
transaction transferred into the Lawson AC120 AC121
system. AC123 AC13.3
AC13.4 AC130
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
...
MLM-OBJ-ID Numeric 12 AC01.1 AC105
Element: Object ID The unique object identifier. AC112 AC113
AC120 AC121
AC123 AC13.3
AC13.4 AC130
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
...
MXLISTMBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLMSET1 OBJ-TYPE AC01.1 AC105
MATRIX-LIST AC112 AC113
SEQ-NUMBER AC120 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
...
MLMSET2 OBJ-TYPE AC13.1 AC13.4
OBJ-ID AC130 AC190
MATRIX-LIST AC191 AC256
AC530 AC541
AM120 AM125
AM135 AM214
AM220 AM221
AM222 AM223
AM224 AM225
AM23.4 AM23.5
AM230 AM235
AM240 AM245
AM25.1 AM25.3
AM250 AM255
AM260 AM265
...
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
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
|
