Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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

AM125     AM135     AM145

UPDATED BY

AM25.1    AM35.1    AM45.1    AM170

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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

                     D = Disposal
                     T = Transfer
                     A = Adjustment

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

                     I = Include
                     E = Exclude

SLD-ASSET            Numeric 10                                  AM25.1  AM35.1
Asset                This is the asset being transferred or      AM45.1
                     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                                            AM125   AM135
          SELECT-TYPE                                            AM145   AM170
          ASSET                                                  AM25.1  AM25.3
                                                                 AM35.1  AM35.3
                                                                 AM45.1  AM45.3

                         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