|
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 ATVW.1 FB11.1 FB111
FB160 FB211 FB296 FB60.1 FB95.1 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 GL298 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 GLAV.1
GLVW.1 IFAS.1 IFBA.1 IFBO.1 IFOS.1 MX220
POA1.1 POA10 POA2.1 POA2.2 POA2.3 POA2.4
POA3.1 SLVW.1 SNAU.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
Element: 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
Element: 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
Element: Sequence NumbeA unique number assigned to each MX20.6
transaction to be interfaced 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
Element: Object ID The object identification associated
with a summary or detail record.
MVD-PARENT-OBJ-ID Numeric 12 MX20.1 MX20.5
Element: Parent Object The object identification associated MX20.6
with a summary-type record within the
view.
MVD-REC-TYPE Alpha 1 MX20.1
Element: Record Type The file record type.
S = Summary
D = Detail
MVD-SUMMARY-LVL Alpha 12 MX20.1 MX20.4
Element: Summary Level The summary level of the account.
MVD-DESCRIPTION Alpha 30 (Lower Case) MX20.1
Element: Description The account description.
MVD-TOTAL-DESC Alpha 60 (Lower Case) MX20.1
Element: Total DescriptThe level total description.
MVD-DEPTH Numeric 2 MX20.1
Element: 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
Element: 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
Element: Space Code TotIndicates 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
Element: Underline BefoIndicates if an underline will occur
before the total.
S = Single "-"
D = Double "="
N = None
MVD-UNDERLINE-AFT Alpha 1 MX20.1
Element: Underline AfteIndicates if an underline will occur
after the total on a report.
S = Single "-"
D = Double "="
N = None
MVD-PRINT-HEADING Alpha 1 MX20.1
Element: 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 ATVW.1
SEQ-NUMBER FB11.1 FB111
OBJ-ID FB160 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 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
...
MVDSET2 OBJ-TYPE ACVW.1 ATVW.1
OBJ-ID RW00.1 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 FB111 FB160
SUMMARY-LVL FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
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
...
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
|