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
AC10.1 AC45.1 AC50.1 AC500 AC560 AM125
AM135 BR44.1 CB10.1 CB15.1 CB15.2 CB20.1
CB50.1 CB500 CB55.1 HCDL.1 IC134 IC135
IC141 IC150 IC151 IC152 IC191 IC192
IC218 IC224 IC226 IC227 IC228 IC229
IC282 IC287 IC31.1 IC37.1 IC40.1 IC40.2
IC44.1 IC46.1 IFAC.1 MA278 PO275 PO276
PO277 PO280 MM280 MM80.1 MM80.2 RQ11.1
RQ250 RQ270 RQ41.1 RQ42.1 RQIB.1 RQIJ.1
AD191 AD290 AD50.1 AD95.1 AD96.1 AD97.1
AD97.2 AD97.3 AD98.1 AD98.2 AD98.3 FB100
FB101 FB141 FB20.1 FB20.6 FB20.7 FB21.1
FB215 GL294 RW00.1 RW215 RW230 RW270
RW299 RW30.1 RW70.1 GL16.4 GLAV.1 GLCV.1
GLOP.1 GLVW.1 IFBA.1 IFBO.1 IFOS.3 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 SLVW.1 SNGL.1 SNOA.1
SNOD.1 SNRA.1 SNSA.1 AC510 AMAS.1 AMDL.1
HCHP.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 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC200 AC203 AC206
AC207 AC210 AC213 AC218 AC220 AC225
AC240 AC246 AC247 AC256 AC261 AC265
AC290 AC295 AC297 AC298 AC30.1 AC30.2
AC30.3 AC300 AC310 AC311 AC32.1 AC34.1
AC346 AC35.1 AC36.1 AC37.1 AC400 AC401
AC410 AC412 AC420 AC421 AC440 AC460
AC471 AC472 AC473 AC480 AC490 AC493
AC494 AC52.1 AC520 AC527 AC55.1 AC580
AC581 AC583 AC90.1 AC90.2 AC90.4 AC90.6
AC90.8 AC92.1 AC92.2 AC92.4 AC92.6 AC93.1
AC93.2 AC93.3 AC93.4 AC93.5 AC94.1 AC94.2
AC94.4 AC94.6 AC95.1 AC95.2 AC95.4 AC95.6
AC97.1 AC97.2 AC97.4 AC97.6 ACBA.1 ACDL.1
ACDM.2 ACDM.9 ACDR.1 ACVW.1 ATVW.1 SE90.1
AM115 AM117 AM120 AM145 AM15.1 AM15.2
AM15.3 AM15.4 AM180 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 AM35.3 AM45.1
AM45.3 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.1 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.5
CA10.7 CA110 FB11.1 FB111 FB160 FB211
FB220 FB296 FB60.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL110 GL122 GL191
GL194 GL256 GL291 GL292 GL293 GL298
GL299 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 RW100 RW80.1 DR100 IC02.5 IC02.6
IC11.1 IC140 IC142 IC145 IC220 IC222
IC223 IC231 IC233 IC234 IC243 IC247
IC30.1 IC55.1 IC55.2 IC56.3 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 ICBL.4 ICLM.1 GL121 GL125 GL20.1
GL21.2 GL22.2 GLAC.1 GLBL.1 MX10.2 MX10.3
MX123 MX202 MX223 MX500 MA180 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 MA530 MA531 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
PO04.7 PO04.8 PO10.1 PO100 PO101 PO120
PO122 PO131 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.2 PO22.3 PO22.4 PO22.5
PO220 PO222 PO223 PO23.1 PO233 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO253 PO254
PO258 PO27.2 PO278 PO28.2 PO285 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 PO536 PO54.1 PO54.2
PO54.3 PO54.4 PO54.5 PO58.1 PO58.2 POBL.1
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 RQ01.4 RQ01.5 RQ10.1 RQ10.2 RQ10.4
RQ111 RQ12.1 RQ13.1 RQ13.2 RQ230 RQ235
RQ240 RQ260 RQ35.1 RQ50.1 RQ500 RQBL.1
RQIF.1 SLBL.1 SN02.1 SNAC.1 WACP.1 WAOP.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 ZW130

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
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 11:18:49 2016

Home
Contact Us



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