AUMXVALUE FILE Acct Unit Attribute Value This file contains accounting unit attribute category information that is used to build an attribute list. REFERENCED BY AC20.1 AC20.2 AC20.3 AC20.4 AC30.2 AC30.3 CA10.1 CA10.8 GL191 RW80.1 GL220 GL62.1 GLBL.1 UPDATED BY GL110 GL120 GL161 GL162 GL20.1 GL20.5 GL20.7 MX500 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY AMV-OBJ-ID Numeric 12 GL110 GL120 Object ID The unique object identifier. GL161 GL162 GL20.1 GL20.5 GL20.7 MX500 AMV-MATRIX-CAT Alpha 12 GL120 GL161 Matrix Category Attribute name assigned to an object GL162 GL20.1 (like an accounting unit) to track GL20.5 GL20.7 additional information. Attribute values MX500 may then be used in selection and sorting for reporting and analysis. AMV-MX-VALUE Alpha 20 GL120 GL161 Matrix Value The category value assigned to the GL162 GL20.1 object. GL20.5 GL20.7 MX500 AUMXVALUE FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN AMVSET1 OBJ-ID AC20.1 AC20.2 MATRIX-CAT AC20.3 AC20.4 AC30.2 AC30.3 CA10.1 CA10.8 GL110 GL120 GL191 RW80.1 GL161 GL162 GL20.1 GL20.5 GL20.7 GL220 GL62.1 GLBL.1 MX500 AMVSET2 MATRIX-CAT KeyChange AC20.1 AC20.2 MX-VALUE AC20.3 AC20.4 OBJ-ID AC30.2 AC30.3 CA10.1 CA10.8 GL191 RW80.1 GLBL.1 AMVSET3 OBJ-ID Subset GL20.1 MATRIX-CAT Where MATRIX-CAT != "LVL 1 VALUE " And MATRIX-CAT != "LVL 2 VALUE " And MATRIX-CAT != "LVL 3 VALUE " And MATRIX-CAT != "LVL 4 VALUE " And MATRIX-CAT != "LVL 5 VALUE " AUMXVALUE FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME 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 RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Same Value AUMXVALUE AMV-MATRIX-CAT -> AMV-MATRIX-CAT AMV-MX-VALUE -> AMV-MX-VALUE AMV-OBJ-ID |