RQLMXVAL FILE
REFERENCED BY
RQ01.1 RQ01.2 RQ01.3 RQ810
UPDATED BY
MX500 RQBL.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQV-RQL-OBJ-ID Numeric 12 MX500 RQ01.3
Element: Obj Id This is the object identifier. It is RQBL.3
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
RQV-MATRIX-CAT Alpha 12 MX500 RQ01.3
Element: Matrix Cat Attribute name assigned to an object RQBL.3
(like accounting unit) to track
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
RQV-MX-VALUE Alpha 32 MX500 RQ01.3
Element: Mx Value The attribute value. RQBL.3
RQLMXVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQVSET1 RQL-OBJ-ID MX500 RQ01.1
MATRIX-CAT RQ01.2 RQ01.3
RQ810 RQBL.1
RQBL.3
RQVSET2 MATRIX-CAT KeyChange MX500 RQBL.1
MX-VALUE
RQL-OBJ-ID
RQLMXVAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mxcatdef MXCATDEF Required
RQV-MATRIX-CAT -> MXC-MATRIX-CAT
Mxobjcat MXOBJCAT Required
"RQLOC" -> MOC-OBJ-TYPE
RQV-MATRIX-CAT -> MOC-MATRIX-CAT
Rqloc RQLOC Required
RQV-RQL-OBJ-ID -> RQL-RQL-OBJ-ID
|
