|
|
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
AC300 AC37.1 AC52.1 AC520 AC581 ACDR.1
AM145 AM180 CA110 FB100 FB101 FB11.1
FB111 FB141 FB160 FB20.1 FB20.6 FB20.7
FB21.1 FB211 FB296 FB60.1 FB95.1 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 GL256 GL292
GL293 GL294 GL298 GL90.6 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 AC10.1 AC50.1 AC500
AC510 AM125 AM135 AMAS.1 AMDL.1 BR44.1
CB10.1 CB15.1 CB15.2 CB20.1 CB500 HCHP.1
IC222 IFAC.1
UPDATED BY
AC00.1 AC01.1 AC105 AC112 AC113 AC120
AC121 AC123 AC13.3 AC13.4 AC13.5 AC13.1
AC130 AC135 AC14.3 AC14.4 AC14.5 AC14.1
AC145 AC160 AC165 AC190 AC191 AC197
AC198 AC200 AC203 AC206 AC207 AC210
AC213 AC218 AC220 AC240 AC246 AC261
AC265 AC290 AC295 AC298 AC30.3 AC310
AC32.1 AC34.1 AC346 AC35.1 AC36.1 AC400
AC401 AC410 AC412 AC420 AC421 AC440
AC460 AC471 AC472 AC473 AC480 AC490
AC493 AC494 AC55.1 AC580 AC583 AC90.1
AC92.1 AC93.1 AC94.1 AC95.1 ACBA.1 ACDL.1
ACDM.2 ACVW.1 SE90.1 AM115 AM117 AM120
AM15.1 AM15.2 AM15.3 AM15.4 AM20.1 AM20.3
AM21.1 AM21.3 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 AM310 AM320
AM35.1 AM45.1 AM500 AM501 AM51.1 AM551
AM70.4 AM88.1 AM97.1 AMBL.1 AP03.3 AP03.4
AP211 AP510 API3.1 API4.1 AR135 AR170
AR210 AR211 AR222 AR23.3 AR23.4 AR23.5
AR232 AR235 AR250 AR251 AR253 AR271
AR275 AR290 AR293 AR294 AR30.5 AR33.2
BL232 BR120 BR121 BR130 BR131 BR140
BR142 BR145 BR165 BR19.2 BR190 BR20.9
BR200 BR202 BR204 BR205 BR210 BR212
BR215 BR220 BR245 BR265 BR300 BR400
BR405 BR430 BR450 BR521 BR530 BR580
BRCC.1 CB01.6 CB01.7 CA10.1 CA10.7 GL191
RW80.1 IC840 GL21.2 GL22.2 GLAC.1 GLBL.1
MX10.2 MX10.3 MX123 MX500 OE280 OE285
OE290 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 UK47.1 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 AC14.3
AC14.4 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC240 AC246
AC261 AC265
AC290 AC295
AC298 AC30.3
AC310 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC400 AC401
AC410 AC412
AC420 AC421
AC440 AC460
AC471 AC472
AC473 AC480
AC490 AC493
AC494 AC55.1
AC580 AC583
...
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 AC14.3 AC14.4
and processing "objects." AC14.5 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC240 AC246
AC261 AC265
AC290 AC295
AC298 AC30.3
AC310 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC400 AC401
AC410 AC412
AC420 AC421
AC440 AC460
AC471 AC472
AC473 AC480
AC490 AC493
AC494 AC55.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 AC14.3
AC14.4 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC240 AC246
AC261 AC265
AC290 AC295
AC298 AC30.3
AC310 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC400 AC401
AC410 AC412
AC420 AC421
AC440 AC460
AC471 AC472
AC473 AC480
AC490 AC493
AC494 AC55.1
AC580 AC583
...
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 AC14.3
AC14.4 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC240 AC246
AC261 AC265
AC290 AC295
AC298 AC30.3
AC310 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC400 AC401
AC410 AC412
AC420 AC421
AC440 AC460
AC471 AC472
AC473 AC480
AC490 AC493
AC494 AC55.1
AC580 AC583
...
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
AC14.3 AC14.4
AC14.5 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC200
AC203 AC206
...
MLMSET2 OBJ-TYPE AC00.1 AC10.1
OBJ-ID AC112 AC113
MATRIX-LIST AC121 AC123
AC13.1 AC13.2
AC13.4 AC13.7
AC135 AC14.1
AC14.2 AC14.4
AC14.6 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
...
MXLISTMBR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
MLM-OBJ-ID -> AGP-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
Apvenmast APVENMAST Required
MLM-OBJ-ID -> VEN-AP-OBJ-ID
Itemmast ITEMMAST Required
MLM-OBJ-ID -> ITE-IC-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
|
