Lawson Insight Technical Documentation |
|
LOMXVALUE
LOMXVALUE FILE
REFERENCED BY
WF200 WF205
UPDATED BY
LO14.3 LO900 LX90.2 LX90.3 LX90.4 LX90.5
LX95.1 LX995 RD30.1 RD30.2 RD50.1 RD50.2
RD70.1 RD70.2 RD88.3 RD930 RD990
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LMV-OBJ-ID Numeric 12 LO900 LX90.2
Element: Obj Id LX90.3 LX90.4
LX90.5 LX95.1
LX995 RD30.1
RD30.2 RD50.1
RD50.2 RD70.1
RD70.2 RD930
LMV-MATRIX-TYPE Alpha 10 LO900 LX90.2
Element: Matrix Type LX90.3 LX90.4
LX90.5 LX95.1
LX995 RD30.1
RD30.2 RD50.1
RD50.2 RD70.1
RD70.2 RD930
LMV-MATRIX-CAT Alpha 14 LO900 LX90.2
Element: Matrix Cat LX90.3 LX90.4
LX90.5 LX95.1
LX995 RD30.1
RD30.2 RD50.1
RD50.2 RD70.1
RD70.2 RD930
LMV-MX-VALUE Alpha 55 (Lower Case) LO900 LX90.2
Element: Mx Value LX90.3 LX90.4
LX90.5 LX95.1
LX995 RD30.1
RD30.2 RD50.1
RD50.2 RD70.1
RD70.2 RD930
LMV-ID-TYPE Alpha 15 (Lower Case) LO900 LX995
Element: Id Type RD30.1 RD30.2
RD50.1 RD50.2
RD70.1 RD70.2
RD930
LMV-ROLE Alpha 20 (Lower Case)
Element: Role
LMV-DESCRIPTION Alpha 50 (Lower Case) LX95.1 LX995
Element: Description This field contains the description.
LMV-DATE Numeric 8 (yyyymmdd) LO900 LX90.2
Element: Date This field contains the system date LX90.3 LX90.4
when this was created. LX90.5 LX95.1
LX995 RD30.1
RD30.2 RD50.1
RD50.2 RD70.1
RD70.2 RD930
LMV-TIME Numeric 6 (hhmmss) LO900 LX90.2
Element: Time LX90.3 LX90.4
LX90.5 LX95.1
LX995 RD30.1
RD30.2 RD50.1
RD50.2 RD70.1
RD70.2 RD930
LMV-TYPE-RECORD Derived
Element: Type Record
LMV-ID-RECORD Derived
Element: Id Record
LOMXVALUE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LMVSET1 OBJ-ID LX90.2 LX90.3
MATRIX-TYPE LX90.4 LX90.5
MATRIX-CAT LX95.1 LX995
RD30.1 RD30.2
RD50.1 RD50.2
RD70.1 RD70.2
RD88.3 RD990
WF200 WF205
LMVSET2 MATRIX-TYPE KeyChange
MATRIX-CAT
MX-VALUE
OBJ-ID
LMVSET3 ID-TYPE KeyChange LO14.3
OBJ-ID
MATRIX-TYPE
MATRIX-CAT
LMVSET4 MATRIX-TYPE RD990
MATRIX-CAT
OBJ-ID
LMVSET5 MATRIX-CAT LX95.1
MATRIX-TYPE
OBJ-ID
LMVSET6 ROLE KeyChange
OBJ-ID
MATRIX-TYPE
MATRIX-CAT
LMVSET7 MX-VALUE KeyChange
MATRIX-TYPE
MATRIX-CAT
OBJ-ID
LOMXVALUE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Lomxtypdef LOMXTYPDEF Required
LMV-MATRIX-TYPE -> MXD-MATRIX-TYPE (MXDSET1)
Matrix Cat MXCATDEF Required
LMV-MATRIX-CAT -> MXC-MATRIX-CAT
Mxidobjcat MXIDOBJCAT Required
LMV-MATRIX-TYPE -> IOC-MATRIX-TYPE
LMV-MATRIX-CAT -> IOC-MATRIX-CAT
LMV-ID-TYPE -> IOC-ID-TYPE
Mxobjcat MXOBJCAT Required
LMV-MATRIX-TYPE -> MOC-MATRIX-TYPE
LMV-ID-TYPE -> MOC-ID-TYPE
Name First LOMXVALUE Not Required
LMV-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-FIRST " -> LMV-MATRIX-CAT
Name Last LOMXVALUE Not Required
LMV-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-LAST " -> LMV-MATRIX-CAT
Same Value LOMXVALUE Not Required
LMV-MATRIX-TYPE -> LMV-MATRIX-TYPE
LMV-MATRIX-CAT -> LMV-MATRIX-CAT
LMV-MX-VALUE -> LMV-MX-VALUE
LMV-OBJ-ID -> LMV-OBJ-ID
Sibslisthd SIBSLISTHD Required
LMV-OBJ-ID -> LSH-OBJ-ID
Sirdidhdr SIRDIDHDR Required
LMV-OBJ-ID -> IDH-OBJ-ID
Sirdrole SIRDROLE Required
LMV-OBJ-ID -> SRO-OBJ-ID
Sirdtype SIRDTYPE Required
LMV-OBJ-ID -> IDT-OBJ-ID
Webuser WEBUSER Required
When (LMV-ID-TYPE = "WEBUS " )
LMV-OBJ-ID -> WUR-OBJ-ID
|