Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASSETCNV


                            AMASSETCNV FILE

                            Asset Conversion

This file contains non-Lawson asset information to be converted to the Lawson
Asset Management system.


REFERENCED BY

AM97.1    AM98.1

UPDATED BY

AM500     AM96.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ACN-CONVERSION-NBR     Alpha 22                                  AM96.1
Element: Conversion NumRequired key. This is the unique number
                       to ensure that each record is unique.
                       This number also determines the order in
                       which assets are added.


ACN-DESCRIPTION        Alpha 30  (Lower Case)                    AM96.1
Conversion Number      This is the conversion number
Description            description.

ACN-TAG-NBR            Alpha 12                                  AM96.1
Element: Tag Number    This is the tag number for the asset.

ACN-ASSET-GROUP        Alpha 10                                  AM96.1
Element: Asset Group   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.

ACN-ASSET-CATEGORY     Alpha 1                                   AM96.1
Element: Asset CategoryThis is the asset category: depreciable
                       or nondepreciable.

ACN-SIMULATED          Alpha 1                                   AM96.1
Element: Simulated     This field indicates whether the asset
                       is simulated. Simulated assets are
                       imitative representations, not real
                       assets. They can be used to experiment
                       and test strategies. The default for
                       this field is No.

ACN-WORK-IN-PROC       Alpha 1                                   AM96.1
Element: Work-in-ProcesThis field indicates whether the asset
                       is a work-in-process asset.
                       Work-in-process assets are real but not
                       yet complete. If this field is Yes, the
                       asset is on hold and cannot be released.
                       The default for this field is No.

ACN-TAX-EXEMPT         Alpha 1                                   AM96.1
Element: Tax Exempt    This field indicates whether the asset
                       is tax exempt. The default is No.

ACN-USED               Alpha 1                                   AM96.1
Element: Used          This field indicates whether the asset
                       is used. The default is No.

ACN-CURRENCY-CODE      Alpha 5                                   AM96.1
Element: Currency Code This is the base currency defined for
                       the company in the Lawson General Ledger
                       system.

ACN-COMPANY            Numeric 4                                 AM96.1
Element: Company       This is the company number for the
                       asset.

ACN-LOCATION-NAME      Alpha 15                                  AM96.1
Element: Location Name This is the location for the asset.

ACN-DIVISION           Alpha 15                                  AM96.1
Element: Division      This is the division for the asset.

ACN-ASSET-TYPE         Alpha 10                                  AM96.1
Element: Asset Type    This is the asset type. Asset types are
                       user-defined and represent a grouping of
                       like assets. Asset types are used to
                       group assets into reporting classes and
                       to default common asset definition data.


ACN-SUB-TYPE           Alpha 10                                  AM96.1
Element: Asset Subtype This is the asset subtype. An asset
                       subtype represents a more detailed
                       grouping of assets within an asset type.
                       Asset subtypes are used to group assets
                       into reporting classes and allow common
                       asset definition data to default.

ACN-LEASE-COMPANY      Numeric 4                                 AM96.1
Element: Lease Company The lessor company for the converted
                       leased asset.

ACN-LEASE              Alpha 19                                  AM96.1
Element: Lease         The lease number for the converted
                       leased asset.

ACN-ACCT-GRP           Alpha 10                                  AM96.1
Element: Account Group This is the account group for the
                       asset.
                       Account groups are user-defined and are
                       used to identify the general ledger
                       accounts used to create journal entries
                       when assets are processed (added,
                       adjusted, transferred, or disposed of).

ACN-ACCT-UNIT          Alpha 15                                  AM96.1
Element: Accounting UniThis is the accounting unit associated
                       with the asset. The accounting unit must
                       be defined in the General Ledger Names
                       file as a posting accounting unit.


ACN-AU-GROUP           Alpha 10                                  AM96.1
Accounting Unit        Accounting unit groups group and
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.

ACN-DEP-EXP-ACTVTY     Alpha 15                                  AM96.1
Depreciation
Expense Activity

ACN-DEP-ACCT-CAT       Alpha 5                                   AM96.1
Depr Expense
Account Category

ACN-INV-FLAG           Alpha 1                                   AM96.1
Element: Inv Flag      This field indicates whether the asset
                       should be included as part of the
                       physical inventory.  If it is not part
                       of the physical inventory, the asset
                       will be ignored in inventory
                       reconciliation reports. Valid values
                       are:
                       Y = Yes
                       N = No

ACN-ASSET-OWNER        Alpha 10                                  AM96.1
Element: Asset Owner   This field contains the name of the
                       person responsible for tracking and
                       managing the asset.

ACN-CLASSIFICATION     Alpha 1                                   AM96.1
Element: ClassificationThis field indicates whether the asset
                       is purchased, associated with an
                       operating lease, or associated with a
                       capital lease. Valid values are:
                       P = Purchased
                       C = Capital
                       O = Operating

                         AMASSETCNV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACNSET1   CONVERSION-NBR                                         AM500   AM96.1
                                                                 AM97.1  AM98.1

ACNSET2   COMPANY       KeyChange                                AM500
          CONVERSION-NBR

ACNSET3   LEASE-COMPANY KeyChange                                AM500
          LEASE
          CONVERSION-NBR

                         AMASSETCNV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amcnvasset     AMCNVASSET   Not Required

                            ACN-CONVERSION-NBR    -> CVA-CONVERSION-NBR

                         AMASSETCNV FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amastbkcnv     AMASTBKCNV

                            ACN-CONVERSION-NBR    -> ABC-CONVERSION-NBR
                                                     ABC-BOOK

Amastitcnv     AMASTITCNV

                            ACN-CONVERSION-NBR    -> ITC-CONVERSION-NBR
                                                     ITC-SEQ-NUMBER

Amastmxcnv     AMASTMXCNV

                            ACN-CONVERSION-NBR    -> MCV-CONVERSION-NBR
                                                     MCV-MATRIX-CAT

Amasttrcnv     AMASTTRCNV

                            ACN-CONVERSION-NBR    -> TNC-CONVERSION-NBR
                                                     TNC-SEQ-NUMBER