Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTTYPE


                             AMASTTYPE FILE

                               Asset Type

The Asset Type file stores asset types and subtypes, which represent
groupings of like assets that can be used for reporting and defaulting common
asset definition data. You must define at least one asset type. Asset types
must be unique within a general ledger company, and asset subtypes must be
unique within an asset type. Each Asset Type record has one or more Account
records, which identify the general ledger accounts used to create journal
entries when you process (add, adjust, transfer, and dispose of) assets.


REFERENCED BY

AM118     AM120     AM185     AM205     AM206     AM211
AM212     AM220     AM221     AM222     AM223     AM224
AM225     AM235     AM240     AM245     AM25.1    AM25.3
AM250     AM255     AM260     AM265     AM267     AM278
AM280     AM281     AM285     AM287     AM290     AM292
AM295     AM35.1    AM41.1    AM41.2    AM45.1    AM580
AM60.1    AM70.1    AM70.2    AM75.3    AM80.3    AM85.3
AM90.1    AM90.2    AM90.4    AM90.5    AM90.6    AM91.1
AM91.2    AM91.4    AM91.5    AM93.1    AM95.1    AM95.2
AM95.4    AM95.5    AM95.6    AMAS.1    AMDL.1    AM214

UPDATED BY

AM06.1    AM06.2    AM06.3    AM06.5    AM115     AM12.1
AM125     AM135     AM145     AM15.1    AM15.2    AM15.3
AM15.4    AM154     AM170     AM180     AM190     AM192
AM20.1    AM20.2    AM20.3    AM20.4    AM20.5    AM20.6
AM21.1    AM21.2    AM21.3    AM21.4    AM21.5    AM21.6
AM230     AM282     AM30.1    AM30.2    AM40.1    AM40.2
AM40.3    AM500     AM551     AM700     AM88.7    AM96.1
AM98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATP-COMPANY            Numeric 4                                 AM06.1  AM06.2
Element: Company       The general ledger company number         AM06.3  AM06.5
                       associated with the asset type record.    AM115   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM551   AM88.7
                                                                 AM96.1  AM98.1

ATP-ASSET-TYPE         Alpha 10                                  AM06.1  AM06.2
Element: Asset Type    An asset type represents a grouping of    AM06.3  AM06.5
                       like assets. Asset types are used to      AM115   AM12.1
                       group assets into reporting classes and   AM125   AM135
                       to default common asset definition data.  AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM551   AM88.7
                                                                 AM96.1  AM98.1

ATP-SUB-TYPE           Alpha 10                                  AM06.1  AM06.2
Element: Subtype       An asset subtype represents a more        AM06.3  AM06.5
                       detailed grouping of assets within an     AM115   AM12.1
                       asset type grouping. Asset subtypes are   AM125   AM135
                       used to group assets into reporting       AM145   AM15.1
                       classes and to default common asset       AM15.2  AM15.3
                       definition data. Subtypes must be unique  AM15.4  AM154
                       within an asset type.                     AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM551   AM88.7
                                                                 AM96.1  AM98.1

ATP-DESCRIPTION        Alpha 30  (Lower Case)                    AM06.1  AM06.2
Element: Description   The asset type description.               AM06.3  AM06.5
                                                                 AM115   AM12.1
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM551   AM88.7
                                                                 AM96.1  AM98.1

ATP-PROPERTY           Alpha 1                                   AM06.1  AM06.2
Element: Property      This value classifies the kind of         AM06.3  AM06.5
                       property that is represented by this      AM115   AM12.1
                       asset type.                               AM125   AM135
                       P = Personal                              AM145   AM15.1
                       R = Real                                  AM15.2  AM15.3
                       L = Land                                  AM15.4  AM154
                       S = Stock                                 AM170   AM180
                       O = Other                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM551   AM88.7
                                                                 AM96.1  AM98.1

ATP-INV-FLAG           Alpha 1                                   AM06.1  AM06.2
Element: Inv Flag      This flag indicates whether an asset      AM06.3  AM06.5
                       should be included as part of the         AM115   AM12.1
                       physical inventory. If it is not, the     AM125   AM135
                       asset is ignored in inventories. Valid    AM145   AM15.1
                       values are:                               AM15.2  AM15.3
                       Y = Yes                                   AM15.4  AM154
                       N = No                                    AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM551   AM88.7
                                                                 AM96.1  AM98.1

