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 AC37.1
AC52.1 AC62.1 AM180 CA110 FB100 FB11.1
FB111 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 IFBO.1 IFOS.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 AC113 AC12.1 AC120 AC121
AC123 AC13.1 AC13.2 AC13.3 AC13.4 AC13.5
AC130 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 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 AM330 AM35.1
AM45.1 AM500 AM501 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 BR151 BR152 BR153 BR154
BR155 BR156 BR157 BR165 BR200 BR202
BR204 BR205 BR210 BR215 BR220 BR251
BR252 BR253 BR254 BR265 BR400 BR405
BR420 BR430 BR450 BR521 BR530 BR900
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 MX135 MX500
SLBL.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLH-OBJ-TYPE Alpha 5 AC00.1 AC03.2
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
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
MX135
MLH-MATRIX-LIST Alpha 12 AC00.1 AC03.2
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 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 MX135
MLH-DESCRIPTION Alpha 30 (Lower Case) AC13.5 AM23.5
Element: Description The attribute description. MX10.2 MX10.3
RW100
MLH-SHORT-DESC Derived
Element: Short DescriptThe short description.
MLH-SORT-MX-CAT Alpha 12 Occurs 8 Times GL21.2 GL22.2
Element: Sort Matrix CaConsists 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
Element: Creator User identification of the person MX10.2 MX10.3
creating the record.
MLH-LIST-TYPE Alpha 1 AC13.4 AM23.4
Element: 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
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 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
MX135
MLH-LAST-MAINT-TM Numeric 6 (hhmmss) AC00.1 AC03.2
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 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
MX135
MLH-LAST-BUILD-DT Numeric 8 (yyyymmdd) AC01.1 AC105
Element: Last Build DatThe last build date. AC112 AC113
AC120 AC121
AC123 AC13.3
AC13.4 AC13.5
AC130 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
...
MLH-LAST-BUILD-TM Numeric 6 (hhmmss) AC01.1 AC105
Element: Last Build TimThe last build time. AC112 AC113
AC120 AC121
AC123 AC13.3
AC13.4 AC13.5
AC130 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
...
MLH-LAST-SEQ-NBR Numeric 6 AC01.1 AC105
Element: Last Sequence The last sequence number. AC112 AC113
AC120 AC121
AC123 AC13.3
AC13.4 AC130
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
...
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: 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
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.2 AC10.1
AC10.3 AC105
AC110 AC112
AC113 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
...
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
|