 |
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 FB20.1
FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL100 GL256 GL55.1
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 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 AC160
AC165 AC190 AC191 AC196 AC198 AC203
AC206 AC207 AC210 AC213 AC218 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 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 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 AM270 AM275 AM277
AM278 AM280 AM281 AM282 AM285 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 BR142 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 AC160
AC165 AC190
AC191 AC196
AC198 AC203
AC206 AC207
AC210 AC213
AC218 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 ACVW.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 AC160
AC165 AC190
AC191 AC196
AC198 AC203
AC206 AC207
AC210 AC213
AC218 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 ACVW.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
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
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
ACVW.1 AM220
...
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
AC160 AC165
AC190 AC191
AC196 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC203
...
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
|