Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            AMIAASTDIM FILE

The Asset Dimension file contains the fields which define the asset dimension
of the AM data mart.

REFERENCED BY

AMAS.1    AMDL.1    AMDM.1

UPDATED BY

AM88.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IDA-AST-DIMENSION    Alpha 50  (Lower Case)                      AM88.1
Ast Dimension

IDA-MEMBER-PREFIX    Alpha 5  (Lower Case)                       AM88.1
Member Prefix

IDA-ALIAS-OPTION     Alpha 1                                     AM88.1
Alias Option         D = Description
                     A = Asset Desc
                     T = Tag Desc

IDA-ASSET            Numeric 10                                  AM88.1
Asset Number         The asset number contains up to ten
                     numeric characters that uniquely
                     identify an asset. Assets are
                     automatically numbered system-wide.

IDA-LAST-ASSET       Numeric 10                                  AM88.1
Last Asset

IDA-MATRIX-LIST      Alpha 12                                    AM88.1
Attribute List       Matrix List provides is a list of
                     assets, selected via the matrix system,
                     for output to the data mart.

IDA-DETAIL-LEVEL     Alpha 1                                     AM88.1
Detail Level         This field is used to indicate to the
                     Budget Architect the level of detail
                     associated to the summary account that
                     must be imported to the Pillar budget.
                     A = Asset
                     I = Item

IDA-DISPOSAL-FLAG    Alpha 1                                     AM88.1
Disposal Flag        I = Include
                     N = Do not include
                     O = Only

IDA-FULL-DEPR-FLAG   Alpha 1                                     AM88.1
Full Depr Flag       I = Include
                     N = Do not include
                     O = Only

IDA-FILTER-FLAG      Alpha 1                                     AM88.1
Filter Flag          N = No
                     Y = Yes

IDA-COMPANY          Numeric 4                                   AM88.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.


IDA-COMPANY-GROUP    Alpha 12                                    AM88.1
Company Group        You can type or select a company group.
                     A company group represents one or more
                     companies.

                     If you select a company group, leave
                     the Company field blank.

IDA-CLASSIFICATION   Alpha 1                                     AM88.1
Classification       P = Purchased
                     A = All
                     L = Leased
                     D = Depreciable
                     C = Capital Lease
                     O = Operating Lease

IDA-LOCATION-NAME    Alpha 15                                    AM88.1
Location Name        A user-defined location name which
                     represents where an asset is physically
                     located. Locations are used to report
                     asset information.

IDA-DIVISION         Alpha 15                                    AM88.1
Division             A user-defined division which is used
                     for reporting assets.

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



IDA-SUB-TYPE         Alpha 10                                    AM88.1
Sub Type             An asset subtype represents a more
                     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.


IDA-PROPERTY         Alpha 1                                     AM88.1
Property             This value classifies the kind of
                     property that is represented by this
                     asset type.

IDA-ASSET-CATEGORY   Alpha 1                                     AM88.1
Asset Category

IDA-SIMULATED        Alpha 1                                     AM88.1
Simulated

IDA-TAX-EXEMPT       Alpha 1                                     AM88.1
Tax Exempt

IDA-USED             Alpha 1                                     AM88.1
Used

IDA-LEASE-COMPANY    Numeric 4                                   AM88.1
Lease Company

IDA-LEASE            Alpha 19                                    AM88.1
Lease

IDA-TAG-NBR          Alpha 12                                    AM88.1
Tag Nbr              The tag is a user definable identifier
                     assigned to an asset.

IDA-ASSET-GROUP      Alpha 10                                    AM88.1
Asset Group

                         AMIAASTDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IDASET1   AST-DIMENSION                                          AM88.1  AM88.8
                                                                 AMAS.1  AMDL.1
                                                                 AMDM.1