Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             AMSELECT FILE

                       Asset Processing Selection

This file contains the selection information from AM35.1 (Mass Transfer
Selection) and AM45.1 (Mass Disposal) for mass transfers and mass disposals.

UPDATED BY

AM125     AM135     AM145     AM170     AM25.1    AM35.1
AM45.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AMS-SELECT-NAME      Alpha 15                                    AM25.1  AM35.1
Selection Name       This is the name of the transfer or         AM45.1
                     disposal selection used to make a mass
                     transfer or mass disposal.


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

                     D = Disposal
                     T = Transfer
                     A = Adjustment

AMS-SELECT-ALL       Alpha 1                                     AM25.1  AM35.1
Select All           This field indicates whether you want       AM45.1
                     to select all assets in the listing for
                     transfer or disposal.

                     N = No
                     Y = Yes

AMS-RELEASED         Alpha 1                                     AM125   AM135
Released             This field indicates whether the            AM145
                     transfer or disposal is released.

                     Valid values are

                     Y = Released
                     N = Unreleased


AMS-COMPANY          Numeric 4                                   AM25.1  AM35.1
Company              The company number represents an            AM45.1
                     established company and is entered on
                     all function codes.


AMS-TO-COMPANY       Numeric 4                                   AM35.1
To Company           This is the company number for the
                     transfer-to asset.


AMS-LOCATION-NAME    Alpha 15                                    AM25.1  AM35.1
Location Name        A user-defined location name that           AM45.1
                     represents where an asset is physically
                     located. Locations are used to report
                     asset information.


AMS-TO-LOCATION      Alpha 15                                    AM35.1
To Location          This is the location for the
                     transfer-to asset.


AMS-DIVISION         Alpha 15                                    AM25.1  AM35.1
Division             This is the user-defined division.          AM45.1

AMS-TO-DIVISION      Alpha 15                                    AM35.1
To Division          This is the division for the
                     transfer-to asset.


AMS-ASSET-TYPE       Alpha 10                                    AM25.1  AM35.1
Asset Type           An asset type represents a grouping of      AM45.1
                     like assets. Asset types are used to
                     group assets into reporting classes and
                     to default common asset definition data.



AMS-TO-ASSET-TYPE    Alpha 10                                    AM35.1
To Asset Type        This is the asset type for the
                     transfer-to asset.


AMS-SUB-TYPE         Alpha 10                                    AM25.1  AM35.1
Subtype              An asset subtype represents a more          AM45.1
                     detailed grouping of assets within an
                     asset type grouping. Asset subtypes are
                     used to group assets into reporting
                     classes and allow common asset
                     definition data to default. Subtypes
                     must be unique within an asset type.


AMS-TO-SUB-TYPE      Alpha 10                                    AM135   AM35.1
To Subtype           This is the subtype for the transfer-to
                     asset.


AMS-ACCT-GRP         Alpha 10                                    AM25.1  AM35.1
Account Group        This is the user-defined account group      AM45.1
                     identifying the general ledger accounts
                     used to create journal entries when
                     assets are processed (added, adjusted,
                     transferred, or disposed of).


AMS-TO-ACCT-GRP      Alpha 10                                    AM35.1
To Account Group     This is the account group for the
                     transfer-to asset.


AMS-ACCT-UNIT        Alpha 15                                    AM25.1  AM35.1
Accounting Unit      The accounting unit is a shorthand          AM45.1
                     notation representing the variable level
                     number. The accounting unit must be
                     defined in the General Ledger Names file
                     as a posting accounting unit.


AMS-TO-ACCT-UNIT     Alpha 15                                    AM35.1
To Accounting Unit   This is the accounting unit for the
                     transfer-to asset. An accounting unit is
                     a shorthand notation representing the
                     variable level number. The accounting
                     unit must be defined in the General
                     Ledger Names file as a posting
                     accounting unit.


