Lawson Insight Technical Documentation |
|
AUMXVALUE
AUMXVALUE FILE
Acct Unit Attribute Value
This file contains accounting unit attribute category information that is
used to build an attribute list.
REFERENCED BY
AC34.1 AC35.1 AC36.1 AM214 AM220 AM221
AM230 AM240 AM255 AM260 AM267 AM270
AM278 AM280 AM282 AM287 CA10.1 CA10.7
GL191 RW80.1 GL14.8 GL220 GL62.1 GLBL.1
IFBO.1 MX202
UPDATED BY
GL110 GL120 GL124 GL161 GL162 GL20.1
GL20.5 GL20.7 MX135 MX500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMV-OBJ-ID Numeric 12 GL110 GL120
Element: Object ID The unique object identifier. GL124 GL161
GL162 GL20.1
GL20.5 GL20.7
MX135 MX500
AMV-MATRIX-CAT Alpha 12 GL120 GL124
Element: Matrix CategorAttribute name assigned to an object GL161 GL162
(like an accounting unit) to track GL20.1 GL20.5
additional information. Attribute values GL20.7 MX135
may then be used in selection and MX500
sorting for reporting and analysis.
AMV-MX-VALUE Alpha 32 GL120 GL124
Element: Matrix Value The category value assigned to the GL161 GL162
object. GL20.1 GL20.5
GL20.7 MX135
MX500
AUMXVALUE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMVSET1 OBJ-ID AC34.1 AC35.1
MATRIX-CAT AC36.1 AM214
AM220 AM221
AM230 AM240
AM255 AM260
AM267 AM270
AM278 AM280
AM282 AM287
CA10.1 CA10.7
GL110 GL120
GL191 RW80.1
GL124 GL14.8
GL161 GL162
GL20.1 GL20.5
GL20.7 GL220
...
AMVSET2 MATRIX-CAT KeyChange AC34.1 AC35.1
MX-VALUE AC36.1 AM214
OBJ-ID AM220 AM221
AM230 AM240
AM255 AM260
AM267 AM270
AM278 AM280
AM282 AM287
CA10.1 CA10.7
GL191 RW80.1
GLBL.1 MX202
AMVSET3 OBJ-ID Subset GL20.1
MATRIX-CAT Where MATRIX-CAT != "LVL 1 VALUE "
And MATRIX-CAT != "LVL 2 VALUE "
And MATRIX-CAT != "LVL 3 VALUE "
And MATRIX-CAT != "LVL 4 VALUE "
And MATRIX-CAT != "LVL 5 VALUE "
AUMXVALUE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Unit GLNAMES Not Required
AMV-OBJ-ID -> GLN-OBJ-ID
Glnames GLNAMES Not Required
AMV-OBJ-ID -> GLN-OBJ-ID
Matrix Cat MXOBJCAT Required
"ACCTU" -> MOC-OBJ-TYPE
AMV-MATRIX-CAT -> MOC-MATRIX-CAT
Mxcatdef MXCATDEF Required
AMV-MATRIX-CAT -> MXC-MATRIX-CAT
AUMXVALUE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Same Value AUMXVALUE
AMV-MATRIX-CAT -> AMV-MATRIX-CAT
AMV-MX-VALUE -> AMV-MX-VALUE
AMV-OBJ-ID
|