Lawson Insight Technical Documentation


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    AM180     AM185     AM190     AM192
AM195     AM20.1    AM20.2    AM20.4    AM20.8    AM200
AM255     AM280     AM295     AM40.1    AM40.2    AM500
AM580     AM98.1

UPDATED BY

AM04.1    AM520     AM954

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  AM954
Description          The personal use code description.

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


APU-TC-LIMIT-OPT1    Signed 15.2                                 AM04.1  AM954
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  AM954
Limit Option 2       The tax credit limit amount for the tax
                     credit recapture option 2 method.


APU-PST-RCVRY-DED    Alpha 1                                     AM04.1  AM954
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  AM954
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  AM180
                                                                 AM185   AM190
                                                                 AM192   AM195
                                                                 AM20.1  AM20.2
                                                                 AM20.4  AM20.8
                                                                 AM200   AM255
                                                                 AM280   AM295
                                                                 AM40.1  AM40.2
                                                                 AM500   AM520
                                                                 AM580   AM98.1

                         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