Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACIAACVDIM


                            ACIAACVDIM FILE

REFERENCED BY

ACBA.1    ACDL.1    HC02.1    HCHP.1

UPDATED BY

ACDM.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IAV-ACV-DIMENSION      Alpha 50  (Lower Case)                    ACDM.2
Element: Org Dimension The Organization Dimension Name field
                       contains the user-defined name for the
                       Organization dimension. This name can
                       contain up to 30 characters of any kind.


IAV-ACV-PREFIX         Alpha 5  (Lower Case)                     ACDM.2
Element: Typ Prefix    The Type Prefix field contains a unique
                       prefix name that differentiates the
                       members in the Type dimension with
                       similar members in other dimensions.
                       This prefix can contain up to five
                       characters of any kind.


IAV-GROUP-PREFIX       Alpha 5  (Lower Case)                     ACDM.2
Element: Typ Prefix    The Type Prefix field contains a unique
                       prefix name that differentiates the
                       members in the Type dimension with
                       similar members in other dimensions.
                       This prefix can contain up to five
                       characters of any kind.


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

IAV-ACTIVITY-GRP       Alpha 15                                  ACDM.2
Element: Activity Grp  The activity group is the overall
                       project.

IAV-AG-MATRIX-LIST     Alpha 12                                  ACDM.2
Element: Ag Matrix ListActivity Group List

IAV-ACTIVITY           Alpha 15                                  ACDM.2
Element: 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
Element: Acv View 1

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

IAV-TYPE               Alpha 2                                   ACDM.2
Element: 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
Element: Level

                         ACIAACVDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IAVSET1   ACV-DIMENSION                                          ACBA.1  ACDL.1
                                                                 ACDM.1  ACDM.2
                                                                 ACDM.9  HC02.1
                                                                 HCHP.1

                         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

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