Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             AMSELDTL FILE

                         Asset Selection Detail

This file contains detailed selection information for mass transfer and
disposal selections. The file is updated by AM35.1 (Mass Transfer Selection)
and AM45.1 (Mass Disposal Selection).


REFERENCED BY

AM135     AM145

UPDATED BY

AM35.1    AM45.1    AM170

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SLD-SELECT-NAME      Alpha 15                                    AM35.1  AM45.1
Selection Name       This is the name of the selection for
                     the mass transfer or disposal.


SLD-SELECT-TYPE      Alpha 1                                     AM35.1  AM45.1
Selection Type       This is the selection type: disposal or
                     transfer.

                     D = Disposal
                     T = Transfer

SLD-INCL-EXCL-AST    Alpha 1                                     AM35.1  AM45.1
Include or Exclude   This field indicates whether to include
Asset                (I) assets or exclude (E) them from the
                     selection.

                     I = Include
                     E = Exclude

SLD-ASSET            Numeric 10                                  AM35.1  AM45.1
Asset                This is the asset being transferred or
                     disposed of. The asset number contains
                     up to ten numeric characters that
                     uniquely identify an asset. Assets are
                     automatically numbered system-wide.


SLD-TAG-NBR          Alpha 12                                    AM35.1
Tag                  The tag is a user-definable identifier
                     assigned to an asset.


SLD-TO-TAG-NBR       Alpha 12                                    AM35.1
To Tag               This is the tag number for the
                     transfer-to asset.


                         AMSELDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SLDSET1   SELECT-NAME                                            AM135   AM145
          SELECT-TYPE                                            AM170   AM35.1
          ASSET                                                  AM45.1

                         AMSELDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amassset       AMASSET      Required

                            SLD-ASSET          -> AST-ASSET

Amselect       AMSELECT     Required

                            SLD-SELECT-NAME    -> AMS-SELECT-NAME
                            SLD-SELECT-TYPE    -> AMS-SELECT-TYPE