Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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     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     AM551
AM580     AM98.1

UPDATED BY

AM04.1    AM520

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

APU-BOOK             Alpha 10                                    AM04.1  AM520
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
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
Description          The personal use code description.

APU-QUAL-BUS-PCT     Signed 5.2                                  AM04.1
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
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
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
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
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
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
Recapture Option 1   This 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
Recapture Option 2   This 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
Transaction Number   The number of decimal positions defined
of Decimals          for the transaction currency.

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


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


APU-PST-RCVRY-DED    Alpha 1                                     AM04.1
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 15.2 Occurs 20 Times                 AM04.1
Depreciation Limit   This 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                                           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
                                                                 ...

                         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