Lawson Insight Technical Documentation

                            AMASSETGRP FILE

The Asset Management Asset Group file maitains the names and descriptions of
asset groups.

REFERENCED BY

AM213     AM330     AM75.3    AM80.3    AM85.3    AM88.7

UPDATED BY

AM115     AM125     AM13.1    AM13.2    AM15.1    AM15.2
AM15.3    AM15.4    AM170     AM20.1    AM20.2    AM20.3
AM20.4    AM20.5    AM20.6    AM21.1    AM21.2    AM21.3
AM21.4    AM21.5    AM21.6    AM35.1    AM500     AM551
AM93.1    AM96.1    AM98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATG-ASSET-GROUP        Alpha 10                                  AM115   AM125
Element: Asset Group   This field contains the name of the       AM13.1  AM13.2
                       asset group.                              AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM35.1
                                                                 AM500   AM551
                                                                 AM93.1  AM96.1
                                                                 AM98.1

ATG-DESCRIPTION        Alpha 30  (Lower Case)                    AM115   AM125
Element: Description   This field contains the description of    AM13.1  AM13.2
                       the asset group.                          AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM35.1
                                                                 AM500   AM551
                                                                 AM93.1  AM96.1
                                                                 AM98.1

ATG-RESTRICT-MEM       Alpha 1
Element: Restrict Mem  This flag indicates whether the assets
                       belonging to an asset group are required
                       to be associated with a specific asset
                       type or asset type and subtype.  Valid
                       values are:

                       Y = Yes
                       N = No

ATG-ASSET              Numeric 10
Element: Asset Number  This field contains the base asset
                       number. That is the first asset to
                       select this asset group.  All assets
                       that are added to the asset group
                       subsequently are edited against this
                       asset if the Restrict Mem (Restricted
                       Membership) field is set to Yes.

ATG-RESTRICT-MOD       Alpha 1
Element: Restrict Mod  This field indicates whether all assets
                       belonging to the asset group should be
                       adjusted, transfered,and disposed as a
                       group.

                         AMASSETGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATGSET1   ASSET-GROUP                                            AM115   AM125
                                                                 AM13.1  AM13.2
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM213
                                                                 AM330   AM35.1
                                                                 AM500   AM551
                                                                 AM75.3  AM80.3
                                                                 AM85.3  AM88.7
                                                                 ...

                         AMASSETGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET

                            ATG-ASSET-GROUP    -> AST-ASSET-GROUP
                                                  AST-ASSET