Lawson Software

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


                              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     AC256     AC290     AC54.1    AC70.1    AC70.4

UPDATED BY

AC170     AC300     AC310     AC40.1    AC40.4    AC41.1
AC41.4    AC42.1    AC45.1    AC530     AC540     AC542
AC742     GR742     BR40.3    BR40.4    GL146     GL190
GL199     GL45.1    IFGT.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ATV-OBJ-ID           Numeric 12                                  AC170   AC40.1
Object Identifier    Required key. This is the identifier of     AC40.4  AC41.1
                     the object for the attribute.               AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR40.4  GL146
                                                                 GL190   GL199
                                                                 GL45.1  GR742
                                                                 IFGT.1

ATV-MATRIX-CAT       Alpha 12                                    AC170   AC40.1
Matrix Category      Required key. An attribute is a name        AC40.4  AC41.1
                     assigned to an object (for example, job     AC41.4  AC42.1
                     code in Payroll) to track additional        AC45.1  AC530
                     information. Attribute values can then      AC540   AC542
                     be linked to transactions for reporting     AC742   BR40.3
                     and analysis.                               BR40.4  GL199
                                                                 GR742   IFGT.1

ATV-MX-VALUE         Alpha 32                                    AC170   AC40.1
Matrix Value         This is the value of the object for the     AC40.4  AC41.1
                     attribute.                                  AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR40.4  GL199
                                                                 GR742   IFGT.1

                         ACMXVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATVSET1   OBJ-ID                                                 AC170   AC190
          MATRIX-CAT                                             AC256   AC290
                                                                 AC300   AC310
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.1
                                                                 AC530   AC54.1
                                                                 AC540   AC70.1
                                                                 AC70.4  GR742
                                                                 BR40.3  BR40.4
                                                                 GL146   GL190
                                                                 GL45.1

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