ACGRPMXVAL

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 AC147 AC160 AC165
AC169 AC190 AC191 AC196 AC197 AC198
AC200 AC203 AC206 AC207 AC210 AC213
AC218 AC220 AC225 AC240 AC246 AC247
AC256 AC261 AC265 AC290 AC295 AC297
AC298 AC30.3 AC310 AC311 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 AC97.1 ACDM.2 SE90.1
AP211 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 GL299 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
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate attributes and attribute values back to the activity group.
AC135 AC14.1
AC14.2 AC560
MX500
AGV-MATRIX-CAT
Element: Matrix Cat
Alpha 12
Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis.
AC135 AC14.1
AC14.2 AC560
MX500
AGV-MX-VALUE
Element: Mx Value
Alpha 32
The attribute value.
AC135 AC14.1
AC14.2 AC560
MX500


ACGRPMXVAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AGVSET1 OBJ-ID
MATRIX-CAT
...
AC00.1 AC01.1
AC105 AC112
AC113 AC120
AC121 AC123
AC128 AC135
AC14.1 AC14.2
AC14.3 AC145
AC147 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AGVSET2 MATRIX-CAT
MX-VALUE
OBJ-ID
KeyChange
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC135 AC14.3
AC145 AC147
AC160 AC165
AC169 AC190
AC191 AC196
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC225 AC240


ACGRPMXVAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Same Value ACGRPMXVAL
AGV-MATRIX-CAT->AGV-MATRIX-CAT
AGV-MX-VALUE->AGV-MX-VALUE
  AGV-OBJ-ID


File created: Thu Jun 09 02:03:04 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.