Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMPUHIS


                              AMPUHIS FILE

                          Personal Use History

The Personal Use History file stores depreciation records for assets that
have a personal use code assigned. AM190 (Period Close) updates this file.


REFERENCED BY

AM01.1    AM01.2    AM01.3    AM145     AM154     AM185
AM255     AM280     AM295     AM40.1    AM40.2

UPDATED BY

AC160     AM115     AM117     AM125     AM15.1    AM15.2
AM15.3    AM15.4    AM180     AM19.1    AM19.2    AM190
AM192     AM20.1    AM20.2    AM20.4    AM20.3    AM20.5
AM20.6    AM21.1    AM21.2    AM21.4    AM21.3    AM21.5
AM21.6    AM310     AM500     AM502     AM520     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    AM170     AM330     AM96.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PUH-ASSET              Numeric 10                                AC160   AM115
Element: Asset         The asset number contains up to ten       AM117   AM125
                       numeric characters that uniquely          AM15.1  AM15.2
                       identify an asset. Assets are             AM15.3  AM15.4
                       automatically numbered system-wide.       AM180   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  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
                                                                 ...

PUH-BOOK               Alpha 10                                  AC160   AM115
Element: Book          The book associated with the asset.       AM117   AM125
                       Used to calculate depreciation for the    AM15.1  AM15.2
                       asset.                                    AM15.3  AM15.4
                                                                 AM180   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM500
                                                                 AM502   AM520
                                                                 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
                                                                 ...

PUH-YR-END-DATE        Numeric 8  (yyyymmdd)                     AC160   AM115
Element: Year-End Date The year ending date for the current      AM117   AM125
                       fiscal year.                              AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM180   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  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
                                                                 ...

PUH-PERSONAL-USE       Alpha 10                                  AC160   AM115
Element: Personal Use  The personal use code assigned to the     AM117   AM125
                       asset. Used by the book to calculate      AM15.1  AM15.2
                       depreciation for the asset.               AM15.3  AM15.4
                                                                 AM180   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  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
                                                                 ...

PUH-BUS-PERCENT        Signed 5.2                                AC160   AM115
Element: Business PerceThe business usage percent of the         AM117   AM125
                       asset. If this field is less than 100     AM15.1  AM15.2
                       percent, this value is used when you      AM15.3  AM15.4
                       calculate depreciation for the asset.     AM180   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  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
                                                                 ...

PUH-DEPR-ALLOW-YR      Signed 18.2                               AC160   AM115
Current Year Depr                                                AM117   AM125
Allowed                                                          AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM180   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  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
                                                                 ...

PUH-DEPR-LIMIT         Signed 18.2                               AC160   AM115
Element: Depreciation LThis field contains the maximum           AM117   AM125
                       allowable limit for depreciation for a    AM15.1  AM15.2
                       recovery year. If the amount is zero, no  AM15.3  AM15.4
                       limit is defined for the year.            AM180   AM19.1
                                                                 AM19.2  AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM21.1  AM21.2
                                                                 AM21.4  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
                                                                 ...

                         AMPUHIS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PUHSET1   ASSET                                                  AC160   AM01.1
          BOOK                                                   AM01.2  AM01.3
          YR-END-DATE                                            AM115   AM117
                                                                 AM125   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM185
                                                                 AM19.1  AM19.2
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM20.8  AM21.1
                                                                 AM21.2  AM21.3
                                                                 ...