ACCATMXVAL

REFERENCED BY
AC01.1 AC105 AC112 AC113 AC120 AC121
AC123 AC128 AC145 AC147 AC160 AC165
AC169 AC190 AC191 AC196 AC197 AC198
AC200 AC203 AC206 AC207 AC208 AC210
AC213 AC218 AC220 AC225 AC240 AC246
AC247 AC256 AC261 AC265 AC290 AC295
AC297 AC298 AC30.3 AC310 AC311 AC32.1
AC34.1 AC346 AC35.1 AC36.1 AC400 AC401
AC410 AC412 AC420 AC421 AC440 AC460
AC471 AC472 AC473 AC480 AC490 AC493
AC494 AC527 AC55.1 AC580 AC583 AC90.1
AC92.1 AC93.1 AC94.1 AC95.1 AC97.1 ACDM.2
ATVW.1 SE90.1 AP211 ARLL.1 BR120 BR121
BR130 BR131 BR140 BR142 BR145 BR151
BR152 BR153 BR154 BR155 BR156 BR157
BR165 BR19.2 BR190 BR20.9 BR200 BR202
BR204 BR205 BR210 BR212 BR215 BR220
BR245 BR251 BR252 BR253 BR254 BR265
BR300 BR400 BR405 BR422 BR430 BR450
BR521 BR530 BR580 GL299 MX123 MX202
SN02.1


UPDATED BY
AC08.1 AC08.2 AC08.3 AC08.6 AC135 AC16.1
AC16.2 AC16.9 AC558 MX500

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.
AC135 AC16.1
AC16.2 AC16.9
AC558 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.
AC135 AC16.1
AC16.2 AC16.9
AC558 MX500
AJB-MX-VALUE
Element: Mx Value
Alpha 32
The attribute value.
AC135 AC16.1
AC16.2 AC16.9
AC558 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
...
AC01.1 AC08.1
AC08.2 AC08.3
AC08.6 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC135 AC145
AC147 AC16.1
AC16.2 AC16.3
AC16.9 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AJBSET2 MATRIX-CAT
MX-VALUE
OBJ-ID
KeyChange
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC135 AC145
AC147 AC16.3
AC16.9 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225


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: Thu Jun 09 02:02:53 2016

Home
Contact Us



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