Lawson Insight Technical Documentation |
|
ACMXVAL
ACMXVAL FILE
AC Trans Attribute Values
This file contains information on activity transaction attribute values. These
values are used in determining billing rates or just to store additional
information about a transaction. These values can be printed using the
Activity Management Transaction Writer.
REFERENCED BY
AC190 AC256 AC290 AC54.1 ACAC.1 BR190
BR20.6
UPDATED BY
AC197 AC198 AC300 AC310 AC40.1 AC40.4
AC41.1 AC41.4 AC42.1 AC45.1 AC540 BR124
BR153 BR154 BR40.3 BR40.4 BR46.2 BR46.4
BR530 BRIP.1 ET540 GL146 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 AC197 AC198
Element: Object IdentifRequired key. This is the identifier of AC40.1 AC40.4
the object for the attribute. AC41.1 AC41.4
AC42.1 AC45.1
AC540 BR124
BR153 BR154
BR40.3 BR40.4
BR46.2 BR46.4
BR530 BRIP.1
ET540 GL146
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
ATV-MATRIX-CAT Alpha 12 AC197 AC198
Element: Matrix CategorRequired key. An attribute is a name AC40.1 AC40.4
assigned to an object (for example, job AC41.1 AC41.4
code in Payroll) to track additional AC42.1 AC45.1
information. Attribute values can then AC540 BR124
be linked to transactions for reporting BR153 BR154
and analysis. BR40.3 BR40.4
BR46.2 BR46.4
BR530 BRIP.1
ET540 IFGT.1
ATV-MX-VALUE Alpha 32 AC197 AC198
Element: Matrix Value This is the value of the object for the AC40.1 AC40.4
attribute. AC41.1 AC41.4
AC42.1 AC45.1
AC540 BR124
BR153 BR154
BR40.3 BR40.4
BR46.2 BR46.4
BR530 BRIP.1
ET540 IFGT.1
ATV-DESCRIPTION Alpha 30 (Lower Case) AC197 AC198
Element: Description This field displays the description.
ACMXVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATVSET1 OBJ-ID AC190 AC197
MATRIX-CAT AC198 AC256
AC290 AC300
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC54.1
AC540 ACAC.1
BR124 BR153
BR154 BR190
BR20.6 BR40.3
BR40.4 BR46.1
BR46.2 BR46.4
BRIP.1 ET540
GL146 GL197
...
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
|