Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXVIEWDTL


                             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    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    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  FB11.1
          SEQ-NUMBER                                             FB111   FB160
          OBJ-ID                                                 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
                                                                 ...

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                                            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