|
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
|