Lawson Insight Technical Documentation |
|
MXLISTHDR
MXLISTHDR FILE
Attribute List Header
This file contains attribute list header category values that can be sorted
by a maximum of eight categories. The accounting units on the list can be used
individually, or combined into a total.
REFERENCED BY
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC255
AC256 AC300 AC37.1 AC52.1 AC581 AC62.1
AM180 BR124 CA110 FB100 FB11.1 FB111
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 GL100 GL256 GL298 GL55.1
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 RW10.2 RW10.3 RW10.4 RW10.6 RW10.7
RW100 RW20.5 RW20.6 RW230 RW270 RW298
RW30.1 RW60.1 RW60.4 RW70.1 GL00.1 GL00.3
GL02.1 GL02.2 GL02.3 GL13.1 GL160 GL60.1
GLAV.1 GLCV.1 GLVW.1 IFBO.1 IFOS.1 JB00.1
MX00.3 MX20.1 MX202 MX210 MX223 MA278
SLVW.1 SN60.1 SN60.2 SN70.2 SNFL.1 SNOA.1
SNRA.1 SNSA.1
UPDATED BY
AC00.1 AC01.1 AC03.7 AC10.1 AC10.3 AC105
AC110 AC112 AC113 AC12.1 AC120 AC121
AC123 AC128 AC13.1 AC13.2 AC13.3 AC13.4
AC13.5 AC130 AC135 AC14.1 AC14.2 AC14.3
AC14.4 AC14.5 AC145 AC16.1 AC16.2 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
AC473 AC480 AC490 AC493 AC494 AC500
AC510 AC520 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 AM170 AM19.1 AM19.2 AM20.1 AM20.2
AM20.3 AM20.4 AM20.5 AM20.6 AM21.1 AM21.2
AM21.3 AM21.4 AM21.5 AM21.6 AM214 AM220
AM221 AM222 AM223 AM224 AM225 AM23.1
AM23.2 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 AM96.1 AM97.1 AM98.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
AR09.1 AR10.1 AR112 AR115 AR12.1 AR12.2
AR120 AR124 AR129 AR13.1 AR13.2 AR130
AR131 AR135 AR137 AR150 AR17.1 AR170
AR180 AR190 AR194 AR20.1 AR21.1 AR21.2
AR21.3 AR210 AR211 AR217 AR222 AR223
AR227 AR228 AR229 AR23.1 AR23.2 AR23.3
AR23.4 AR23.5 AR230 AR232 AR233 AR235
AR237 AR238 AR239 AR24.1 AR245 AR250
AR251 AR253 AR257 AR258 AR264 AR265
AR27.2 AR271 AR275 AR28.1 AR282 AR285
AR29.1 AR29.2 AR29.3 AR290 AR291 AR292
AR293 AR294 AR296 AR30.1 AR30.5 AR30.8
AR300 AR301 AR32.1 AR33.1 AR33.2 AR33.3
AR33.6 AR34.1 AR35.1 AR35.2 AR37.1 AR37.2
AR37.3 AR37.4 AR37.5 AR37.6 AR37.7 AR38.1
AR38.2 AR38.3 AR38.5 AR39.1 AR39.2 AR39.3
AR39.4 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1
AR44.3 AR45.1 AR48.3 AR501 AR502 AR503
AR505 AR506 AR515 AR55.1 AR550 AR560
AR570 AR575 AR580 AR70.2 AR80.1 AR80.2
AR800 AR82.1 AR91.1 ARLL.1 BL02.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL232 BL29.1 BL29.2 BL290 BL520 BL802
BL820 BL92.1 BR10.1 BR10.4 BR10.8 BR120
BR121 BR13.1 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 CB06.2 CB145 CB170 CB175 CB180
CB186 CB187 CB191 CB210 CB215 CB220
CB221 CB260 CB286 DT150 DT155 DT160
DT165 DT166 DT180 DT181 DT30.1 DT30.2
DT40.1 DT45.1 DT520 DT60.1 DT60.2 DT70.1
DT70.3 DT80.1 DT85.1 DT85.2 DT90.1 DT92.1
ET700 CA10.1 CA10.7 GL110 GL120 GL191
RW80.1 IC02.6 ICBL.1 ICBL.2 ICLM.1 GL21.2
GL22.2 GLAC.1 GLBL.1 IFLU.1 MX10.1 MX10.2
MX10.3 MX123 MX135 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 PW110 PW510 PW550 RQ01.5 RQ10.1
RQ10.2 RQBL.1 SLBL.1 SN02.1 SNAC.1 TX140
WH110 WH130 WH20.2 WH20.7 WH226
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLH-OBJ-TYPE Alpha 5 AC00.1 AC03.7
Element: Object Type This field will determine the type of AC10.1 AC10.3
object that is being used by the AC110 AC112
Attribute. These values are not user AC12.1 AC120
maintainable. AC13.1 AC13.2
AC135 AC14.1
AC14.2 AC16.1
AC16.2 AC160
AC500 AC510
AC520 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM19.1 AM19.2
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM23.1 AM23.2
AM500 AM551
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
...
MLH-MATRIX-LIST Alpha 12 AC00.1 AC03.7
Element: Matrix List Attribute categories are selection AC10.1 AC10.3
parameters used to build a list of AC110 AC112
objects (accounting units). Attributes AC12.1 AC120
and values are the basis of the AC13.1 AC13.2
selection and sorting. An attribute can AC13.5 AC135
then be used for reporting on and AC14.1 AC14.2
processing "objects." AC14.5 AC16.1
AC16.2 AC16.5
AC160 AC500
AC510 AC520
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM23.1
AM23.2 AM23.5
AM500 AM551
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
MLH-DESCRIPTION Alpha 30 (Lower Case) AC13.5 AC14.5
Element: Description The attribute description. AC16.5 AM23.5
AR23.5 MX10.2
MX10.3 RW100
MLH-SHORT-DESC Derived
Element: Short DescriptThe short description.
MLH-SORT-MX-CAT Alpha 12 Occurs 8 Times AP03.4 CB01.6
Element: Sort Matrix CaConsists of up to eight attribute GL21.2 GL22.2
categories for sorting the selected MX10.2
objects. The attribute category does not
have to be a selection category in order
to be a sort category. The sort is in
ascending order.
MLH-CREATOR Alpha 15 AC13.5 AC14.5
Element: Creator User identification of the person AC16.5 AM23.5
creating the record. AR23.5 MX10.2
MX10.3
MLH-LIST-TYPE Alpha 1 AC13.4 AC14.4
Element: List Type Determines whether the list of objects AC16.4 AM23.4
was automatically created using AP03.4 AR23.4
parameters, or whether it was manually CB01.6 GL21.2
defined. A manual list will never be GL22.2 IC02.6
rebuilt by the system. MX10.1 PO04.8
RQ01.5
A = Automatic
M = Manual
MLH-LAST-MAINT-DT Numeric 8 (yyyymmdd) AC00.1 AC03.7
Element: Last MaintaineThe last date that the list was AC10.1 AC10.3
maintained. AC110 AC112
AC12.1 AC120
AC13.1 AC13.2
AC13.5 AC135
AC14.1 AC14.2
AC14.5 AC16.1
AC16.2 AC16.5
AC160 AC500
AC510 AC520
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM23.1
AM23.2 AM23.5
AM500 AM551
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
MLH-LAST-MAINT-TM Numeric 6 (hhmmss) AC00.1 AC03.7
Element: Last MaintaineThe last time that the list was AC10.1 AC10.3
maintained. AC110 AC112
AC12.1 AC120
AC13.1 AC13.2
AC13.5 AC135
AC14.1 AC14.2
AC14.5 AC16.1
AC16.2 AC16.5
AC160 AC500
AC510 AC520
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM23.1
AM23.2 AM23.5
AM500 AM551
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
MLH-LAST-BUILD-DT Numeric 8 (yyyymmdd) AC01.1 AC105
Element: Last Build DatThe last build date. AC112 AC113
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 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
...
MLH-LAST-BUILD-TM Numeric 6 (hhmmss) AC01.1 AC105
Element: Last Build TimThe last build time. AC112 AC113
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 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
...
MLH-LAST-SEQ-NBR Numeric 6 AC01.1 AC105
Element: Last Sequence The last sequence number. 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
...
MLH-UPDATE-FLAG Alpha 1 MX10.2
Element: Update Flag This field determines how the List will
be rebuilt. System option means the
programs using the list will rebuilt it.
User option means the list will only be
rebuilt when done by a user.
S = System
U = User
MLH-SEGMENT Alpha 15 MX10.2
Element: Segment The name that identifies the user
analysis.
A user analysis is a flexible,
user-defined element, much like an
accounting unit, account, or attribute,
that stores transaction information you
can use for reports and analysis.
You can use a user analysis to track
multiple elements of business data.
MLH-ARRAY1 Derived
Element: Array1 Used for Drill Around purposes.
MLH-ARRAY2 Derived
Element: Array2 Used for Drill Around purposes.
MLH-ARRAY3 Derived
Element: Array3 Used for Drill Around purposes.
MLH-ARRAY4 Derived
Element: Array4 Used for Drill Around purposes.
MLH-ARRAY5 Derived
Element: Array5 Used for Drill Around purposes.
MLH-ARRAY6 Derived
Element: Array6 Used for Drill Around purposes.
MLH-ARRAY7 Derived
Element: Array7 Used for Drill Around purposes.
MLH-ARRAY8 Derived
Element: Array8 Used for Drill Around purposes.
MLH-SORT-MX-CAT-1 Derived
Element: Sort Category Attribute sort category 1. Attribute
lists can be sorted using up to eight
categories.
MLH-SORT-MX-CAT-2 Derived
Element: Sort Category Attribute sort category 2.
MLH-SORT-MX-CAT-3 Derived
Element: Sort Category Attribute sort category 3.
MLH-SORT-MX-CAT-4 Derived
Element: Sort Category Attribute sort category 4.
MLH-SORT-MX-CAT-5 Derived
Element: Sort Category Attribute sort category 5.
MLH-SORT-MX-CAT-6 Derived
Element: Sort Category Attribute sort category 6.
MLH-SORT-MX-CAT-7 Derived
Element: Sort Category Attribute sort category 7.
MLH-SORT-MX-CAT-8 Derived
Element: Sort Category Attribute sort category 8.
MXLISTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLHSET1 OBJ-TYPE AC00.1 AC01.1
MATRIX-LIST AC03.7 AC10.1
AC10.3 AC105
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC128
AC13.1 AC13.2
AC13.3 AC13.4
AC13.5 AC130
AC135 AC14.1
AC14.2 AC14.3
AC14.4 AC14.5
AC145 AC16.1
AC16.2 AC16.3
...
MXLISTHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Matrix Cat 1 MXOBJCAT Not Required
MLH-OBJ-TYPE -> MOC-OBJ-TYPE
MLH-SORT-MX-CAT-1 -> MOC-MATRIX-CAT
Matrix Cat 2 MXOBJCAT Not Required
MLH-OBJ-TYPE -> MOC-OBJ-TYPE
MLH-SORT-MX-CAT-2 -> MOC-MATRIX-CAT
Matrix Cat 3 MXOBJCAT Not Required
MLH-OBJ-TYPE -> MOC-OBJ-TYPE
MLH-SORT-MX-CAT-3 -> MOC-MATRIX-CAT
Matrix Cat 4 MXOBJCAT Not Required
MLH-OBJ-TYPE -> MOC-OBJ-TYPE
MLH-SORT-MX-CAT-4 -> MOC-MATRIX-CAT
Matrix Cat 5 MXOBJCAT Not Required
MLH-OBJ-TYPE -> MOC-OBJ-TYPE
MLH-SORT-MX-CAT-5 -> MOC-MATRIX-CAT
Matrix Cat 6 MXOBJCAT Not Required
MLH-OBJ-TYPE -> MOC-OBJ-TYPE
MLH-SORT-MX-CAT-6 -> MOC-MATRIX-CAT
Matrix Cat 7 MXOBJCAT Not Required
MLH-OBJ-TYPE -> MOC-OBJ-TYPE
MLH-SORT-MX-CAT-7 -> MOC-MATRIX-CAT
Matrix Cat 8 MXOBJCAT Not Required
MLH-OBJ-TYPE -> MOC-OBJ-TYPE
MLH-SORT-MX-CAT-8 -> MOC-MATRIX-CAT
Object Id OBJID Required
MLH-OBJ-TYPE -> OBI-OBJ-TYPE
MXLISTHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mxlistdtl MXLISTDTL Delete Cascades
MLH-OBJ-TYPE -> MLD-OBJ-TYPE
MLH-MATRIX-LIST -> MLD-MATRIX-LIST
MLD-OR-GROUP
MLD-MATRIX-CAT
MLD-SEQ-NUMBER
Mxlistmbr MXLISTMBR Delete Cascades
MLH-OBJ-TYPE -> MLM-OBJ-TYPE
MLH-MATRIX-LIST -> MLM-MATRIX-LIST
MLM-SEQ-NUMBER
Used In View MXVIEWDTL Delete Restricted
MLH-OBJ-TYPE -> MVD-OBJ-TYPE
MLH-MATRIX-LIST -> MVD-SUMMARY-LVL
MVD-OBJ-ID
|