ICLMXVAL FILE
REFERENCED BY
IC02.3 IC02.4
UPDATED BY
ICLM.3 MX500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ILV-ICL-OBJ-ID Numeric 12 IC02.4 ICLM.3
Element: Obj Id This is the object identifier. It is MX500
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.
ILV-MATRIX-CAT Alpha 12 IC02.4 ICLM.3
Element: Matrix Cat Attribute name assigned to an object MX500
(like accounting unit) to track
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
ILV-MX-VALUE Alpha 32 IC02.4 ICLM.3
Element: Mx Value The attribute value. MX500
ICLMXVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ILVSET1 ICL-OBJ-ID IC02.3 IC02.4
MATRIX-CAT ICLM.1 ICLM.3
MX500
ILVSET2 MATRIX-CAT KeyChange ICLM.1 MX500
MX-VALUE
ICL-OBJ-ID
ICLMXVAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iclocation ICLOCATION Required
ILV-ICL-OBJ-ID -> ICL-ICL-OBJ-ID
Mxcatdef MXCATDEF Required
ILV-MATRIX-CAT -> MXC-MATRIX-CAT
Mxobjcat MXOBJCAT Required
"ICL" -> MOC-OBJ-TYPE
ILV-MATRIX-CAT -> MOC-MATRIX-CAT
|
