Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMIAASTDIM


                            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
Element: Ast Dimension

IDA-MEMBER-PREFIX      Alpha 5  (Lower Case)                     AM88.1
Element: Member Prefix The Member Prefix field contains a
                       unique prefix to differentiate the
                       dimension name from other like-named
                       dimensions.  This user-defined name can
                       contain up to five characters of any
                       kind.

IDA-ALIAS-OPTION       Alpha 1                                   AM88.1
Element: Account Flag  D = Description
                       A = Asset Desc
                       T = Tag Desc

IDA-ASSET              Numeric 10                                AM88.1
Element: Asset         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
Element: Last Asset

IDA-MATRIX-LIST        Alpha 12                                  AM88.1
Element: Matrix 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
Element: 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
Element: Disposal Flag I = Include
                       N = Do not include
                       O = Only

IDA-FULL-DEPR-FLAG     Alpha 1                                   AM88.1
Element: Full Depr FlagI = Include
                       N = Do not include
                       O = Only

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

IDA-COMPANY            Numeric 4                                 AM88.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

IDA-COMPANY-GROUP      Alpha 12                                  AM88.1
Element: 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
Element: ClassificationP = Purchased
                       A = All
                       L = Leased
                       D = Depreciable
                       C = Capital Lease
                       O = Operating Lease

IDA-LOCATION-NAME      Alpha 15                                  AM88.1
Element: 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
Element: Division      A user-defined division which is used
                       for reporting assets.

IDA-ASSET-TYPE         Alpha 10                                  AM88.1
Element: 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
Element: 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
Element: Property      This value classifies the kind of
                       property that is represented by this
                       asset type.

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

IDA-SIMULATED          Alpha 1                                   AM88.1
Element: All Flag

IDA-TAX-EXEMPT         Alpha 1                                   AM88.1
Element: All Flag

IDA-USED               Alpha 1                                   AM88.1
Element: All Flag

IDA-LEASE-COMPANY      Numeric 4                                 AM88.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

IDA-LEASE              Alpha 19                                  AM88.1
Element: Lease

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

IDA-ASSET-GROUP        Alpha 10                                  AM88.1
Element: 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