Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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