Lawson Insight Technical Documentation |
|
ACCATMXVAL
ACCATMXVAL FILE
REFERENCED BY
AC01.1 AC105 AC112 AC113 AC120 AC121
AC123 AC128 AC145 AC160 AC165 AC169
AC190 AC191 AC197 AC198 AC200 AC203
AC206 AC207 AC208 AC210 AC213 AC218
AC220 AC225 AC240 AC246 AC261 AC265
AC290 AC295 AC298 AC30.3 AC310 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 ACDM.2 ATVW.1
SE90.1 AP211 AR21.2 AR237 AR239 AR250
AR257 AR27.2 AR29.1 AR296 AR30.5 AR32.1
AR33.2 AR38.5 AR39.3 AR39.4 AR42.1 AR42.2
AR42.7 AR43.1 AR502 AR503 AR55.1 AR560
AR575 AR800 AR91.1 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 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 Numeric 12 AC135 AC16.1
Element: Obj Id This is the object identifier. It is AC16.2 AC16.9
used to relate commitments or posted AC558 MX500
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.
AJB-MATRIX-CAT Alpha 12 AC135 AC16.1
Element: Matrix Cat Attribute name assigned to an object AC16.2 AC16.9
(like accounting unit) to track AC558 MX500
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
AJB-MX-VALUE Alpha 32 AC135 AC16.1
Element: Mx Value The attribute value. AC16.2 AC16.9
AC558 MX500
AJB-DESCRIPTION Alpha 30 (Lower Case)
Element: Description This field displays the description.
ACCATMXVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AJBSET1 OBJ-ID AC01.1 AC08.1
MATRIX-CAT AC08.2 AC08.3
AC08.6 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC135 AC145
AC16.1 AC16.2
AC16.3 AC16.9
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC208
...
AJBSET2 MATRIX-CAT KeyChange AC01.1 AC105
MX-VALUE AC112 AC113
OBJ-ID AC120 AC121
AC123 AC128
AC135 AC145
AC16.3 AC16.9
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
AC240 AC246
...
ACCATMXVAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|