MXVIEWDTL – Attribute View Detail

System
General Ledger Setup (IF)
Prefix
MVD
Primary key
OBJ-TYPE, MATRIX-VIEW, SEQ-NUMBER, OBJ-ID
Fields
16
Updated by
5 programs
Referenced by
152 programs

MXVIEWDTL is the Attribute View Detail table in Lawson General Ledger Setup (prefix MVD). It is indexed by OBJ-TYPE, MATRIX-VIEW, SEQ-NUMBER, OBJ-ID (MVDSET1); alternate indexes: MVDSET2, MVDSET3, MVDSET4 and MVDSET5. It is related 1:1 to MXLISTHDR, MXVIEWHDR and MXVIEWDTL and 1:M to MXVIEWDTL and MXVEWDTLAU. It is updated by MX20.1, MX20.2, MX20.4, MX20.5 and MX20.6 and referenced by AC91.1, ACBA.1, ACVW.1, ATVW.1, FB11.1, FB111, FB160, FB211 and 144 more. The table has 16 fields, 5 indexes and 5 documented relations.

About MXVIEWDTL

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.

Fields (16)

Column = COBOL field name without the MVD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MVD-OBJ-TYPE PK
OBJ_TYPE		Alpha 5This field will determine the type of object that is being used by the Attribute. These values are not user maintainable.MX20.1
MVD-MATRIX-VIEW PK
MATRIX_VIEW		Alpha 12A 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.MX20.1, MX20.5
MVD-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.MX20.1, MX20.5, MX20.6
MVD-OBJ-TYPE-MXVDT
OBJ_TYPE_MXVDT		DerivedObject type for the View.—
MVD-OBJ-ID PK
OBJ_ID		Numeric 12The object identification associated with a summary or detail record.MX20.1, MX20.5
MVD-PARENT-OBJ-ID
PARENT_OBJ_ID		Numeric 12The object identification associated with a summary-type record within the view.MX20.1, MX20.5, MX20.6
MVD-REC-TYPE
REC_TYPE		Alpha 1The file record type.
  • S Summary
  • D Detail
MX20.1
MVD-SUMMARY-LVL
SUMMARY_LVL		Alpha 12The summary level of the account.MX20.1, MX20.4
MVD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The account description.MX20.1
MVD-TOTAL-DESC
TOTAL_DESC		Alpha 60 (Lower Case)The level total description.MX20.1
MVD-DEPTH
DEPTH		Numeric 2The 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
MX20.1
MVD-SPACE-CODE
SPACE_CODE		Numeric 1Indicates the number of spaces after the heading.
  • 1 One Line
  • 2 Two Lines
  • 3 Three Lines
  • 9 Page Break
MX20.1
MVD-SPACE-CODE-TTL
SPACE_CODE_TTL		Numeric 1Indicates 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
MX20.1
MVD-UNDERLINE-B4
UNDERLINE_B4		Alpha 1Indicates if an underline will occur before the total.
  • S Single "-"
  • D Double "="
  • N None
MX20.1
MVD-UNDERLINE-AFT
UNDERLINE_AFT		Alpha 1Indicates if an underline will occur after the total on a report.
  • S Single "-"
  • D Double "="
  • N None
MX20.1
MVD-PRINT-HEADING
PRINT_HEADING		Alpha 1Indicates if the report heading will be printed.
  • Y Yes
  • N No
MX20.1

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MVDSET1OBJ-TYPE, MATRIX-VIEW, SEQ-NUMBER, OBJ-IDPrimary, KeyChangeAC91.1, ACBA.1, ACVW.1, ATVW.1, FB11.1, FB111, FB160, FB211 +22 more (list truncated in source)
MVDSET2OBJ-TYPE, OBJ-IDACVW.1, ATVW.1, RW00.1, RW200, RW299, GLAV.1, GLVW.1, MX20.1 +4 more
MVDSET3OBJ-TYPE, SUMMARY-LVL, OBJ-IDKeyChange, SubsetWhere (REC-TYPE = "D")MX10.2, MX20.1
MVDSET4OBJ-TYPE, MATRIX-VIEW, PARENT-OBJ-ID, SEQ-NUMBER, OBJ-IDKeyChangeMX20.1
MVDSET5OBJ-TYPE, MATRIX-VIEW, SUMMARY-LVLKeyChangeAC91.1, FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Matrix ListMXLISTHDRRequiredWhen (MVD-REC-TYPE = "D")MVD-OBJ-TYPE → MLH-OBJ-TYPE, MVD-SUMMARY-LVL → MLH-MATRIX-LIST
MxviewhdrMXVIEWHDRRequiredMVD-OBJ-TYPE → MVH-OBJ-TYPE, MVD-MATRIX-VIEW → MVH-MATRIX-VIEW
ParentMXVIEWDTLRequiredMVD-OBJ-TYPE → MVD-OBJ-TYPE, MVD-PARENT-OBJ-ID → MVD-OBJ-ID

One to many (2) — child tables

RelationTableRulesConditionField map
ChildrenMXVIEWDTLMVD-OBJ-TYPE → MVD-OBJ-TYPE, MVD-MATRIX-VIEW → MVD-MATRIX-VIEW, MVD-OBJ-ID → MVD-PARENT-OBJ-ID, → MVD-SEQ-NUMBER, → MVD-OBJ-ID
MxvewdtlauMXVEWDTLAUMVD-OBJ-TYPE → VDA-OBJ-TYPE, MVD-MATRIX-VIEW → VDA-MATRIX-VIEW, MVD-SEQ-NUMBER → VDA-SEQ-NUMBER, MVD-OBJ-ID → VDA-OBJ-ID, → VDA-ACTION, → VDA-DATE, → VDA-TIME, → VDA-UNIQUE-I-D

Programs

Updated by (5)

Referenced by (152)