|
|
MXVIEWHDR FILE
Attribute View Header
This file contains attribute view header records including the object type,
view name, and description defined in MX20.1 (View). A attribute view is made
up of attribute lists with similar characteristics which are linked together.
A view is based on a Chart of Accounts consisting of summary and detail
records. The detail records represent attribute lists. Total lines are created
for each summary record.
Views can be used instead of a level-type row file in Lawson Report Writer or
the GL View Analysis program.
REFERENCED BY
AC13.6 AC87.1 FB95.1 FB95.2 FB95.3 FB95.4
FB95.5 FB95.6 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
RW00.1 GL21.3 GL87.1 GL88.1 MX220
UPDATED BY
MX20.1 MX20.2 MX20.5 MX20.6
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MVH-OBJ-TYPE Alpha 5 MX20.2
Object Type The Object Type field will determine
the type of object that is being used by
the Attribute. These values are not
user maintainable.
MVH-MATRIX-VIEW Alpha 12 MX20.2 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.
MVH-DESCRIPTION Alpha 30 (Lower Case) MX20.2 MX20.5
Description The view description.
MVH-LAST-SEQ-NBR Numeric 6 MX20.1 MX20.5
Last Sequence Number The last sequence number. MX20.6
MVH-SEGMENT Alpha 15 MX20.2
User Analysis The name that identifies the user
analysis.
A user analysis is a flexible,
user-defined element, much like an
accounting unit, account, or attribute,
that stores transaction information you
can use for reports and analysis.
You can use a user analysis to track
multiple elements of business data.
MVH-SHORT-DESC Derived
Short Description The short description of the attribute
view.
MXVIEWHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MVHSET1 OBJ-TYPE AC13.6 AC87.1
MATRIX-VIEW FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
...
MXVIEWHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Object Id OBJID Required
"M" -> OBI-OBJ-TYPE
MXVIEWHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mxviewdtl MXVIEWDTL Delete Cascades
MVH-OBJ-TYPE -> MVD-OBJ-TYPE
MVH-MATRIX-VIEW -> MVD-MATRIX-VIEW
MVD-SEQ-NUMBER
MVD-OBJ-ID
|