Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMPUCODE


                             AMPUCODE FILE

                           Personal Use Code

The Personal Use Code file stores personal use codes, which asset books use
to calculate depreciation. These records describe depreciation and tax credit
calculation options, and annual depreciation limits up to twenty years.

Note: The Asset Management system does not provide a method to delete records
from this file.



REFERENCED BY

AC160     AM115     AM117     AM12.1    AM125     AM145
AM15.1    AM15.2    AM15.3    AM15.4    AM154     AM180
AM185     AM19.1    AM19.2    AM190     AM192     AM195
AM20.1    AM20.2    AM20.4    AM20.8    AM200     AM21.1
AM21.2    AM21.4    AM21.8    AM255     AM280     AM295
AM40.1    AM40.2    AM500     AM502     AM551     AM580
AM92.1    AM98.1    AP115     AP125     AP126     AP131
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP21.1    AP220     AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    AP30.2    AP30.4    AP305     API1.1    API2.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
MA180     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.4    MA43.6    MA43.7    MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA63.1
MA65.1    MA66.2    MA66.3    MA67.2    MA67.3    MA68.2
MA68.3    MA68.5    MA70.1    MA75.1    MA80.1    MAI1.1
PD10.1    PD10.2    PD130     PD20.1    PD20.2    PD20.3
PO100     PO101     PO122     PO131     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.1
PO24.1    PO25.1    PO25.5    PO25.6    PO25.7    PO27.2
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    PO32.4    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POI3.1    POID.1
POII.1    POIJ.1    RQ10.1    RQ10.2    WH20.2    WH20.7


UPDATED BY

AM04.1    AM520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APU-BOOK               Alpha 10                                  AM04.1  AM520
Element: Book          The book associated with the personal
                       use code.

                       A book is used by assets to calculate
                       depreciation, replacement cost, and
                       insurance values. Books are also used
                       for reporting. The book name is user
                       definable.



APU-PERSONAL-USE       Alpha 10                                  AM04.1  AM520
Element: Personal Use  A personal use code defines the
                       personal use options that asset books
                       use to calculate depreciation, tax
                       credits, and annual depreciation limits
                       up to twenty years. The code is
                       user-definable.


APU-DESCRIPTION        Alpha 30  (Lower Case)                    AM04.1  AM520
Element: Description   The personal use code description.

APU-QUAL-BUS-PCT       Signed 5.2                                AM04.1  AM520
Qualifying Business
Percent

APU-DEPR-RCP-OPT       Alpha 1                                   AM04.1  AM520
Depreciation           This field is a flag for the system to
Recapture Option       recapture depreciation if the business
                       use percentage drops below the
                       qualifying percentage. Valid values are:

                       Y = Yes.
                       N = No.


APU-DEPR-METH-OPT      Alpha 1                                   AM04.1  AM520
Depreciation Method    This field is a system flag for the
Option                 system to change the depreciation method
                       if the business use drops below the
                       qualifying percent. Valid values are:

                       Y = Yes.
                       N = No.


APU-DEPR-LMT-OPT       Alpha 1                                   AM04.1  AM520
Depreciation Limit     This field is a system flag to indicate
Option                 whether depreciation limits are defined
                       for the personal use code. Valid values
                       are:

                       Y = Yes.
                       N = No.


APU-OPT-DEPR-METH      Alpha 10                                  AM04.1  AM520
Optional               The optional depreciation method to be
Depreciation Method    used when the system changes from the
                       primary method.


APU-OPT-DEPR-LIFE      Numeric 4                                 AM04.1  AM520
Element: Optional Life The optional asset life, in months, to
                       be used if the depreciation method is
                       switched.


APU-TC-RECAP-OPT1      Alpha 1                                   AM04.1  AM520
Element: Recapture OptiThis field is a system flag that
                       indicates whether to use option 1 (the
                       qualifying percent field) for tax credit
                       recapture method. Valid values are:

                       N = No.
                       Y = Yes.


APU-TC-RECAP-OPT2      Alpha 1                                   AM04.1  AM520
Element: Recapture OptiThis field is a system flag that
                       indicates whether to use option 2 (the
                       optional qualifying percent) for tax
                       credit recapture method. Valid values
                       are:
                       N = No.
                       Y = Yes.


APU-TRAN-ND            Numeric 1                                 AM04.1  AM520
Transaction Number     The number of decimals assigned to a
of Decimals            particular account as determined by the
                       account currency.


APU-TC-LIMIT-OPT1      Signed 18.2                               AM04.1  AM520
Element: Limit Option 1The tax credit limit amount for the tax
                       credit recapture option 1 method.


APU-TC-LIMIT-OPT2      Signed 18.2                               AM04.1  AM520
Element: Limit Option 2The tax credit limit amount for the tax
                       credit recapture option 2 method.


APU-PST-RCVRY-DED      Alpha 1                                   AM04.1  AM520
Post Recovery          This field is a system flag that
Deduction              indicates whether to depreciate any
                       remaining book value of an asset if it
                       has not been fully depreciated over its
                       asset life. Valid values are:

                       Y = Yes. Allow post-recovery deductions.

                       N = No. Do not allow post-recovery
                       deductions.



APU-DEPR-LIMIT         Signed 18.2 Occurs 20 Times               AM04.1  AM520
Element: Depreciation Limit

                         AMPUCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APUSET1   BOOK                                                   AC160   AM04.1
          PERSONAL-USE                                           AM115   AM117
                                                                 AM12.1  AM125
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM180   AM185
                                                                 AM19.1  AM19.2
                                                                 AM190   AM192
                                                                 AM195   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM20.8  AM200
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM21.8
                                                                 AM255   AM280
                                                                 ...

                         AMPUCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ambook         AMBOOK       Required

                            APU-BOOK             -> AMB-BOOK

Ammethod       AMMETHOD     Not Required

                            APU-OPT-DEPR-METH    -> AMM-METHOD