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 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 SLVW.1
UPDATED BY
AC00.1 AC01.1 AC03.7 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 AC14.1 AC14.2 AC14.3 AC14.4
AC14.5 AC145 AC160 AC165 AC190 AC191
AC197 AC198 AC200 AC203 AC206 AC207
AC210 AC213 AC218 AC220 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
AC55.1 AC580 AC583 AC90.1 AC92.1 AC93.1
AC94.1 AC95.1 ACBA.1 ACDL.1 ACDM.2 ACVW.1
SE90.1 AM115 AM117 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 AM310 AM320 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 AP211
AP510 API3.1 API4.1 AR09.1 AR10.1 AR112
AR115 AR12.1 AR12.2 AR124 AR129 AR13.1
AR13.2 AR130 AR131 AR135 AR137 AR17.1
AR170 AR180 AR190 AR194 AR20.1 AR21.1
AR21.2 AR21.3 AR210 AR211 AR222 AR23.1
AR23.2 AR23.3 AR23.4 AR23.5 AR232 AR235
AR24.1 AR250 AR251 AR253 AR271 AR275
AR28.1 AR29.1 AR29.2 AR29.3 AR290 AR293
AR294 AR30.1 AR30.5 AR30.8 AR301 AR31.6
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 AR42.1 AR42.2 AR42.6 AR42.7
AR43.1 AR44.3 AR45.1 AR48.3 AR501 AR502
AR505 AR506 AR515 AR550 AR560 AR570
AR575 AR580 AR70.2 AR80.1 AR80.2 AR82.1
ARLL.1 BL02.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL232 BL29.1 BL29.2
BL520 BL820 BL92.1 BR10.1 BR10.4 BR10.8
BR120 BR121 BR13.1 BR130 BR131 BR140
BR142 BR145 BR165 BR19.2 BR190 BR20.9
BR200 BR202 BR204 BR205 BR210 BR212
BR215 BR220 BR245 BR265 BR300 BR400
BR405 BR430 BR450 BR521 BR530 BR580
BRCC.1 CB01.6 CB01.7 CB191 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 CA10.1 CA10.7 GL110 GL120 GL191
RW80.1 IC840 GL21.2 GL22.2 GLAC.1 GLBL.1
IFLU.1 MX10.1 MX10.2 MX10.3 MX123 MX135
MX500 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE129
OE13.2 OE13.3 OE13.5 OE14.4 OE280 OE285
OE290 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE810
OE830 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 UK47.1 SLBL.1 WH20.7
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 AC500
AC510 AC520
AM115 AM117
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 AR09.1
AR10.1 AR112
AR115 AR12.1
AR12.2 AR124
AR129 AR13.1
AR13.2 AR130
AR131 AR135
AR137 AR17.1
AR170 AR180
AR190 AR194
...
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 AC500
AC510 AC520
AM115 AM117
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
AR09.1 AR10.1
AR112 AR115
AR12.1 AR12.2
AR124 AR129
AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR17.1 AR170
...
MLH-DESCRIPTION Alpha 30 (Lower Case) AC13.5 AC14.5
Element: Description The attribute description. 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 AM23.5 AR23.5
creating the record. MX10.2 MX10.3
MLH-LIST-TYPE Alpha 1 AC13.4 AC14.4
Element: List Type Determines whether the list of objects AM23.4 AP03.4
was automatically created using AR23.4 CB01.6
parameters, or whether it was manually GL21.2 GL22.2
defined. A manual list will never be MX10.1
rebuilt by the system.
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 AC500
AC510 AC520
AM115 AM117
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
AR09.1 AR10.1
AR112 AR115
AR12.1 AR12.2
AR124 AR129
AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR17.1 AR170
...
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 AC500
AC510 AC520
AM115 AM117
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
AR09.1 AR10.1
AR112 AR115
AR12.1 AR12.2
AR124 AR129
AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR17.1 AR170
...
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
AC14.3 AC14.4
AC14.5 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
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 AC55.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
AC14.3 AC14.4
AC14.5 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
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 AC55.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 AC14.3
AC14.4 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
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 AC55.1
AC580 AC583
...
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.7 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
AC14.1 AC14.2
AC14.3 AC14.4
AC14.5 AC145
AC160 AC165
AC190 AC191
...
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
|