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 ACBA.1 ACBO.1 ACVW.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 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 GLOB.1 GLVW.1 MX220 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 The Object Type 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 30 (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 ACBA.1 ACBO.1 MATRIX-VIEW ACVW.1 FB95.1 SEQ-NUMBER FB95.2 FB95.3 OBJ-ID FB95.4 FB95.5 FB95.6 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 ... MVDSET2 OBJ-TYPE ACVW.1 RW00.1 OBJ-ID RW200 RW299 GLVW.1 MX20.1 MX20.4 MX20.5 MX20.6 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 FB95.1 FB95.2 MATRIX-VIEW FB95.3 FB95.4 SUMMARY-LVL FB95.5 FB95.6 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 ... 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 |