ATP-DEP-EXP-ALLOC      Alpha 1                                   AM06.1  AM06.2
Element: Dep Exp Alloc This field indicates whether the asset    AM06.3  AM06.5
                       type allows depreciation expense to ve    AM115   AM12.1
                       allocated to multiple accounting units.   AM125   AM135
                       Valid values are:                         AM145   AM15.1
                       N = No (the default)                      AM15.2  AM15.3
                       Y = Yes                                   AM15.4  AM154
                                                                 AM170   AM180
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM282
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM500
                                                                 AM551   AM700
                                                                 AM88.7  AM96.1
                                                                 AM98.1

                         AMASTTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATPSET1   COMPANY                                                AM06.1  AM06.2
          ASSET-TYPE                                             AM06.3  AM06.5
          SUB-TYPE                                               AM06.6  AM115
                                                                 AM118   AM12.1
                                                                 AM120   AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM185
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM205   AM206
                                                                 ...

ATPSET2   ASSET-TYPE    KeyChange                                AM06.4  AM06.5
          SUB-TYPE                                               AM115   AM12.1
          COMPANY                                                AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM206   AM211
                                                                 AM212   AM214

                         AMASTTYPE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amcontrol      AMCONTROL    Not Required

                            ATP-COMPANY       -> CTL-COMPANY

Glsystem       GLSYSTEM     Required

                            ATP-COMPANY       -> GLS-COMPANY

                         AMASTTYPE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amaccount      AMACCOUNT    Delete Cascades

                            ATP-COMPANY       -> AAC-COMPANY
                            Spaces            -> AAC-ACCT-GRP
                            ATP-ASSET-TYPE    -> AAC-ASSET-TYPE
                            ATP-SUB-TYPE      -> AAC-SUB-TYPE
                                                 AAC-ACCT-TYPE

Amasset1       AMASSET

                            1                 -> AST-STATUS
                            ATP-COMPANY       -> AST-COMPANY
                            ATP-ASSET-TYPE    -> AST-ASSET-TYPE
                            ATP-SUB-TYPE      -> AST-SUB-TYPE
                                                 AST-DSP-ASSET
                                                 AST-ASSET

Amasset2       AMASSET

                            2                 -> AST-STATUS
                            ATP-COMPANY       -> AST-COMPANY
                            ATP-ASSET-TYPE    -> AST-ASSET-TYPE
                            ATP-SUB-TYPE      -> AST-SUB-TYPE
                                                 AST-DSP-ASSET
                                                 AST-ASSET

Amasset3       AMASSET

                            3                 -> AST-STATUS
                            ATP-COMPANY       -> AST-COMPANY
                            ATP-ASSET-TYPE    -> AST-ASSET-TYPE
                            ATP-SUB-TYPE      -> AST-SUB-TYPE
                                                 AST-DSP-ASSET
                                                 AST-ASSET

Amassetadj     AMASSETADJ

                            ATP-COMPANY       -> ASA-COMPANY
                            ATP-ASSET-TYPE    -> ASA-ASSET-TYPE
                            ATP-SUB-TYPE      -> ASA-SUB-TYPE
                                                 ASA-ASSET
                                                 ASA-PROCESS-SEQ

Amassetdsp     AMASSET

                            9                 -> AST-STATUS
                            ATP-COMPANY       -> AST-COMPANY
                            ATP-ASSET-TYPE    -> AST-ASSET-TYPE
                            ATP-SUB-TYPE      -> AST-SUB-TYPE
                                                 AST-DSP-ASSET
                                                 AST-ASSET

Amassettrf     AMASSETTRF

                            ATP-COMPANY       -> ATF-COMPANY
                            ATP-ASSET-TYPE    -> ATF-ASSET-TYPE
                            ATP-SUB-TYPE      -> ATF-SUB-TYPE
                                                 ATF-ASSET
                                                 ATF-PROCESS-SEQ

Ambooktype     AMBOOKTYPE

                            ATP-ASSET-TYPE    -> ADR-ASSET-TYPE
                                                 ADR-SUB-TYPE
                                                 ADR-BOOK

Amclassdep     AMCLASSDEP

                            ATP-ASSET-TYPE    -> CLD-ASSET-TYPE
                            ATP-SUB-TYPE      -> CLD-SUB-TYPE
                                                 CLD-BOOK
                                                 CLD-COMPANY
                                                 CLD-AST-ACCT-UNIT
                                                 CLD-EXP-ACCT-UNIT
                                                 CLD-ACM-ACCT-UNIT
                                                 CLD-YR-END-DATE
                                                 CLD-PERIOD

Amtypalloc     AMTYPALLOC

                            ATP-COMPANY       -> ALL-COMPANY
                            ATP-ASSET-TYPE    -> ALL-ASSET-TYPE
                            ATP-SUB-TYPE      -> ALL-SUB-TYPE
                                                 ALL-START-DATE
                                                 ALL-SEQUENCE-NBR