Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ACIAACVDIM FILE

REFERENCED BY

ACBA.1    ACDL.1

UPDATED BY

ACDM.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IAV-ACV-DIMENSION    Alpha 50  (Lower Case)                      ACDM.2
Acv Dimension

IAV-ACV-PREFIX       Alpha 5  (Lower Case)                       ACDM.2
Acv Prefix

IAV-ACV-ALIAS-OPT    Alpha 1                                     ACDM.2
Acv Alias Opt

IAV-ACTIVITY-GRP     Alpha 15                                    ACDM.2
Activity Group

IAV-COLLECTION       Alpha 15                                    ACDM.2
Collection

IAV-ACTIVITY         Alpha 15                                    ACDM.2
Activity             Activities are the processes or
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity.


IAV-ACV-VIEW-1       Alpha 12                                    ACDM.2
Acv View 1

IAV-ACV-VIEW-2       Alpha 12                                    ACDM.2
Acv View 2

IAV-TYPE             Alpha 2                                     ACDM.2
Type                 This identifies whether this record is
                     created because of a picking
                     transaction, or because of a return.
                     Valid values are:
                         "IS" = Picking transaction.
                         "RR" = Return.
                      ~$1 VENDOR
                     The vendor's identification code.


IAV-LEVEL            Numeric 1                                   ACDM.2
Level

                         ACIAACVDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IAVSET1   ACV-DIMENSION                                          ACBA.1  ACDL.1
                                                                 ACDM.1  ACDM.2

                         ACIAACVDIM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

                            IAV-ACTIVITY-GRP    -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Not Required

                            IAV-ACTIVITY        -> ACV-ACTIVITY

Accolgrp       ACCOLGRP     Not Required

                            IAV-COLLECTION      -> CLG-COLLECTION

Mxviewhdr 1    MXVIEWHDR    Not Required

                            "ACTVY"             -> MVH-OBJ-TYPE
                            IAV-ACV-VIEW-1      -> MVH-MATRIX-VIEW

Mxviewhdr 2    MXVIEWHDR    Not Required

                            "ACTVY"             -> MVH-OBJ-TYPE
                            IAV-ACV-VIEW-2      -> MVH-MATRIX-VIEW