MXVIEWHDR – Attribute View Header

System: General Ledger Setup (IF)
Prefix: MVH
Primary key: OBJ-TYPE, MATRIX-VIEW
Fields: 6
Updated by: 4 programs
Referenced by: 151 programs

MXVIEWHDR is the Attribute View Header table in Lawson General Ledger Setup (prefix MVH). It is indexed by OBJ-TYPE, MATRIX-VIEW (MVHSET1). It is related 1:1 to OBJID and 1:M to MXVEWHDRAU and MXVIEWDTL. It is updated by MX20.1, MX20.2, MX20.5 and MX20.6 and referenced by AC13.6, AC16.6, AC91.1, AC91.2, ACDM.2, FB11.1, FB111, FB160 and 143 more. The table has 6 fields, 1 index and 3 documented relations.

About MXVIEWHDR

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.

Fields (6)

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

Field / column	Type	Description & values	Updated by
`MVH-OBJ-TYPE` PK OBJ_TYPE	Alpha 5	This field will determine the type of object that is being used by the Attribute. These values are not user maintainable.	MX20.2
`MVH-MATRIX-VIEW` PK MATRIX_VIEW	Alpha 12	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.	MX20.2, MX20.5
`MVH-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The view description.	MX20.2, MX20.5
`MVH-LAST-SEQ-NBR` LAST_SEQ_NBR	Numeric 6	The last sequence number.	MX20.1, MX20.5, MX20.6
`MVH-SEGMENT` SEGMENT	Alpha 15	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.	MX20.2
`MVH-SHORT-DESC` SHORT_DESC	Derived	The short description of the attribute view.	—

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`MVHSET1`	`OBJ-TYPE`, `MATRIX-VIEW`	Primary		AC13.6, AC16.6, AC91.1, AC91.2, ACDM.2, FB11.1, FB111, FB160 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Object Id	OBJID	Required		`MVH-OBJ-TYPE` → `OBI-OBJ-TYPE`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Mxvewhdrau	MXVEWHDRAU			`MVH-OBJ-TYPE` → `VHA-OBJ-TYPE`, `MVH-MATRIX-VIEW` → `VHA-MATRIX-VIEW`, → `VHA-ACTION`, → `VHA-DATE`, → `VHA-TIME`, → `VHA-UNIQUE-I-D`
Mxviewdtl	MXVIEWDTL	Delete Cascades		`MVH-OBJ-TYPE` → `MVD-OBJ-TYPE`, `MVH-MATRIX-VIEW` → `MVD-MATRIX-VIEW`, → `MVD-SEQ-NUMBER`, → `MVD-OBJ-ID`

Programs

Updated by (4)

MX20.1 View
MX20.2 Define View
MX20.5 View Copy
MX20.6 Move Summary Level

Referenced by (151)

AC13.6 Activity View Preview
AC16.6 Account Category View Preview
AC91.1 Activity View Parameters
AC91.2 Activity View Preview
ACDM.2 Activity Dimension Definition
FB11.1 Budget Edit Group
FB111 Budget Edit Group Build
FB160 Budget Edit Group Interface
FB211 Budget Edit Group Listing
FB296 Budget Audit
FB60.1 Budget Edit Group Interface Maintenance
FB95.1 Budget Analysis
FB95.2 Account, Period
FB95.3 Account, Year to Date
FB95.4 Accounting Unit, Period
FB95.5 Accounting Unit, Year to Date
FB95.6 Totals
GL14.1 Accounting Unit Template Definition
GL14.5 Values By Attribute
GL14.7 Attributes
GL14.8 Copy Accounting Unit Template
GL146 Batch Journal Control
GL16.1 Summary Account Attributes
GL16.2 Detail Account Attributes
GL16.3 Summary Account Values by attribute
GL16.4 Detail Account Values by Attributes
GL197 Period, Year End GL Commitments Processing
GL20.7 Attributes
GL20.8 Attribute Value Effective Date
GL20.9 Values By Attribute Effective Date
GL21.3 Accounting Unit View Preview
GL22.3 Query View Structure
GL298 GL Commitment Analysis Report
GL299 GL and AC History commitment
GL40.1 Journal Entry
GL40.2 Define Journal
GL40.3 Speed Entry
GL40.7 Totals
GL40.8 Journal Entry
GL44.1 Report Currency Entry
GL45.1 Journal Control
GL70.1 Recurring Journal
GL70.2 Define Recurring Journal
GL70.3 Amounts Only
GL70.6 Recurring Copy
GL90.6 Compare Transaction Analysis
GL94.1 Commitment Analysis
GL94.2 Account
GL94.3 Account Totals
GL94.4 Accounting Unit
GL94.5 Accounting Unit Totals
GL94.6 Commitment Account Detail
GL94.7 Commitment Accounting Unit Detail
GL95.1 Account Analysis
GL95.2 Fiscal Year Summary
GL95.3 Totals
GL95.4 Chart Query
GL95.5 Periods versus Year to Date
GL95.6 Year to Date Current Year versus Last Year
GL95.7 Periods Current Year versus Last Year
GL95.8 Year to Date Actual versus Budget
GL95.9 Periods Actual versus Budget
GL96.1 Accounting Units
GL96.2 Year to Date Current Year versus Last Year
GL96.3 Periods Current Year versus Last Year
GL96.4 Year to Date Actual versus Budget
GL96.5 Periods Actual versus Budget
GL97.1 Accounts
GL97.2 Year to Date Current Year versus Last Year
GL97.3 Periods Current Year versus Last Year
GL97.4 Year to Date Actual versus Budget
GL97.5 Periods Actual versus Budget
GL97.6 Year to Date Account Currencies
GL97.7 Periods Account Currencies
GL97.8 Fiscal Year Summary
GL97.9 Totals
GL98.1 Companies
GL98.2 Year to Date Current Year versus Last Year
GL98.3 Periods Current Year versus Last Year
GL98.4 Year to Date Actual versus Budget
GL98.5 Periods Actual versus Budget
GL99.1 Organization Query
GL99.2 Periods versus Year to Date
GL99.3 Year to Date Current Year versus Last Year
GL99.4 Periods Current Year versus Last Year
GL99.5 Year to Date Actual versus Budget
GL99.6 Periods Actual versus Budget
IFAS.1 Account Dimension Definition
IFBA.1 Olap Dimension Retrieval Format
IFBO.1 Olap Dimension Retrieval Format
IFOS.1 Organization Dimension Definition
ML94.1 Ytd Ml and Gl Actuals
ML94.2 Period ML and GL Actuals
ML94.3 YTD ML and GL Actuals
ML94.4 Period ML and GL Actuals
ML95.1 Ledger Account Analysis
ML95.2 Fiscal Year Summary
ML95.3 Totals
ML95.4 Ledger Chart Query
ML95.5 Periods vs. YTD
ML95.6 YTD Current Year vs. Last Year
ML95.7 Periods Current Year vs. Last Year
ML95.8 YTD Actual vs. Budget
ML95.9 Periods Actual vs. Budget
ML96.1 Accounting Units
ML96.2 YTD Current Year vs. Last Year
ML96.3 Periods Current Year vs. Last Year
ML96.4 YTD Actual vs. Budget
ML96.5 Periods Actual vs. Budget
ML97.1 Accounts
ML97.2 YTD Current Year vs. Last Year
ML97.3 Periods Current Year vs. Last Year
ML97.4 YTD Actual vs. Budget
ML97.5 Periods Actual vs. Budget
ML97.6 YTD Account Currencies
ML97.7 Periods Account Currencies
ML97.8 Fiscal Year Summary
ML97.9 Totals
ML98.1 Companies
ML98.2 YTD Current Year vs. Last Year
ML98.3 Periods Current Year vs. Last Year
ML98.4 YTD Actual vs. Budget
ML98.5 Periods Actual vs. Budget
ML99.1 Organization Query
ML99.2 Periods vs. YTD
ML99.3 YTD Current Year vs. Last Year
ML99.4 Periods Current Year vs. Last Year
ML99.5 YTD Actual vs. Budget
ML99.6 Periods Actual vs. Budget
MX00.1 Attribute
MX00.2 Element
MX00.3 Associate Attribute to Objects
MX05.1 Attribute Template
MX05.2 Define Template
MX06.1 Attribute Value Effective Date Template
MX06.2 Define Attibute Value Effective Date Template
MX10.1 List
MX10.2 Define List
MX135 Acct Unit Attribute Value Update For Effective Date
MX220 View Listing
POA1.1 Define Procurement Data Mart
POA10 List Duplicate Values for Data Mart
POA2.1 Define Vendor Dimension
POA2.2 Define Buyer Dimension
POA2.3 Define Product Dimension
POA2.4 Define Organization Dimension
POA3.1 Data Load for Vendor Analysis
RW00.1 Report Writer
SL40.1 Error Transaction Edit
SN70.1 Department Hierarchy
SNAU.1 Build Planning Organization Structure