MXVIEWHDR

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 GL146
GL197 GL298 GL299 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL70.1 GL70.2
GL70.3 GL70.6 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 GL14.1 GL14.5 GL14.7
GL14.8 GL16.1 GL16.2 GL16.3 GL16.4 GL20.7
GL20.8 GL20.9 GL21.3 GL22.3 IFAS.1 IFBA.1
IFBO.1 IFOS.1 MX00.1 MX00.2 MX00.3 MX05.1
MX05.2 MX06.1 MX06.2 MX10.1 MX10.2 MX135
MX220 ML94.1 ML94.2 ML94.3 ML94.4 ML95.1
ML95.2 ML95.3 ML95.4 ML95.5 ML95.6 ML95.7
ML95.8 ML95.9 ML96.1 ML96.2 ML96.3 ML96.4
ML96.5 ML97.1 ML97.2 ML97.3 ML97.4 ML97.5
ML97.6 ML97.7 ML97.8 ML97.9 ML98.1 ML98.2
ML98.3 ML98.4 ML98.5 ML99.1 ML99.2 ML99.3
ML99.4 ML99.5 ML99.6 POA1.1 POA10 POA2.1
POA2.2 POA2.3 POA2.4 POA3.1 SL40.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
Element: Object 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
Element: 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
Element: Description
Alpha 30 (Lower Case)
The view description.
MX20.2 MX20.5
MVH-LAST-SEQ-NBR
Element: Last Sequence Number
Numeric 6
The last sequence number.
MX20.1 MX20.5
MX20.6
MVH-SEGMENT
Element: 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
Element: Short Description
Derived
The short description of the attribute view.


MXVIEWHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MVHSET1 OBJ-TYPE
MATRIX-VIEW
...
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 GL146
GL197 GL298
GL299 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2


MXVIEWHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Object Id OBJID Required
MVH-OBJ-TYPE->OBI-OBJ-TYPE


MXVIEWHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 02:21:03 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.