AUMXVALUE

Acct Unit Attribute Value

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

REFERENCED BY
RW100 GL62.1 IFBO.1 SNAU.1


UPDATED BY
GL110 GL120 GL124 GL161 GL162 GL20.1
GL20.5 GL20.7 MX135 MX500 AM214 AM220
AM221 AM230 AM240 AM255 AM260 AM267
AM270 AM278 AM280 AM282 AM287 CA10.1
CA10.7 GL122 GL191 RW80.1 GL121 GL14.8
GL220 GLBL.1 MX202

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMV-OBJ-ID
Element: Object ID		Numeric 12
The unique object identifier.
GL110 GL120
GL124 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
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
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
...
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 GL14.8
GL161 GL162
GL20.1 GL20.5
GL20.7 GL220
AMVSET2 MATRIX-CAT
MX-VALUE
OBJ-ID
KeyChange
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
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: Wed Jun 08 20:49:42 2016

Home
Contact Us



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