AUMXVALUE

Acct Unit Attribute Value

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

REFERENCED BY
AC34.1 AC35.1 AC36.1 AM214 AM220 AM221
AM230 AM240 AM255 AM260 AM267 AM270
AM278 AM280 AM282 AM287 CA10.1 CA10.4
CA10.7 GL122 GL146 GL191 GL197 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GL70.1 GL70.2 GL70.3 GL70.6 RW100 RW80.1
GL121 GL14.1 GL14.5 GL14.7 GL14.8 GL16.1
GL16.2 GL16.3 GL16.4 GL220 GL62.1 GLBL.1
IFBO.1 MX00.1 MX00.2 MX00.3 MX05.1 MX05.2
MX06.1 MX06.2 MX10.1 MX10.2 MX20.1 MX20.2
MX20.4 MX20.5 MX202 ML191 PD230 PO253
SL40.1 SNAU.1


UPDATED BY
GL110 GL120 GL124 GL125 GL161 GL162
GL20.1 GL20.5 GL20.7 MX135 MX500

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.4
CA10.7 GL110
GL120 GL122
GL146 GL191
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
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.4
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
Aumxvaluau AUMXVALUAU
AMV-OBJ-ID->AVA-OBJ-ID
AMV-MATRIX-CAT->AVA-MATRIX-CAT
  AVA-ACTION
  AVA-DATE
  AVA-TIME
  AVA-UNIQUE-I-D
Same Value AUMXVALUE
AMV-MATRIX-CAT->AMV-MATRIX-CAT
AMV-MX-VALUE->AMV-MX-VALUE
  AMV-OBJ-ID

File created: Thu Jun 09 02:20:22 2016

Home
Contact Us



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