Lawson Insight Technical Documentation |
|
ACGRPMXVAL
ACGRPMXVAL FILE
The ACGRPMXVAL file is the primary file updated by AC13. It stores the
activity group attributes and assigned values by object ID.
REFERENCED BY
AC01.1 AC105 AC112 AC113 AC120 AC121
AC123 AC128 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 ACDM.2 SE90.1 AP211
AR21.2 AR237 AR239 AR250 AR257 AR27.2
AR29.1 AR296 AR30.5 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 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 MX123 MX202 SN02.1
UPDATED BY
AC00.1 AC135 AC14.1 AC14.2 AC300 AC560
MX500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AGV-OBJ-ID Numeric 12 AC135 AC14.1
Element: Obj Id This is the object identifier. It is AC14.2 AC560
used to relate attributes and attribute MX500
values back to the activity group.
AGV-MATRIX-CAT Alpha 12 AC135 AC14.1
Element: Matrix Cat Attribute name assigned to an object AC14.2 AC560
(like accounting unit) to track MX500
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
AGV-MX-VALUE Alpha 32 AC135 AC14.1
Element: Mx Value The attribute value. AC14.2 AC560
MX500
ACGRPMXVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AGVSET1 OBJ-ID AC00.1 AC01.1
MATRIX-CAT AC105 AC112
AC113 AC120
AC121 AC123
AC128 AC135
AC14.1 AC14.2
AC14.3 AC145
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
...
AGVSET2 MATRIX-CAT KeyChange AC01.1 AC105
MX-VALUE AC112 AC113
OBJ-ID AC120 AC121
AC123 AC128
AC135 AC14.3
AC145 AC160
AC165 AC169
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC225 AC240
AC246 AC261
...
ACGRPMXVAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
AGV-OBJ-ID -> AGP-OBJ-ID
Mxcatdef MXCATDEF Required
AGV-MATRIX-CAT -> MXC-MATRIX-CAT
Mxobjcat MXOBJCAT Required
"ACGRP" -> MOC-OBJ-TYPE
AGV-MATRIX-CAT -> MOC-MATRIX-CAT
ACGRPMXVAL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Same Value ACGRPMXVAL
AGV-MATRIX-CAT -> AGV-MATRIX-CAT
AGV-MX-VALUE -> AGV-MX-VALUE
AGV-OBJ-ID
|