MXLISTMBR

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 AC305
AC37.1 AC52.1 AC520 AC581 ACDR.1 AD191
AD290 AD50.1 AD95.1 AD96.1 AD97.1 AD97.2
AD97.3 AD98.1 AD98.2 AD98.3 AM145 AM180
CA110 FB100 FB101 FB11.1 FB111 FB141
FB160 FB20.1 FB20.6 FB20.7 FB21.1 FB211
FB215 FB220 FB296 FB60.1 FB95.1 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 GL194 GL256
GL291 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 IC220 IC222 IC223 IC231 IC233
IC234 IC247 IC30.1 IC55.1 IC55.2 GL125
GL16.4 GLAV.1 GLCV.1 GLOP.1 GLVW.1 IFBA.1
IFBO.1 IFOS.3 MX202 MX223 ML292 ML293
ML94.1 ML94.2 ML94.3 ML94.4 ML95.1 ML95.2
ML95.3 ML95.4 ML95.5 ML95.6 ML95.7 ML95.8
ML95.9 ML96.1 ML96.2 ML96.3 ML96.4 ML96.5
ML97.1 ML97.2 ML97.3 ML97.4 ML97.5 ML97.6
ML97.7 ML97.8 ML97.9 ML98.1 ML98.2 ML98.3
ML98.4 ML98.5 ML99.1 ML99.2 ML99.3 ML99.4
ML99.5 ML99.6 PO258 PO285 PO58.1 PO58.2
RQ111 RQ191 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 AM55.1 AMAS.1 AMDL.1 BR44.1
CB10.1 CB15.1 CB15.2 CB20.1 CB50.1 CB500
CB55.1 HCDL.1 HCHP.1 IC134 IC135 IC150
IC151 IC152 IC191 IC192 IC193 IC218
IC224 IC226 IC227 IC228 IC229 IC282
IC287 IC31.1 IC37.1 IC40.1 IC40.2 IC44.1
IC46.1 PC190 IFAC.1 MM280 MM80.1 MM80.2
RQ250 RQ270 RQ41.1 RQ42.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 AC147 AC16.3 AC16.4 AC16.5
AC16.1 AC16.2 AC160 AC165 AC169 AC190
AC191 AC196 AC197 AC198 AC200 AC203
AC206 AC207 AC210 AC213 AC218 AC220
AC225 AC240 AC246 AC247 AC256 AC261
AC265 AC290 AC295 AC297 AC298 AC30.3
AC300 AC310 AC311 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 AC97.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
AM22.1 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
AP271 AP30.2 AP30.4 AP300 AP305 AP510
AP90.1 AP91.1 API1.1 API2.1 API3.1 API4.1
ZA161 AR210 AR211 AR217 AR23.3 AR23.4
AR23.5 AR301 ARLL.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 CB222 CB260 CB286 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 CA10.1 CA10.4 CA10.7
GL122 GL191 GL299 RW80.1 DR100 IC02.6
IC12.1 IC140 IC141 IC142 IC145 IC243
IC330 IC56.4 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 IC840 ICBL.1 ICBL.2 ICLM.1 GL121
GL21.2 GL22.2 GLAC.1 GLBL.1 MX10.2 MX10.3
MX123 MX500 MA126 MA180 MA278 MA279
MA41.1 MA41.2 MA41.4 MA41.7 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA44.1 MA44.2 MA53.1 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA69.1 MA70.1 MA75.1 MA80.1 MAI1.1 ML191
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD230 PD235 PD570 PO04.1 PO04.2 PO04.8
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO192 PO195
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.2 PO22.3
PO22.4 PO22.5 PO220 PO222 PO223 PO224
PO225 PO229 PO23.1 PO230 PO233 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO253 PO254 PO26.3 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO278
PO28.2 PO280 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 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
PO529 PO536 PO54.1 PO54.2 PO54.3 PO54.4
PO54.5 POBL.1 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 RQ01.1 RQ01.5 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ260 RQ35.1 RQ44.1 RQ500 RQ810
RQBL.1 RQIB.1 RQIF.1 RQII.1 RQIJ.1 SLBL.1
SN02.1 SNAC.1 WH110 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH226 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 GL110 IC11.1 GL20.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLM-OBJ-TYPE
Element: Object Type
Alpha 5
This field determines the type of object used by the Attribute. These values are not user maintainable.
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC13.3 AC13.4
AC130 AC135
AC14.3 AC14.4
AC145 AC147
AC16.3 AC16.4
AC160 AC165
AC169 AC190
AC191 AC196
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC225 AC240
AC246 AC247
AC256 AC261
AC265 AC290
AC295 AC297
AC298 AC30.3
AC310 AC311
AC32.1 AC34.1
AC346 AC35.1
AC36.1 AC400
AC401 AC410
AC412 AC420
AC421 AC440
MLM-MATRIX-LIST
Element: Matrix List
Alpha 12
Attribute categories are selection parameters used to build a list of objects (accounting units). Attribute categories and values are the basis of the selection and sorting. A attribute list can then be used for reporting on and processing "objects."
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC13.3 AC13.4
AC13.5 AC130
AC135 AC14.3
AC14.4 AC14.5
AC145 AC147
AC16.3 AC16.4
AC16.5 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
AC240 AC246
AC247 AC256
AC261 AC265
AC290 AC295
AC297 AC298
AC30.3 AC310
AC311 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC400 AC401
AC410 AC412
MLM-SEQ-NUMBER
Element: Sequence Number
Numeric 6
A unique number assigned to each transaction transferred into the Lawson system.
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC13.3 AC13.4
AC130 AC135
AC14.3 AC14.4
AC145 AC147
AC16.3 AC16.4
AC160 AC165
AC169 AC190
AC191 AC196
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC225 AC240
AC246 AC247
AC256 AC261
AC265 AC290
AC295 AC297
AC298 AC30.3
AC310 AC311
AC32.1 AC34.1
AC346 AC35.1
AC36.1 AC400
AC401 AC410
AC412 AC420
AC421 AC440
MLM-OBJ-ID
Element: Object ID
Numeric 12
The unique object identifier.
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC13.3 AC13.4
AC130 AC135
AC14.3 AC14.4
AC145 AC147
AC16.3 AC16.4
AC160 AC165
AC169 AC190
AC191 AC196
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC225 AC240
AC246 AC247
AC256 AC261
AC265 AC290
AC295 AC297
AC298 AC30.3
AC310 AC311
AC32.1 AC34.1
AC346 AC35.1
AC36.1 AC400
AC401 AC410
AC412 AC420
AC421 AC440


MXLISTMBR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLMSET1 OBJ-TYPE
MATRIX-LIST
SEQ-NUMBER
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC13.3 AC13.4
AC13.5 AC130
AC135 AC14.3
AC14.4 AC14.5
AC145 AC147
AC16.3 AC16.4
AC16.5 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC20.1
MLMSET2 OBJ-TYPE
OBJ-ID
MATRIX-LIST
...
AC00.1 AC10.1
AC112 AC113
AC121 AC123
AC128 AC13.1
AC13.2 AC13.4
AC13.7 AC130
AC135 AC14.1
AC14.2 AC14.4
AC14.6 AC145
AC147 AC16.1
AC16.2 AC16.4
AC16.7 AC16.8
AC16.9 AC160
AC165 AC169
AC190 AC191


MXLISTMBR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Gmgrant GMGRANT Required
MLM-OBJ-ID->GRN-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
NAME
RELATED 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


File created: Thu Jun 09 02:20:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.