ACCATMXVDT

UPDATED BY
MX202

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MXB-OBJ-ID
Element: Obj Id		Numeric 12
This is the object identifier. It is 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
Element: Matrix Cat		Alpha 12
Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis.
MXB-STRUCTURE
Element: Structure		Alpha 15
The name of the category structure.
MXB-MX-VALUE
Element: Mx Value		Alpha 32
The attribute value.
MXB-EFFECTIVE-DATE
Element: Effective Date		Numeric 8 (yyyymmdd)
The date a vendor's prices will be in effect.


ACCATMXVDT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MXBSET1 OBJ-ID
MATRIX-CAT
EFFECTIVE-DATE
MX202
MXBSET2 MATRIX-CAT
EFFECTIVE-DATE
OBJ-ID
MX202
MXBSET3 MATRIX-CAT
STRUCTURE
EFFECTIVE-DATE*
OBJ-ID
KeyChange
MXBSET4 OBJ-ID
MATRIX-CAT
EFFECTIVE-DATE*


ACCATMXVDT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accatmxval ACCATMXVAL Not Required
MXB-OBJ-ID->AJB-OBJ-ID (AJBSET1)
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
NAME		 RELATED 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

File created: Wed Jun 08 20:46:54 2016

Home
Contact Us



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