MXLISTDTL FILE
Attribute List Detail
This file consists of attribute list detail records which are used to define
and access accounting unit detail information.
REFERENCED BY
AC01.1 AC105 AC112 AC113 AC120 AC121
AC123 AC128 AC130 AC135 AC145 AC160
AC165 AC169 AC190 AC191 AC197 AC198
AC200 AC203 AC206 AC207 AC210 AC213
AC218 AC220 AC225 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 AC527 AC55.1 AC580 AC583
AC90.1 AC92.1 AC93.1 AC94.1 AC95.1 ACBA.1
ACDL.1 ACDM.2 ACDM.9 ACVW.1 ATVW.1 SE90.1
AM115 AM117 AM120 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM214 AM220 AM221 AM222 AM223
AM224 AM225 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 AM330 AM35.1 AM45.1 AM500
AM501 AM51.1 AM551 AM70.4 AM88.1 AM97.1
AMBL.1 AP110 AP115 AP125 AP126 AP131
AP150 AP155 AP160 AP161 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP210
AP211 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP265 AP27.1 AP30.2 AP30.4 AP305 AP510
AP90.1 AP91.1 API1.1 API2.1 API3.1 API4.1
AR120 AR129 AR130 AR131 AR135 AR170
AR21.2 AR210 AR211 AR217 AR222 AR223
AR227 AR228 AR229 AR230 AR232 AR233
AR235 AR237 AR238 AR239 AR245 AR250
AR251 AR253 AR257 AR258 AR264 AR265
AR27.2 AR271 AR275 AR282 AR285 AR29.1
AR290 AR291 AR292 AR293 AR294 AR296
AR30.5 AR300 AR301 AR32.1 AR33.2 AR38.5
AR39.3 AR39.4 AR42.1 AR42.2 AR42.7 AR43.1
AR502 AR503 AR55.1 AR560 AR575 AR800
AR91.1 ARLL.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL232 BL29.1 BL29.2
BL290 BL520 BL820 BL92.1 BR120 BR121
BR130 BR131 BR140 BR142 BR145 BR151
BR152 BR153 BR154 BR155 BR156 BR157
BR165 BR19.2 BR190 BR20.9 BR200 BR202
BR204 BR205 BR210 BR212 BR215 BR220
BR245 BR251 BR252 BR253 BR254 BR265
BR300 BR400 BR405 BR422 BR430 BR450
BR521 BR530 BR580 CB145 CB170 CB175
CB180 CB186 CB187 CB210 CB215 CB220
CB221 CB260 CB286 ET700 CA10.1 CA10.7
GL191 RW80.1 ICBL.1 ICBL.2 ICLM.1 GLAC.1
GLBL.1 MX123 MX202 MX210 MX500 MA180
MA279 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD230 PD235 PO10.1 PO100 PO101 PO120
PO122 PO131 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO220 PO223 PO23.1
PO233 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO253 PO254 PO27.2 PO278 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 PO54.1 PO54.2 PO54.3 PO54.4
POBL.1 POI3.1 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 RQ10.1 RQ10.2 RQBL.1 SLBL.1 SN02.1
SNAC.1 WH110 WH130 WH20.2 WH20.7 WH226
AR515 GL00.1 GL00.3 GL124 GL20.1 IFLU.1
MX00.2 MX00.3 MX100
UPDATED BY
AC13.4 AC13.5 AC14.4 AC14.5 AC16.4 AC16.5
AM23.5 AM23.4 AP03.4 AR23.5 AR23.4 CB01.6
GL21.2 GL22.2 MX10.1 MX10.2 MX10.3 IC02.6
PO04.8 RQ01.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLD-OBJ-TYPE Alpha 5 MX10.1
Element: Object Type Determines the type of object to be
used by the Attribute. These values are
not user maintainable.
MLD-MATRIX-LIST Alpha 12 AC13.5 AC14.5
Element: Matrix List Attributes are selection parameters AC16.5 AM23.5
used to build a list of objects AR23.5 MX10.1
(accounting units). Attributes and MX10.3
values are the basis of the selection
and sorting. An attribute list can then
be used for reporting on and processing
"objects."
MLD-OR-GROUP Alpha 1 MX10.1
Element: Group A single value used to group multiple
selections together. Each group of value
selections will be treated internally as
an "and" and externally as an "or."
MLD-SEQ-NUMBER Numeric 6 MX10.1
Element: Sequence NumbeA unique number assigned to each
transaction to be interfaced into the
Lawson system.
MLD-MATRIX-CAT Alpha 12 MX10.1
Element: Matrix CategorAttribute name assigned to an object
(like an accounting unit) to track
additional information. Attribute values
may then be used in selection and
sorting for reporting and analysis.
MLD-FR-MX-VAL Alpha 32 MX10.1
Element: From Matrix VaThe beginning value in a range of
values.
MLD-TH-MX-VAL Alpha 32 MX10.1
Element: To Matrix ValuThe ending value in a range of values.
MXLISTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLDSET1 OBJ-TYPE AC01.1 AC105
MATRIX-LIST AC112 AC113
OR-GROUP AC120 AC121
MATRIX-CAT AC123 AC128
SEQ-NUMBER AC13.3 AC13.4
AC13.5 AC130
AC135 AC14.3
AC14.4 AC14.5
AC145 AC16.3
AC16.4 AC16.5
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
...
MLDSET2 OBJ-TYPE KeyChange AC13.1 AC13.2
MATRIX-CAT AC14.1 AC14.2
MATRIX-LIST AC16.1 AC16.2
OR-GROUP AM23.1 AM23.2
SEQ-NUMBER AM23.5 AP150
AP155 AP160
AP161 AP265
AR23.1 AR23.2
AR23.5 AR515
GL00.1 GL00.3
GL124 GL20.1
IFLU.1 MX00.2
MX00.3 MX100
MXLISTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Matrix Cat MXOBJCAT Required
MLD-OBJ-TYPE -> MOC-OBJ-TYPE
MLD-MATRIX-CAT -> MOC-MATRIX-CAT
Mxlisthdr MXLISTHDR Required
MLD-OBJ-TYPE -> MLH-OBJ-TYPE
MLD-MATRIX-LIST -> MLH-MATRIX-LIST
Mxvalidate MXVALIDATE Not Required
MLD-MATRIX-CAT -> MVL-MATRIX-CAT
MLD-TH-MX-VAL -> MVL-TH-MX-VAL
|
