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
MX20.1 | MX20.2 | MX20.4 | MX20.5 | MX20.6 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
MVD-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. |
|
||||
MVD-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. |
|
||||
MVD-SEQ-NUMBER Element: Sequence Number | Numeric 6 A unique number assigned to each transaction to be interfaced into the Lawson system. |
|
||||
MVD-OBJ-TYPE-MXVDT Object Type Matrix View | Derived Object type for the View. |
|
||||
MVD-OBJ-ID Element: Object ID | Numeric 12 The object identification associated with a summary or detail record. |
|
||||
MVD-PARENT-OBJ-ID Element: Parent Object ID | Numeric 12 The object identification associated with a summary-type record within the view. |
|
||||
MVD-REC-TYPE Element: Record Type | Alpha 1 The file record type. S = Summary D = Detail |
|
||||
MVD-SUMMARY-LVL Element: Summary Level | Alpha 12 The summary level of the account. |
|
||||
MVD-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The account description. |
|
||||
MVD-TOTAL-DESC Element: Total Description | Alpha 60 (Lower Case) The level total description. |
|
||||
MVD-DEPTH Element: Depth | Numeric 2 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 Element: Space Code | Numeric 1 Indicates the number of spaces after the heading. 1 = One Line 2 = Two Lines 3 = Three Lines 9 = Page Break |
|
||||
MVD-SPACE-CODE-TTL Element: Space Code Total | Numeric 1 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 Element: Underline Before | Alpha 1 Indicates if an underline will occur before the total. S = Single "-" D = Double "=" N = None |
|
||||
MVD-UNDERLINE-AFT Element: Underline After | Alpha 1 Indicates if an underline will occur after the total on a report. S = Single "-" D = Double "=" N = None |
|
||||
MVD-PRINT-HEADING Element: Print Heading | Alpha 1 Indicates if the report heading will be printed. Y = Yes N = No |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MVDSET1 |
OBJ-TYPE MATRIX-VIEW SEQ-NUMBER OBJ-ID |
|
|||||||||||||||||||
MVDSET2 |
OBJ-TYPE OBJ-ID |
|
| ||||||||||||||||||
MVDSET3 |
OBJ-TYPE SUMMARY-LVL OBJ-ID |
|
| ||||||||||||||||||
MVDSET4 |
OBJ-TYPE MATRIX-VIEW PARENT-OBJ-ID SEQ-NUMBER OBJ-ID |
|
| ||||||||||||||||||
MVDSET5 |
OBJ-TYPE MATRIX-VIEW SUMMARY-LVL |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Matrix List | MXLISTHDR |
Required
| ||||||||||||
Mxviewhdr | MXVIEWHDR |
Required
| ||||||||||||
Parent | MXVIEWDTL |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Children | MXVIEWDTL |
| ||||||||||||||||||||||||
Mxvewdtlau | MXVEWDTLAU |
|
All trademarks and registered trademarks are the property of their
respective owners.