Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXLISTMBR


                             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     RW215
RW230     RW270     RW299     RW30.1    RW70.1    IC30.1
GL16.4    GLAV.1    GLCV.1    GLOP.1    GLVW.1    IFBA.1
IFBO.1    IFOS.3    MX202     MX223     PO258     PO285
PO58.1    PO58.2    RQ111     RQ230     RQ235     RQ240
RQ50.1    SLVW.1    SNGL.1    SNOA.1    SNOD.1    SNRA.1
SNSA.1    AC10.1    AC45.1    AC50.1    AC500     AC510
AC560     AM125     AM135     AMAS.1    AMDL.1    BR44.1
CB10.1    CB15.1    CB15.2    CB20.1    CB50.1    CB500
CB55.1    HCDL.1    HCHP.1    IFAC.1    MA278     PO275
PO276     PO277     PO280     PW110     PW510     MM280
MM80.1    MM80.2    RQ11.1    RQ13.2    RQ250     RQ35.1
RQ41.1    RQ42.1    RQ500     RQIB.1    RQIF.1    RQIJ.1


UPDATED BY

AC00.1    AC01.1    AC105     AC112     AC113     AC120
AC121     AC123     AC128     AC13.3    AC13.4    AC13.5
AC13.1    AC130     AC135     AC14.3    AC14.4    AC14.5
AC14.1    AC145     AC16.3    AC16.4    AC16.5    AC16.1
AC16.2    AC160     AC165     AC169     AC190     AC191
AC197     AC198     AC200     AC203     AC206     AC207
AC210     AC213     AC218     AC220     AC225     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     AC527     AC55.1
AC580     AC583     AC90.1    AC92.1    AC93.1    AC94.1
AC95.1    ACBA.1    ACDL.1    ACDM.2    ACDM.9    ACVW.1
ATVW.1    SE90.1    AM115     AM117     AM120     AM15.1
AM15.2    AM15.3    AM15.4    AM19.1    AM19.2    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     AM330     AM35.1    AM45.1    AM500     AM501
AM51.1    AM551     AM70.4    AM88.1    AM97.1    AMBL.1
AP03.3    AP03.4    AP110     AP115     AP125     AP126
AP131     AP150     AP155     AP160     AP161     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP21.1
AP210     AP211     AP220     AP23.1    AP25.1    AP25.2
AP26.1    AP265     AP27.1    AP30.2    AP30.4    AP305
AP510     AP90.1    AP91.1    API1.1    API2.1    API3.1
API4.1    AR120     AR129     AR130     AR131     AR135
AR170     AR21.2    AR210     AR211     AR217     AR222
AR223     AR227     AR228     AR229     AR23.3    AR23.4
AR23.5    AR230     AR232     AR233     AR235     AR237
AR238     AR239     AR245     AR250     AR251     AR253
AR257     AR258     AR264     AR265     AR27.2    AR271
AR275     AR282     AR285     AR29.1    AR290     AR291
AR292     AR293     AR294     AR296     AR30.5    AR300
AR301     AR32.1    AR33.2    AR38.5    AR39.3    AR39.4
AR42.1    AR42.2    AR42.7    AR43.1    AR502     AR503
AR55.1    AR560     AR575     AR800     AR91.1    ARLL.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL232     BL29.1    BL29.2    BL290     BL520
BL820     BL92.1    BR120     BR121     BR130     BR131
BR140     BR142     BR145     BR151     BR152     BR153
BR154     BR155     BR156     BR157     BR165     BR19.2
BR190     BR20.9    BR200     BR202     BR204     BR205
BR210     BR212     BR215     BR220     BR245     BR251
BR252     BR253     BR254     BR265     BR300     BR400
BR405     BR422     BR430     BR450     BR521     BR530
BR580     CB01.6    CB01.7    CB145     CB170     CB175
CB180     CB186     CB187     CB210     CB215     CB220
CB221     CB260     CB286     ET700     CA10.1    CA10.7
GL191     RW80.1    IC02.6    ICBL.1    ICBL.2    ICLM.1
GL21.2    GL22.2    GLAC.1    GLBL.1    MX10.2    MX10.3
MX123     MX500     MA180     MA279     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.4
MA43.6    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA63.1    MA65.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PD230     PD235     PO04.8
PO10.1    PO100     PO101     PO120     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO220     PO223     PO23.1    PO233     PO24.1
PO25.1    PO25.5    PO25.6    PO25.7    PO253     PO254
PO27.2    PO278     PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO32.4    PO33.1
PO34.1    PO35.1    PO36.1    PO36.2    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     PO536
PO54.1    PO54.2    PO54.3    PO54.4    POBL.1    POI3.1
POID.1    POII.1    POIJ.1    PR05.1    PR05.3    PR226
PR247     PR26.1    PR47.1    PR514     UK47.1    RQ01.5
RQ10.1    RQ10.2    RQBL.1    SLBL.1    SN02.1    SNAC.1
WH110     WH130     WH20.2    WH20.7    WH226     GL110
IC11.1    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   AC128
                                                                 AC13.3  AC13.4
                                                                 AC130   AC135
                                                                 AC14.3  AC14.4
                                                                 AC145   AC16.3
                                                                 AC16.4  AC160
                                                                 AC165   AC169
                                                                 AC190   AC191
                                                                 AC197   AC198
                                                                 AC200   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC220
                                                                 AC225   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
                                                                 ...

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   AC128
                       categories and values are the basis of    AC13.3  AC13.4
                       the selection and sorting. A attribute    AC13.5  AC130
                       list can then be used for reporting on    AC135   AC14.3
                       and processing "objects."                 AC14.4  AC14.5
                                                                 AC145   AC16.3
                                                                 AC16.4  AC16.5
                                                                 AC160   AC165
                                                                 AC169   AC190
                                                                 AC191   AC197
                                                                 AC198   AC200
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 AC220   AC225
                                                                 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
                                                                 ...

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   AC128
                                                                 AC13.3  AC13.4
                                                                 AC130   AC135
                                                                 AC14.3  AC14.4
                                                                 AC145   AC16.3
                                                                 AC16.4  AC160
                                                                 AC165   AC169
                                                                 AC190   AC191
                                                                 AC197   AC198
                                                                 AC200   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC220
                                                                 AC225   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
                                                                 ...

