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
AC300 AC310 AC40.1 AC40.4 AC41.1 AC41.4
AC42.1 AC45.1 AC540 BR40.3 BR40.4 BR46.2
BR46.4 BR530 BRIP.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
AC540 BR40.3
BR40.4 BR46.2
BR46.4 BR530
BRIP.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 AC540 BR40.3
information. Attribute values can then BR40.4 BR46.2
be linked to transactions for reporting BR46.4 BR530
and analysis. BRIP.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
AC540 BR40.3
BR40.4 BR46.2
BR46.4 BR530
BRIP.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 AC256
MATRIX-CAT AC290 AC300
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC54.1
AC540 ACAC.1
BR190 BR20.6
BR40.3 BR40.4
BR46.1 BR46.2
BR46.4 GL146
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
...
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
|