 |
Lawson Insight Technical Documentation |
|
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 AC70.1
AC70.4 DA240 GR240
UPDATED BY
AC170 AC300 AC310 AC40.1 AC40.4 AC41.1
AC41.4 AC42.1 AC45.1 AC530 AC540 AC542
BR40.3 BR40.4 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 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
BR40.3 BR40.4
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 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 BR40.3 BR40.4
and analysis. 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
BR40.3 BR40.4
IFGT.1
ATV-DESCRIPTION Alpha 30 (Lower Case)
Description This field displays the description.
ACMXVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATVSET1 OBJ-ID AC170 AC190
MATRIX-CAT AC192 AC256
AC290 AC300
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC54.1 AC540
AC542 AC70.1
AC70.4 DA240
GR240 BR40.3
BR40.4 GL146
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
...
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
|