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
AC121 AC127 AC22.1 ACVW.1 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 GL160
GL223 GL60.1 GLCV.1 GLVW.1 JB00.1 MX20.1
MX210 MX500
UPDATED BY
AC00.1 AC03.2 AC10.1 AC10.3 AC105 AC110
AC112 AC115 AC12.1 AC120 AC123 AC13.1
AC13.2 AC13.3 AC13.4 AC13.5 AC130 AC14.1
AC15.2 AC160 AC165 AC170 AC190 AC191
AC196 AC20.1 AC20.2 AC20.3 AC20.4 AC203
AC206 AC207 AC210 AC214 AC215 AC216
AC240 AC265 AC290 AC295 AC297 AC30.2
AC30.3 AC310 AC32.1 AC401 AC410 AC412
AC415 AC416 AC420 AC421 AC440 AC450
AC460 AC470 AC471 AC472 AC473 AC480
AC490 AC500 AC510 AC520 AC530 AC55.1
AC79.1 ACBA.1 AM115 AM15.1 AM15.2 AM15.3
AM15.4 AM170 AM20.1 AM20.2 AM20.3 AM20.4
AM20.5 AM20.6 AM220 AM221 AM222 AM223
AM224 AM225 AM23.1 AM23.2 AM23.3 AM23.4
AM23.5 AM230 AM235 AM240 AM245 AM250
AM255 AM260 AM265 AM275 AM277 AM280
AM285 AM290 AM292 AM295 AM500 AM96.1
AM98.1 CA10.1 CA10.8 GL110 GL120 GL191
RW80.1 GL21.2 GLBL.1 IFLU.1 MX10.1 MX10.2
MX10.3 MX123 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
AC15.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
AM23.1 AM23.2
AM500 AM96.1
AM98.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 AC15.2
then be used for reporting on and AC500 AC510
processing "objects." AC520 AM115
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM23.1
AM23.2 AM23.5
AM500 AM96.1
AM98.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
MLH-SHORT-DESC Derived
Short Description The short description.
MLH-SORT-MX-CAT Alpha 12 Occurs 8 Times GL21.2 MX10.2
Sort Matrix Category Consists of up to eight attribute
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 MX10.1
was automatically created using
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 AC15.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 AM23.1
AM23.2 AM23.5
AM500 AM96.1
AM98.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 AC15.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 AM23.1
AM23.2 AM23.5
AM500 AM96.1
AM98.1 GL110
GL120 IFLU.1
MX10.1 MX10.2
MX10.3
MLH-LAST-BUILD-DT Numeric 8 (yyyymmdd) AC105 AC110
Last Build Date The last build date. AC112 AC115
AC120 AC123
AC13.3 AC13.4
AC13.5 AC130
AC14.1 AC160
AC165 AC170
AC190 AC191
AC196 AC20.1
AC20.2 AC20.3
AC20.4 AC203
AC206 AC207
AC210 AC214
AC215 AC216
AC240 AC265
AC290 AC295
AC297 AC30.2
AC30.3 AC310
AC32.1 AC401
AC410 AC412
AC415 AC416
AC420 AC421
AC440 AC450
AC460 AC470
AC471 AC472
AC473 AC480
AC490 AC530
AC55.1 AC79.1
ACBA.1 AM220
AM221 AM222
...
MLH-LAST-BUILD-TM Numeric 6 (hhmmss) AC105 AC110
Last Build Time The last build time. AC112 AC115
AC120 AC123
AC13.3 AC13.4
AC13.5 AC130
AC14.1 AC160
AC165 AC170
AC190 AC191
AC196 AC20.1
AC20.2 AC20.3
AC20.4 AC203
AC206 AC207
AC210 AC214
AC215 AC216
AC240 AC265
AC290 AC295
AC297 AC30.2
AC30.3 AC310
AC32.1 AC401
AC410 AC412
AC415 AC416
AC420 AC421
AC440 AC450
AC460 AC470
AC471 AC472
AC473 AC480
AC490 AC530
AC55.1 AC79.1
ACBA.1 AM220
AM221 AM222
...
MLH-LAST-SEQ-NBR Numeric 6 AC105 AC110
Last Sequence Number The last sequence number. AC112 AC115
AC120 AC123
AC13.3 AC13.4
AC130 AC14.1
AC160 AC165
AC170 AC190
AC191 AC196
AC20.1 AC20.2
AC20.3 AC20.4
AC203 AC206
AC207 AC210
AC214 AC215
AC216 AC240
AC265 AC290
AC295 AC297
AC30.2 AC30.3
AC310 AC32.1
AC401 AC410
AC412 AC415
AC416 AC420
AC421 AC440
AC450 AC460
AC470 AC471
AC472 AC473
AC480 AC490
AC530 AC55.1
AC79.1 ACBA.1
AM23.4 CA10.1
CA10.8 GL191
...
MLH-UPDATE-FLAG Alpha 1 MX10.2
Update 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
Array 1 Used for Drill Around purposes.
MLH-ARRAY2 Derived
Array 2 Used for Drill Around purposes.
MLH-ARRAY3 Derived
Array 3 Used for Drill Around purposes.
MLH-ARRAY4 Derived
Array 4 Used for Drill Around purposes.
MLH-ARRAY5 Derived
Array 5 Used for Drill Around purposes.
MLH-ARRAY6 Derived
Array 6 Used for Drill Around purposes.
MLH-ARRAY7 Derived
Array 7 Used for Drill Around purposes.
MLH-ARRAY8 Derived
Array 8 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 AC03.2
MATRIX-LIST AC10.1 AC10.3
AC105 AC110
AC112 AC115
AC12.1 AC120
AC121 AC123
AC127 AC13.1
AC13.2 AC13.3
AC13.4 AC13.5
AC130 AC14.1
AC15.2 AC160
AC165 AC170
AC190 AC191
AC196 AC20.1
AC20.2 AC20.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
|