Lawson Insight Technical Documentation
Generated by:
Documentation generated by Decision Analytics
ERDs Tables Conditions Elements Libraries APIs Forms

ACMXVAL


                              ACMXVAL FILE

                       AC Trans Attribute Values

This file contains information on activity transaction attribute values.
These values are used in determining billing rates.

REFERENCED BY

AC190     AC192     AC256     AC290     AC54.1

UPDATED BY

AC300     AC310     AC40.1    AC40.4    AC41.1    AC41.4
AC42.1    AC45.1    AC530     AC540     AC542     BR124
BR153     BR154     BR40.3    BR40.4    BR521     BR530
BRPI.1    GL146     GL190     GL197     GL199     GL40.1
GL40.2    GL40.3    GL40.7    GL40.8    GL44.1    GL45.1
IFGT.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATV-OBJ-ID             Numeric 12                                AC40.1  AC40.4
Element: Object IdentifRequired key. This is the identifier of   AC41.1  AC41.4
                       the object for the attribute.             AC42.1  AC45.1
                                                                 AC530   AC540
                                                                 AC542   BR124
                                                                 BR153   BR154
                                                                 BR40.3  BR40.4
                                                                 BR521   BR530
                                                                 BRPI.1  GL146
                                                                 GL190   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1

ATV-MATRIX-CAT         Alpha 12                                  AC40.1  AC40.4
Element: Matrix CategorRequired key. An attribute is a name      AC41.1  AC41.4
                       assigned to an object (for example, job   AC42.1  AC45.1
                       code in Payroll) to track additional      AC530   AC540
                       information. Attribute values can then    AC542   BR124
                       be linked to transactions for reporting   BR153   BR154
                       and analysis.                             BR40.3  BR40.4
                                                                 BR521   BR530
                                                                 BRPI.1  IFGT.1

ATV-MX-VALUE           Alpha 32                                  AC40.1  AC40.4
Element: Matrix Value  This is the value of the object for the   AC41.1  AC41.4
                       attribute.                                AC42.1  AC45.1
                                                                 AC530   AC540
                                                                 AC542   BR124
                                                                 BR153   BR154
                                                                 BR40.3  BR40.4
                                                                 BR521   BR530
                                                                 BRPI.1  IFGT.1

ATV-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   This field displays the description.

                         ACMXVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATVSET1   OBJ-ID                                                 AC190   AC192
          MATRIX-CAT                                             AC256   AC290
                                                                 AC300   AC310
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.1
                                                                 AC530   AC54.1
                                                                 AC540   AC542
                                                                 BR124   BR153
                                                                 BR154   BR40.3
                                                                 BR40.4  BRPI.1
                                                                 GL146   GL190
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 ...

ATVSET2   MATRIX-CAT    KeyChange                                AC256
          MX-VALUE
          OBJ-ID*

                         ACMXVAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxcatdef       MXCATDEF     Required

                            ATV-MATRIX-CAT    -> MXC-MATRIX-CAT

Mxobjcat       MXOBJCAT     Required

                            "ACTRN"           -> MOC-OBJ-TYPE
                            ATV-MATRIX-CAT    -> MOC-MATRIX-CAT