Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXVIEWHDR


                             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    AC16.6    AC91.1    AC91.2    ACDM.2    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
RW00.1    GL21.3    GL22.3    IFAS.1    IFBA.1    IFBO.1
IFOS.1    MX220     POA1.1    POA10     POA2.1    POA2.2
POA2.3    POA2.4    POA3.1    SN70.1    SNAU.1

UPDATED BY

MX20.1    MX20.2    MX20.5    MX20.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MVH-OBJ-TYPE           Alpha 5                                   MX20.2
Element: Object Type   This 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
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.


MVH-DESCRIPTION        Alpha 30  (Lower Case)                    MX20.2  MX20.5
Element: Description   The view description.

MVH-LAST-SEQ-NBR       Numeric 6                                 MX20.1  MX20.5
Element: Last Sequence The last sequence number.                 MX20.6

MVH-SEGMENT            Alpha 15                                  MX20.2
Element: Segment       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
Element: Short DescriptThe short description of the attribute
                       view.


                         MXVIEWHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MVHSET1   OBJ-TYPE                                               AC13.6  AC16.6
          MATRIX-VIEW                                            AC91.1  AC91.2
                                                                 ACDM.2  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
                                                                 ...

                         MXVIEWHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Object Id      OBJID        Required

                            MVH-OBJ-TYPE       -> 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