 |
Lawson Insight Technical Documentation |
|
MXVIEWDTL FILE
Attribute View Detail
This file contains attribute view detail records including the object type,
attribute view, object ID, summary information, and printing options defined
in MX20.1 (View). A attribute view consists of several attribute lists that
have similar characteristics and are linked together.
REFERENCED BY
AC91.1 ACBA.1 ACVW.1 FB11.1 FB211 FB296
FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
GL298 GL94.1 GL94.2 GL94.3 GL94.4 GL94.5
GL94.6 GL94.7 GL95.1 GL95.2 GL95.3 GL95.4
GL95.5 GL95.6 GL95.7 GL95.8 GL95.9 GL96.1
GL96.2 GL96.3 GL96.4 GL96.5 GL97.1 GL97.2
GL97.3 GL97.4 GL97.5 GL97.6 GL97.7 GL97.8
GL97.9 GL98.1 GL98.2 GL98.3 GL98.4 GL98.5
GL99.1 GL99.2 GL99.3 GL99.4 GL99.5 GL99.6
GLAV.1 GLVW.1 IFAS.1 IFBA.1 IFBO.1 IFOS.1
MX220 SLVW.1 RW00.1 RW200 RW299 MX10.2
UPDATED BY
MX20.1 MX20.2 MX20.4 MX20.5 MX20.6
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MVD-OBJ-TYPE Alpha 5 MX20.1
Object Type This field will determine the type of
object that is being used by the
Attribute. These values are not user
maintainable.
MVD-MATRIX-VIEW Alpha 12 MX20.1 MX20.5
Matrix View A hierarchy of attribute lists
containing up to nine levels of
totaling. The attribute view is based on
the Chart of Accounts and consists of
summary and detail records.
MVD-SEQ-NUMBER Numeric 6 MX20.1 MX20.5
Sequence Number A unique number assigned to each MX20.6
transaction to be transferred into the
Lawson system.
MVD-OBJ-TYPE-MXVDT Derived
Object Type Matrix Object type for the View.
View
MVD-OBJ-ID Numeric 12 MX20.1 MX20.5
Object ID The object identification associated
with a summary or detail record.
MVD-PARENT-OBJ-ID Numeric 12 MX20.1 MX20.5
Parent Object ID The object identification associated MX20.6
with a summary-type record within the
view.
MVD-REC-TYPE Alpha 1 MX20.1
Record Type The file record type.
S = Summary
D = Detail
MVD-SUMMARY-LVL Alpha 12 MX20.1 MX20.4
Summary Level The summary level of the account.
MVD-DESCRIPTION Alpha 30 (Lower Case) MX20.1
Description The account description.
MVD-TOTAL-DESC Alpha 60 (Lower Case) MX20.1
Total Description The level total description.
MVD-DEPTH Numeric 2 MX20.1
Depth The level depth.
01 = Depth 1
02 = Depth 2
03 = Depth 3
04 = Depth 4
05 = Depth 5
06 = Depth 6
07 = Depth 7
08 = Depth 8
09 = Depth 9
MVD-SPACE-CODE Numeric 1 MX20.1
Space Code Indicates the number of spaces after
the heading.
1 = One Line
2 = Two Lines
3 = Three Lines
9 = Page Break
MVD-SPACE-CODE-TTL Numeric 1 MX20.1
Space Code Total Indicates the number of spaces to
advance after the total appears on a
report.
1 = One Line
2 = Two Lines
3 = Three Lines
9 = Page Break
MVD-UNDERLINE-B4 Alpha 1 MX20.1
Underline Before Indicates if an underline will occur
before the total.
S = Single "-"
D = Double "="
N = None
MVD-UNDERLINE-AFT Alpha 1 MX20.1
Underline After Indicates if an underline will occur
after the total on a report.
S = Single "-"
D = Double "="
N = None
MVD-PRINT-HEADING Alpha 1 MX20.1
Print Heading Indicates if the report heading will be
printed.
Y = Yes
N = No
MXVIEWDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MVDSET1 OBJ-TYPE KeyChange AC91.1 ACBA.1
MATRIX-VIEW ACVW.1 FB11.1
SEQ-NUMBER FB211 FB296
OBJ-ID FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
...
MVDSET2 OBJ-TYPE ACVW.1 RW00.1
OBJ-ID RW200 RW299
GLAV.1 GLVW.1
MX20.1 MX20.4
MX20.5 MX20.6
SLVW.1
MVDSET3 OBJ-TYPE KeyChange, Subset MX10.2 MX20.1
SUMMARY-LVL Where (REC-TYPE = "D" )
OBJ-ID
MVDSET4 OBJ-TYPE KeyChange MX20.1
MATRIX-VIEW
PARENT-OBJ-ID
SEQ-NUMBER
OBJ-ID
MVDSET5 OBJ-TYPE KeyChange AC91.1 FB11.1
MATRIX-VIEW FB211 FB296
SUMMARY-LVL FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
...
MXVIEWDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Matrix List MXLISTHDR Required
When (MVD-REC-TYPE = "D" )
MVD-OBJ-TYPE -> MLH-OBJ-TYPE
MVD-SUMMARY-LVL -> MLH-MATRIX-LIST
Mxviewhdr MXVIEWHDR Required
MVD-OBJ-TYPE -> MVH-OBJ-TYPE
MVD-MATRIX-VIEW -> MVH-MATRIX-VIEW
Parent MXVIEWDTL Required
MVD-OBJ-TYPE -> MVD-OBJ-TYPE
MVD-PARENT-OBJ-ID -> MVD-OBJ-ID
MXVIEWDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Children MXVIEWDTL
MVD-OBJ-TYPE -> MVD-OBJ-TYPE
MVD-MATRIX-VIEW -> MVD-MATRIX-VIEW
MVD-OBJ-ID -> MVD-PARENT-OBJ-ID
MVD-SEQ-NUMBER
MVD-OBJ-ID
|