MLM-OBJ-ID             Numeric 12                                AC01.1  AC105
Element: Object ID     The unique object identifier.             AC112   AC113
                                                                 AC120   AC121
                                                                 AC123   AC128
                                                                 AC13.3  AC13.4
                                                                 AC130   AC135
                                                                 AC14.3  AC14.4
                                                                 AC145   AC16.3
                                                                 AC16.4  AC160
                                                                 AC165   AC169
                                                                 AC190   AC191
                                                                 AC197   AC198
                                                                 AC200   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC220
                                                                 AC225   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
                                                                 ...

                         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   AC128
                                                                 AC13.3  AC13.4
                                                                 AC13.5  AC130
                                                                 AC135   AC14.3
                                                                 AC14.4  AC14.5
                                                                 AC145   AC16.3
                                                                 AC16.4  AC16.5
                                                                 AC160   AC165
                                                                 AC169   AC190
                                                                 AC191   AC197
                                                                 AC198   AC20.1
                                                                 AC20.2  AC20.3
                                                                 ...

MLMSET2   OBJ-TYPE                                               AC00.1  AC10.1
          OBJ-ID                                                 AC112   AC113
          MATRIX-LIST                                            AC121   AC123
                                                                 AC128   AC13.1
                                                                 AC13.2  AC13.4
                                                                 AC13.7  AC130
                                                                 AC135   AC14.1
                                                                 AC14.2  AC14.4
                                                                 AC14.6  AC145
                                                                 AC16.1  AC16.2
                                                                 AC16.4  AC16.7
                                                                 AC16.8  AC16.9
                                                                 AC160   AC165
                                                                 AC169   AC190
                                                                 AC191   AC197
                                                                 ...

                         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

Buyer          BUYER        Required

                            MLM-OBJ-ID         -> BUY-BUY-OBJ-ID

Cashcode       CBCPYCASH    Not Required
                            Valid When MLM-OBJ-TYPE = "CSHCD"

                            MLM-OBJ-ID         -> CBY-OBJ-ID

Iclocation     ICLOCATION   Required

                            MLM-OBJ-ID         -> ICL-ICL-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

Rqloc          RQLOC        Required

                            MLM-OBJ-ID         -> RQL-RQL-OBJ-ID

                         MXLISTMBR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accatsum       ACCATSUM

                            MLM-OBJ-ID         -> SRS-OBJ-ID
                                                  SRS-STRUCTURE
                                                  SRS-SUM-ACCT-CAT

Accatsumx      ACCATSUMX

                            MLM-OBJ-ID         -> SRX-OBJ-ID
                                                  SRX-STRUCTURE
                                                  SRX-ACCT-CATEGORY