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

AM115     AM117     AM12.1    AM125     AM145     AM15.1
AM15.2    AM15.3    AM15.4    AM154     AM180     AM185
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

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    This field contains the qualifying
Percent                business use percent value. The
                       qualifying business use percent refers
                       to the percentage of business use an
                       asset needs to maintain. If the
                       percentage drops below this limit,
                       recapture, life, and method changes may
                       go into effect.


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 decimal positions defined
of Decimals            for the transaction 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 LThis field contains the maximum
                       allowable limit for depreciation for a
                       recovery year. If the amount is zero, no
                       limit is defined for the year.


                         AMPUCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APUSET1   BOOK                                                   AM04.1  AM115
          PERSONAL-USE                                           AM117   AM12.1
                                                                 AM125   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM180
                                                                 AM185   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
                                                                 ...

                         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