AMS-AU-GROUP         Alpha 10                                    AM25.1  AM35.1
Accounting Unit      Accounting unit groups group and            AM45.1
Group                identify the accounting units to use
                     when you create journal entries for
                     adding, adjusting, transferring, or
                     disposing of assets. Changes to
                     accounting unit groups are dynamic,
                     affecting all assets using the
                     accounting unit group. Accounting unit
                     group names are user-definable, and
                     accounting unit groups are set up by
                     company.

AMS-TO-AU-GROUP      Alpha 10                                    AM35.1
To Accounting Unit   This is the accounting unit group for
Group                the to-asset. Accounting unit groups
                     group and identify the accounting units
                     to use when you create journal entries
                     for adding, adjusting, transferring, or
                     disposing of assets. Changes to
                     accounting unit groups are dynamic,
                     affecting all assets using the
                     accounting unit group. Accounting unit
                     group names are user-definable, and
                     accounting unit groups are set up by
                     company.


AMS-ASSET-GROUP      Alpha 10                                    AM25.1  AM35.1
Asset Group          An asset group allows you to group          AM45.1
                     related assets that need to depreciate
                     separately; for example, a new roof on a
                     factory building. The building is
                     depreciated over 30 years, but the new
                     roof is depreciated over 15 years. The
                     building and roof would be defined as
                     separate assets, but could be grouped
                     for reporting purposes by assigning an
                     asset group to them.


AMS-TO-ASSET-GROUP   Alpha 10                                    AM35.1
To Asset Group       This is the asset group for the
                     transfer-to asset. An asset group allows
                     you to group related assets that need to
                     depreciate separately; for example, a
                     new roof on a factory building. The
                     building is depreciated over 30 years,
                     but the new roof is depreciated over 15
                     years. The building and roof would be
                     defined as separate assets, but could be
                     grouped for reporting purposes by
                     assigning an asset group to them.


AMS-LEASE-COMPANY    Numeric 4                                   AM25.1  AM45.1
Lease Company

AMS-LEASE            Alpha 19                                    AM25.1  AM45.1
Lease

AMS-DEBIT-TOTAL      Signed 15.2
Debit Total          This is the total debit amount for the
                     selected assets. The debit amount must
                     equal the credit amount.


AMS-CREDIT-TOTAL     Signed 15.2
Credit Total         This is the total credit amount for the
                     selected assets. The credit amount must
                     equal the debit amount.


AMS-LOC-DTL          Alpha 14                                    AM25.1  AM35.1
Loc Dtl              This field contains the location detail     AM45.1
                     of the selected asset items.

AMS-ENABLE-FLAG      Alpha 1                                     AM25.1  AM35.1
Enable Flag          This field contains the value of the        AM45.1
                     Filter flag, which controls additional
                     selection criteria. Y means that the
                     filter is enabled; N means that the
                     filter is not in effect.
                     Y = Enabled
                     N = Disabled

AMS-PROPERTY         Alpha 1                                     AM25.1
Property             This value classifies the kind of
                     property that is represented by this
                     asset type.
                     P = Personal
                     S = Stock
                     L = Land
                     R = Real
                     O = Other

AMS-ASSET-CATEGORY   Alpha 1                                     AM25.1
Asset Category       N = Non Depreciable
                     D = Depreciable

AMS-MATRIX-LIST      Alpha 12                                    AM25.1  AM35.1
Attribute List       Attribute categories are selection          AM45.1
                     parameters used to build a list of
                     objects (accounting units). Attribute
                     categories and values are the basis of
                     the selection and sorting. A attribute
                     list can then be used for reporting on
                     and processing objects.


                         AMSELECT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AMSSET1   SELECT-NAME                                            AM125   AM135
          SELECT-TYPE                                            AM145   AM25.1
                                                                 AM25.3  AM35.1
                                                                 AM35.3  AM45.1
                                                                 AM45.3

AMSSET2   COMPANY       Subset                                   AM170
          SELECT-TYPE   Where RELEASED = "Y"
          SELECT-NAME

                         AMSELECT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amseldtl       AMSELDTL

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