MXVIEWDTL

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 ATVW.1 GLAV.1 GLVW.1
IFAS.1 IFBA.1 IFBO.1 IFOS.1 MX220 ML94.1
ML94.2 ML94.3 ML94.4 ML95.1 ML95.2 ML95.3
ML95.4 ML95.5 ML95.6 ML95.7 ML95.8 ML95.9
ML96.1 ML96.2 ML96.3 ML96.4 ML96.5 ML97.1
ML97.2 ML97.3 ML97.4 ML97.5 ML97.6 ML97.7
ML97.8 ML97.9 ML98.1 ML98.2 ML98.3 ML98.4
ML98.5 ML99.1 ML99.2 ML99.3 ML99.4 ML99.5
ML99.6 POA1.1 POA10 POA2.1 POA2.2 POA2.3
POA2.4 SLVW.1 SNAU.1 RW00.1 RW200 RW299
MX10.2


UPDATED BY
FB11.1 FB111 FB160 FB211 FB296 FB60.1
FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
GL298 GL299 GL90.6 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 MX20.1 MX20.2 MX20.4 MX20.5
MX20.6 POA3.1 WACP.1 WAOP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MVD-OBJ-TYPE
Element: Object Type
Alpha 5
This field will determine the type of object that is being used by the Attribute. These values are not user maintainable.
MX20.1
MVD-MATRIX-VIEW
Element: Matrix View
Alpha 12
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.
MX20.1 MX20.5
MVD-SEQ-NUMBER
Element: Sequence Number
Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
MX20.1 MX20.5
MX20.6
MVD-OBJ-TYPE-MXVDT
Object Type Matrix
View
Derived
Object type for the View.
MVD-OBJ-ID
Element: Object ID
Numeric 12
The object identification associated with a summary or detail record.
MX20.1 MX20.5
MVD-PARENT-OBJ-ID
Element: Parent Object ID
Numeric 12
The object identification associated with a summary-type record within the view.
MX20.1 MX20.5
MX20.6
MVD-REC-TYPE
Element: Record Type
Alpha 1
The file record type.
S = Summary
D = Detail
MX20.1
MVD-SUMMARY-LVL
Element: Summary Level
Alpha 12
The summary level of the account.
MX20.1 MX20.4
MVD-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The account description.
MX20.1
MVD-TOTAL-DESC
Element: Total Description
Alpha 60 (Lower Case)
The level total description.
MX20.1
MVD-DEPTH
Element: Depth
Numeric 2
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
MX20.1
MVD-SPACE-CODE
Element: Space Code
Numeric 1
Indicates the number of spaces after the heading.
1 = One Line
2 = Two Lines
3 = Three Lines
9 = Page Break
MX20.1
MVD-SPACE-CODE-TTL
Element: Space Code Total
Numeric 1
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
MX20.1
MVD-UNDERLINE-B4
Element: Underline Before
Alpha 1
Indicates if an underline will occur before the total.
S = Single "-"
D = Double "="
N = None
MX20.1
MVD-UNDERLINE-AFT
Element: Underline After
Alpha 1
Indicates if an underline will occur after the total on a report.
S = Single "-"
D = Double "="
N = None
MX20.1
MVD-PRINT-HEADING
Element: Print Heading
Alpha 1
Indicates if the report heading will be printed.
Y = Yes
N = No
MX20.1


MXVIEWDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MVDSET1 OBJ-TYPE
MATRIX-VIEW
SEQ-NUMBER
OBJ-ID
KeyChange
...
AC91.1 ACBA.1
ACVW.1 ATVW.1
FB11.1 FB111
FB160 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL299
GL90.6 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
MVDSET2 OBJ-TYPE
OBJ-ID
ACVW.1 ATVW.1
RW00.1 RW200
RW299 GLAV.1
GLVW.1 MX20.1
MX20.4 MX20.5
MX20.6 SLVW.1
MVDSET3 OBJ-TYPE
SUMMARY-LVL
OBJ-ID
KeyChange, Subset
Where(REC-TYPE ="D")
MX10.2 MX20.1
MVDSET4 OBJ-TYPE
MATRIX-VIEW
PARENT-OBJ-ID
SEQ-NUMBER
OBJ-ID
KeyChange
MX20.1
MVDSET5 OBJ-TYPE
MATRIX-VIEW
SUMMARY-LVL
KeyChange
...
AC91.1 FB11.1
FB111 FB160
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
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


MXVIEWDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:18:51 2016

Home
Contact Us



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