ACCATMXVAL

REFERENCED BY
AC200 AC210 AP211 GL299 MX123 SN02.1


UPDATED BY
MX500 MX202

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AJB-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.
MX500
AJB-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.
MX500
AJB-MX-VALUE
Element: Mx Value
Alpha 32
The attribute value.
MX500
AJB-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.


ACCATMXVAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AJBSET1 OBJ-ID
MATRIX-CAT
AC200 AC210
AP211 GL299
MX123 MX202
MX500 SN02.1
AJBSET2 MATRIX-CAT
MX-VALUE
OBJ-ID
KeyChange
AC200 AC210
AP211 GL299
MX123 MX202
MX500 SN02.1


ACCATMXVAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Mxcatdef MXCATDEF Required
AJB-MATRIX-CAT->MXC-MATRIX-CAT
Mxobjcat MXOBJCAT Required
"ACCAT"->MOC-OBJ-TYPE
AJB-MATRIX-CAT->MOC-MATRIX-CAT


ACCATMXVAL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accatmxvdt ACCATMXVDT
AJB-OBJ-ID->MXB-OBJ-ID
AJB-MATRIX-CAT->MXB-MATRIX-CAT
  MXB-EFFECTIVE-DATE
Accatsum ACCATSUM
AJB-OBJ-ID->SRS-OBJ-ID
  SRS-STRUCTURE
  SRS-SUM-ACCT-CAT
Accatsumx ACCATSUMX
AJB-OBJ-ID->SRX-OBJ-ID
  SRX-STRUCTURE
  SRX-ACCT-CATEGORY
Same Value ACCATMXVAL
AJB-MATRIX-CAT->AJB-MATRIX-CAT
AJB-MX-VALUE->AJB-MX-VALUE
  AJB-OBJ-ID


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

Home
Contact Us



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