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
AC210 AP211 GL299 MX123 SN02.1


UPDATED BY
AC00.1 MX500 AC200 MX202

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.
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.
MX500
AGV-MX-VALUE
Element: Mx Value		Alpha 32
The attribute value.
MX500


ACGRPMXVAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AGVSET1 OBJ-ID
MATRIX-CAT
AC00.1 AC200
AC210 AP211
GL299 MX123
MX202 MX500
SN02.1
AGVSET2 MATRIX-CAT
MX-VALUE
OBJ-ID
KeyChange
AC200 AC210
AP211 GL299
MX123 MX202
MX500 SN02.1


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: Wed Jun 08 20:46:56 2016

Home
Contact Us



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