Attribute List Header
This file contains attribute list header category values that can be sorted by a maximum of eight categories. The accounting units on the list can be used individually, or combined into a total.
REFERENCED BY
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MLH-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. |
|||||||||||
| MLH-MATRIX-LIST Element: Matrix List | Alpha 12 Attribute categories are selection parameters used to build a list of objects (accounting units). Attributes and values are the basis of the selection and sorting. An attribute can then be used for reporting on and processing "objects." |
|||||||||||
| MLH-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The attribute description. |
|
||||||||||
| MLH-SHORT-DESC Element: Short Description | Derived The short description. |
|
||||||||||
| MLH-SORT-MX-CAT Element: Sort Matrix Category | Alpha 12 Occurs 8 Times Consists of up to eight attribute categories for sorting the selected objects. The attribute category does not have to be a selection category in order to be a sort category. The sort is in ascending order. |
|
||||||||||
| MLH-CREATOR Element: Creator | Alpha 15 User identification of the person creating the record. |
|
||||||||||
| MLH-LIST-TYPE Element: List Type | Alpha 1 Determines whether the list of objects was automatically created using parameters, or whether it was manually defined. A manual list will never be rebuilt by the system. A = Automatic M = Manual |
|
||||||||||
| MLH-LAST-MAINT-DT Element: Last Maintained Date | Numeric 8 (yyyymmdd) The last date that the list was maintained. |
|||||||||||
| MLH-LAST-MAINT-TM Element: Last Maintained Time | Numeric 6 (hhmmss) The last time that the list was maintained. |
|||||||||||
| MLH-LAST-BUILD-DT Element: Last Build Date | Numeric 8 (yyyymmdd) The last build date. |
|||||||||||
| MLH-LAST-BUILD-TM Element: Last Build Time | Numeric 6 (hhmmss) The last build time. |
|||||||||||
| MLH-LAST-SEQ-NBR Element: Last Sequence Number | Numeric 6 The last sequence number. |
|||||||||||
| MLH-UPDATE-FLAG Element: Update Flag | Alpha 1 This field determines how the List will be rebuilt. System option means the programs using the list will rebuilt it. User option means the list will only be rebuilt when done by a user. S = System U = User |
|
||||||||||
| MLH-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. |
|
||||||||||
| MLH-ARRAY1 Element: Array1 | Derived Used for Drill Around purposes. |
|
||||||||||
| MLH-ARRAY2 Element: Array2 | Derived Used for Drill Around purposes. |
|
||||||||||
| MLH-ARRAY3 Element: Array3 | Derived Used for Drill Around purposes. |
|
||||||||||
| MLH-ARRAY4 Element: Array4 | Derived Used for Drill Around purposes. |
|
||||||||||
| MLH-ARRAY5 Element: Array5 | Derived Used for Drill Around purposes. |
|
||||||||||
| MLH-ARRAY6 Element: Array6 | Derived Used for Drill Around purposes. |
|
||||||||||
| MLH-ARRAY7 Element: Array7 | Derived Used for Drill Around purposes. |
|
||||||||||
| MLH-ARRAY8 Element: Array8 | Derived Used for Drill Around purposes. |
|
||||||||||
| MLH-SORT-MX-CAT-1 Element: Sort Category 1 | Derived Attribute sort category 1. Attribute lists can be sorted using up to eight categories. |
|
||||||||||
| MLH-SORT-MX-CAT-2 Element: Sort Category 2 | Derived Attribute sort category 2. |
|
||||||||||
| MLH-SORT-MX-CAT-3 Element: Sort Category 3 | Derived Attribute sort category 3. |
|
||||||||||
| MLH-SORT-MX-CAT-4 Element: Sort Category 4 | Derived Attribute sort category 4. |
|
||||||||||
| MLH-SORT-MX-CAT-5 Element: Sort Category 5 | Derived Attribute sort category 5. |
|
||||||||||
| MLH-SORT-MX-CAT-6 Element: Sort Category 6 | Derived Attribute sort category 6. |
|
||||||||||
| MLH-SORT-MX-CAT-7 Element: Sort Category 7 | Derived Attribute sort category 7. |
|
||||||||||
| MLH-SORT-MX-CAT-8 Element: Sort Category 8 | Derived Attribute sort category 8. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
|---|---|---|---|---|---|---|---|---|---|
| MLHSET1 |
OBJ-TYPE MATRIX-LIST |
|
|||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
|---|---|---|---|---|---|---|---|---|
| Matrix Cat 1 | MXOBJCAT |
Not Required
| ||||||
| Matrix Cat 2 | MXOBJCAT |
Not Required
| ||||||
| Matrix Cat 3 | MXOBJCAT |
Not Required
| ||||||
| Matrix Cat 4 | MXOBJCAT |
Not Required
| ||||||
| Matrix Cat 5 | MXOBJCAT |
Not Required
| ||||||
| Matrix Cat 6 | MXOBJCAT |
Not Required
| ||||||
| Matrix Cat 7 | MXOBJCAT |
Not Required
| ||||||
| Matrix Cat 8 | MXOBJCAT |
Not Required
| ||||||
| Object Id | OBJID |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mxlistdtl | MXLISTDTL |
Delete Cascades
| |||||||||||||||
| Mxlistmbr | MXLISTMBR |
Delete Cascades
| |||||||||||||||
| Used In View | MXVIEWDTL |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.