AUMXVALUE

Acct Unit Attribute Value

This file contains accounting unit attribute category information that is used to build an attribute list.

REFERENCED BY
RW100 AC34.1 AC35.1 AC36.1 AM214 AM282
GL191 RW80.1 GL121 GL14.8 GL220 GL62.1
GLBL.1 IFBO.1 ML191 SNAU.1


UPDATED BY
AM220 AM221 AM230 AM240 AM255 AM260
AM267 AM270 AM278 AM280 AM287 CA10.1
CA10.7 GL110 GL120 GL122 GL124 GL125
GL161 GL162 GL20.1 GL20.5 GL20.7 MX135
MX202 MX500 PD230 PO253

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMV-OBJ-ID
Element: Object ID		Numeric 12
The unique object identifier.
GL110 GL120
GL124 GL125
GL161 GL162
GL20.1 GL20.5
GL20.7 MX135
MX500
AMV-MATRIX-CAT
Element: Matrix Category		Alpha 12
Attribute 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.
GL120 GL124
GL125 GL161
GL162 GL20.1
GL20.5 GL20.7
MX135 MX500
AMV-MX-VALUE
Element: Matrix Value		Alpha 32
The category value assigned to the object.
GL120 GL124
GL125 GL161
GL162 GL20.1
GL20.5 GL20.7
MX135 MX500


AUMXVALUE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMVSET1 OBJ-ID
MATRIX-CAT
...
AC34.1 AC35.1
AC36.1 AM214
AM220 AM221
AM230 AM240
AM255 AM260
AM267 AM270
AM278 AM280
AM282 AM287
CA10.1 CA10.7
GL110 GL120
GL122 GL191
RW100 RW80.1
GL121 GL124
GL125 GL14.8
GL161 GL162
AMVSET2 MATRIX-CAT
MX-VALUE
OBJ-ID
KeyChange
AC34.1 AC35.1
AC36.1 AM214
AM220 AM221
AM230 AM240
AM255 AM260
AM267 AM270
AM278 AM280
AM282 AM287
CA10.1 CA10.7
GL122 GL191
RW80.1 GL121
GLBL.1 MX202
ML191 PD230
PO253
AMVSET3 OBJ-ID
MATRIX-CAT
Subset
WhereMATRIX-CAT !="LVL 1 VALUE"
AndMATRIX-CAT !="LVL 2 VALUE"
AndMATRIX-CAT !="LVL 3 VALUE"
AndMATRIX-CAT !="LVL 4 VALUE"
AndMATRIX-CAT !="LVL 5 VALUE"
GL20.1


AUMXVALUE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acct Unit GLNAMES Not Required
AMV-OBJ-ID->GLN-OBJ-ID
Glnames GLNAMES Not Required
AMV-OBJ-ID->GLN-OBJ-ID
Matrix Cat MXOBJCAT Required
"ACCTU"->MOC-OBJ-TYPE
AMV-MATRIX-CAT->MOC-MATRIX-CAT
Mxcatdef MXCATDEF Required
AMV-MATRIX-CAT->MXC-MATRIX-CAT


AUMXVALUE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Same Value AUMXVALUE
AMV-MATRIX-CAT->AMV-MATRIX-CAT
AMV-MX-VALUE->AMV-MX-VALUE
  AMV-OBJ-ID

File created: Thu Jun 09 11:18:25 2016

Home
Contact Us



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