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 AM125 AM135 AMAS.1 AMDL.1 CB10.1
CB15.1 CB15.2 CB20.1 CB50.1 CB500 CB55.1
HCDL.1 HCHP.1 IFAC.1 MM280


UPDATED BY
AC00.1 AC200 AC210 ACVW.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 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 AP30.2 AP30.4 AP305 AP510 AP90.1
AP91.1 API1.1 API2.1 API3.1 API4.1 AR210
AR211 AR217 AR23.3 AR23.4 AR23.5 AR301
CB01.6 CB01.7 CB145 CB170 CB175 CB180
CB186 CB187 CB210 CB215 CB220 CB221
CB222 CB260 CB286 CA10.1 CA10.7 CA10.5
GL122 GL191 GL299 RW80.1 ICLM.1 GL121
GL21.2 GL21.1 GL22.2 GL22.1 GLAC.1 GLBL.1
MX10.2 MX10.3 MX123 MX500 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MAI1.1 PO04.8 PO04.7 PO10.1
PO136 PO190 PO300 PO520 POBL.1 POCP.1
POI3.1 POII.1 POIJ.1 PR05.1 PR05.3 PR226
PR247 PR26.1 PR47.1 PR514 UK47.1 RQ01.5
RQ01.4 RQBL.1 SLBL.1 SN02.1 SNAC.1 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 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 GL125 GL16.4 GLAV.1 GLCV.1 GLOP.1
GLVW.1 IFBA.1 IFBO.1 IFOS.3 MX202 MX223
RQ50.1 SLVW.1 SNGL.1 SNOA.1 SNOD.1 SNRA.1
SNSA.1 GL110 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. 		...
AC200 AC210
ACVW.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 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
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." 		...
AC200 AC210
ACVW.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
MLM-SEQ-NUMBER
Element: Sequence Number		Numeric 6
A unique number assigned to each transaction transferred into the Lawson system. 		...
AC200 AC210
ACVW.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 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
MLM-OBJ-ID
Element: Object ID		Numeric 12
The unique object identifier. 		...
AC200 AC210
ACVW.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 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


MXLISTMBR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLMSET1 OBJ-TYPE
MATRIX-LIST
SEQ-NUMBER
...
AC200 AC210
ACVW.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 AM220
AM221 AM222
AM223 AM224
AM225 AM23.3
AM23.4 AM23.5
AM230 AM235
MLMSET2 OBJ-TYPE
OBJ-ID
MATRIX-LIST
...
AC00.1 AC10.1
AC200 AC210
AM120 AM125
AM135 AM214
AM220 AM221
AM222 AM223
AM224 AM225
AM23.4 AM23.5
AM230 AM235
AM240 AM245
AM25.1 AM25.3
AM250 AM255
AM260 AM265
AM267 AM270
AM275 AM277


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: Wed Jun 08 20:49:46 2016

Home
Contact Us



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