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
AC112 AC113 AC120 AC121 AC123 AC128
AC145 AC147 AC160 AC165 AC169 AC190
AC191 AC196 AC197 AC198 AC203 AC206
AC207 AC210 AC213 AC218 AC220 AC225
AC240 AC246 AC247 AC256 AC261 AC265
AC290 AC295 AC297 AC298 AC30.3 AC310
AC311 AC32.1 AC346 AC400 AC401 AC410
AC412 AC420 AC421 AC440 AC460 AC471
AC472 AC473 AC480 AC490 AC493 AC494
AC527 AC580 AC583 AC90.1 AC92.1 AC93.1
AC94.1 AC95.1 AC97.1 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
BR265 BR300 BR400 BR405 BR422 BR430
BR450 BR521 BR530 BR580 GL299 MX123
AC01.1 AC105 AC34.1 AC35.1 AC36.1 AC55.1
ACDM.2 BR254 SN02.1


UPDATED BY
AC00.1 AC135 AC14.1 AC14.2 AC200 AC300
AC560 MX202 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 11:04:07 2016

Home
Contact Us



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