Lawson Insight Technical Documentation

                            AMASSETGRP FILE

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

REFERENCED BY

AM213     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
AM80.3    AM85.3    AM93.1    AM96.1    AM98.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ATG-ASSET-GROUP      Alpha 10                                    AM115   AM125
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
                                                                 AM80.3  AM85.3
                                                                 AM93.1  AM96.1
                                                                 AM98.1

ATG-DESCRIPTION      Alpha 30  (Lower Case)                      AM115   AM125
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
                                                                 AM80.3  AM85.3
                                                                 AM93.1  AM96.1
                                                                 AM98.1

ATG-RESTRICT-MEM     Alpha 1
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
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
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
                                                                 AM35.1  AM500
                                                                 AM551   AM80.3
                                                                 AM85.3  AM88.7
                                                                 AM93.1  AM96.1
                                                                 ...

                         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