 |
Lawson Insight Technical Documentation |
|
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
AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC52.1 AC62.1 AM180 CA110 FB100 FB11.1
FB20.1 FB20.6 FB20.7 FB21.1 FB211 FB296
FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
GL100 GL256 GL298 GL55.1 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
JB00.1 MX20.1 MX202 MX210 MX223 SLVW.1
UPDATED BY
AC00.1 AC01.1 AC03.2 AC10.1 AC10.3 AC105
AC110 AC112 AC12.1 AC120 AC121 AC123
AC13.1 AC13.2 AC13.3 AC13.4 AC13.5 AC135
AC160 AC165 AC190 AC191 AC196 AC198
AC203 AC206 AC207 AC210 AC213 AC218
AC220 AC240 AC258 AC261 AC265 AC290
AC295 AC297 AC298 AC30.3 AC310 AC32.1
AC34.1 AC35.1 AC36.1 AC400 AC401 AC410
AC412 AC420 AC421 AC440 AC460 AC471
AC472 AC473 AC480 AC490 AC493 AC494
AC500 AC510 AC520 AC530 AC55.1 AC90.1
AC92.1 AC93.1 AC94.1 AC95.1 AC97.1 ACBA.1
ACVW.1 DA233 DA240 GR240 SE90.1 AM115
AM120 AM15.1 AM15.2 AM15.3 AM15.4 AM170
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 AM320 AM35.1
AM45.1 AM500 AM551 AM70.4 AM88.1 AM96.1
AM98.1 AMBL.1 AR250 AR251 AR30.5 BR02.2
BR02.3 BR11.1 BR120 BR121 BR130 BR131
BR142 BR165 BR200 BR202 BR204 BR205
BR210 BR220 BR265 BR400 BR405 BR420
BR430 BR450 BRCC.1 CA10.1 CA10.7 GL110
GL120 GL191 RW80.1 GL21.2 GL22.2 GLAC.1
GLBL.1 IFLU.1 MX10.1 MX10.2 MX10.3 MX123
MX500 SLBL.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLH-OBJ-TYPE Alpha 5 AC00.1 AC03.2
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
AC500 AC510
AC520 AM115
AM15.1 AM15.2
AM15.3 AM15.4
AM170 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 BR02.2
BR02.3 BR11.1
GL110 GL120
IFLU.1 MX10.2
MLH-MATRIX-LIST Alpha 12 AC00.1 AC03.2
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 AC500
then be used for reporting on and AC510 AC520
processing "objects." AM115 AM15.1
AM15.2 AM15.3
AM15.4 AM170
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 BR02.2
BR02.3 BR11.1
GL110 GL120
IFLU.1 MX10.2
MX10.3
MLH-DESCRIPTION Alpha 30 (Lower Case) AC13.5 AM23.5
Description The attribute description. MX10.2 MX10.3
RW100
MLH-SHORT-DESC Derived
Short Description The short description.
MLH-SORT-MX-CAT Alpha 12 Occurs 8 Times GL21.2 GL22.2
Sort Matrix Category Consists of up to eight attribute MX10.2
categories for sorting the selected
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 AM23.5
Creator User identification of the person MX10.2 MX10.3
creating the record.
MLH-LIST-TYPE Alpha 1 AC13.4 AM23.4
List Type Determines whether the list of objects GL21.2 GL22.2
was automatically created using MX10.1
parameters, or whether it was manually
defined. A manual list will never be
rebuilt by the system.
A = Automatic
M = Manual
MLH-LAST-MAINT-DT Numeric 8 (yyyymmdd) AC00.1 AC03.2
Last Maintained Date The last date that the list was AC10.1 AC10.3
maintained. AC110 AC112
AC12.1 AC120
AC13.1 AC13.2
AC13.5 AC500
AC510 AC520
AM115 AM15.1
AM15.2 AM15.3
AM15.4 AM170
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 BR02.2
BR02.3 BR11.1
GL110 GL120
IFLU.1 MX10.1
MX10.2 MX10.3
MLH-LAST-MAINT-TM Numeric 6 (hhmmss) AC00.1 AC03.2
Last Maintained Time The last time that the list was AC10.1 AC10.3
maintained. AC110 AC112
AC12.1 AC120
AC13.1 AC13.2
AC13.5 AC500
AC510 AC520
AM115 AM15.1
AM15.2 AM15.3
AM15.4 AM170
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 BR02.2
BR02.3 BR11.1
GL110 GL120
IFLU.1 MX10.1
MX10.2 MX10.3
MLH-LAST-BUILD-DT Numeric 8 (yyyymmdd) AC01.1 AC105
Last Build Date The last build date. AC112 AC120
AC121 AC123
AC13.3 AC13.4
AC13.5 AC135
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC258 AC261
AC265 AC290
AC295 AC297
AC298 AC30.3
AC310 AC32.1
AC34.1 AC35.1
AC36.1 AC400
AC401 AC410
AC412 AC420
AC421 AC440
AC460 AC471
AC472 AC473
AC480 AC490
AC493 AC494
AC530 AC55.1
AC90.1 AC92.1
AC93.1 AC94.1
AC95.1 AC97.1
...
MLH-LAST-BUILD-TM Numeric 6 (hhmmss) AC01.1 AC105
Last Build Time The last build time. AC112 AC120
AC121 AC123
AC13.3 AC13.4
AC13.5 AC135
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC258 AC261
AC265 AC290
AC295 AC297
AC298 AC30.3
AC310 AC32.1
AC34.1 AC35.1
AC36.1 AC400
AC401 AC410
AC412 AC420
AC421 AC440
AC460 AC471
AC472 AC473
AC480 AC490
AC493 AC494
AC530 AC55.1
AC90.1 AC92.1
AC93.1 AC94.1
AC95.1 AC97.1
...
MLH-LAST-SEQ-NBR Numeric 6 AC01.1 AC105
Last Sequence Number The last sequence number. AC112 AC120
AC121 AC123
AC13.3 AC13.4
AC135 AC160
AC165 AC190
AC191 AC196
AC198 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC240 AC258
AC261 AC265
AC290 AC295
AC297 AC298
AC30.3 AC310
AC32.1 AC34.1
AC35.1 AC36.1
AC400 AC401
AC410 AC412
AC420 AC421
AC440 AC460
AC471 AC472
AC473 AC480
AC490 AC493
AC494 AC530
AC55.1 AC90.1
AC92.1 AC93.1
AC94.1 AC95.1
AC97.1 ACBA.1
...
MLH-UPDATE-FLAG Alpha 1 MX10.2
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
User Analysis 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
Array1 Used for Drill Around purposes.
MLH-ARRAY2 Derived
Array2 Used for Drill Around purposes.
MLH-ARRAY3 Derived
Array3 Used for Drill Around purposes.
MLH-ARRAY4 Derived
Array4 Used for Drill Around purposes.
MLH-ARRAY5 Derived
Array5 Used for Drill Around purposes.
MLH-ARRAY6 Derived
Array6 Used for Drill Around purposes.
MLH-ARRAY7 Derived
Array7 Used for Drill Around purposes.
MLH-ARRAY8 Derived
Array8 Used for Drill Around purposes.
MLH-SORT-MX-CAT-1 Derived
Sort Category 1 Attribute sort category 1. Attribute
lists can be sorted using up to eight
categories.
MLH-SORT-MX-CAT-2 Derived
Sort Category 2 Attribute sort category 2.
MLH-SORT-MX-CAT-3 Derived
Sort Category 3 Attribute sort category 3.
MLH-SORT-MX-CAT-4 Derived
Sort Category 4 Attribute sort category 4.
MLH-SORT-MX-CAT-5 Derived
Sort Category 5 Attribute sort category 5.
MLH-SORT-MX-CAT-6 Derived
Sort Category 6 Attribute sort category 6.
MLH-SORT-MX-CAT-7 Derived
Sort Category 7 Attribute sort category 7.
MLH-SORT-MX-CAT-8 Derived
Sort Category 8 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.2 AC10.1
AC10.3 AC105
AC110 AC112
AC12.1 AC120
AC121 AC123
AC13.1 AC13.2
AC13.3 AC13.4
AC13.5 AC130
AC135 AC160
AC165 AC190
AC191 AC196
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
...
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
|