ACCATMXVDT FILE
REFERENCED BY
MX202 AC135
UPDATED BY
AC16.1 AC16.2 AC16.7 AC16.8 AC08.1 AC08.2
AC08.3 AC08.6
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MXB-OBJ-ID Numeric 12 AC16.1 AC16.2
Element: Obj Id This is the object identifier. It is AC16.7 AC16.8
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.
MXB-MATRIX-CAT Alpha 12 AC16.1 AC16.2
Element: Matrix Cat Attribute name assigned to an object AC16.7 AC16.8
(like accounting unit) to track
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
MXB-STRUCTURE Alpha 15 AC16.1 AC16.2
Element: Structure The name of the category structure. AC16.7 AC16.8
MXB-MX-VALUE Alpha 32 AC16.1 AC16.2
Element: Mx Value The attribute value. AC16.7 AC16.8
MXB-EFFECTIVE-DATE Numeric 8 (yyyymmdd) AC16.1 AC16.2
Element: Effective DateThe date a vendor's prices will be in AC16.7 AC16.8
effect.
ACCATMXVDT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MXBSET1 OBJ-ID AC08.1 AC08.2
MATRIX-CAT AC08.3 AC08.6
EFFECTIVE-DATE AC16.1 AC16.2
AC16.7 AC16.8
MX202
MXBSET2 MATRIX-CAT MX202
EFFECTIVE-DATE
OBJ-ID
MXBSET3 MATRIX-CAT KeyChange AC16.8
STRUCTURE
EFFECTIVE-DATE*
OBJ-ID
MXBSET4 OBJ-ID AC135
MATRIX-CAT
EFFECTIVE-DATE*
ACCATMXVDT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accatmxval ACCATMXVAL Not Required
MXB-OBJ-ID -> AJB-OBJ-ID
MXB-MATRIX-CAT -> AJB-MATRIX-CAT
Mxcatdef MXCATDEF Required
MXB-MATRIX-CAT -> MXC-MATRIX-CAT
Mxobjcat MXOBJCAT Required
"ACCAT" -> MOC-OBJ-TYPE
MXB-MATRIX-CAT -> MOC-MATRIX-CAT
ACCATMXVDT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accatsum ACCATSUM
MXB-OBJ-ID -> SRS-OBJ-ID
SRS-STRUCTURE
SRS-SUM-ACCT-CAT
Accatsumx ACCATSUMX
MXB-OBJ-ID -> SRX-OBJ-ID
SRX-STRUCTURE
SRX-ACCT-CATEGORY
|
