Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMCLASSDEP


                            AMCLASSDEP FILE

This file contains the depreciation information for account level depreciation
to support Telecommunications Industry requirements for class level
depreciation.

REFERENCED BY

AM90.6    AM90.7    AM282

UPDATED BY

AM115     AM15.1    AM15.2    AM15.3    AM15.4    AM170
AM180     AM190     AM20.1    AM20.2    AM20.3    AM20.4
AM20.5    AM20.6    AM21.1    AM21.2    AM21.3    AM21.4
AM21.5    AM21.6    AM500     AM551     AM96.1    AM98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CLD-COMPANY            Numeric 4                                 AM115   AM15.1
Element: Company       The company number represents an          AM15.2  AM15.3
                       established company and is entered on     AM15.4  AM170
                       all function codes.                       AM180   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-BOOK               Alpha 10                                  AM115   AM15.1
Element: Book          A user-defined book name. Books are       AM15.2  AM15.3
                       used by assets for calculating            AM15.4  AM170
                       depreciation, replacement cost, and       AM180   AM20.1
                       insurance values, and for reporting.      AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-ASSET-TYPE         Alpha 10                                  AM115   AM15.1
Element: Asset Type    An asset type represents a grouping of    AM15.2  AM15.3
                       like assets. Asset types are used to      AM15.4  AM170
                       group assets into reporting classes and   AM180   AM20.1
                       to default common asset definition data.  AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-SUB-TYPE           Alpha 10                                  AM115   AM15.1
Element: Sub Type      An asset subtype represents a more        AM15.2  AM15.3
                       detailed grouping of assets within an     AM15.4  AM170
                       asset type grouping. Asset subtypes are   AM180   AM20.1
                       used to group assets into reporting       AM20.2  AM20.3
                       classes and allow common asset            AM20.4  AM20.5
                       definition data to default. Subtypes      AM20.6  AM21.1
                       must be unique within an asset type.      AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-AST-ACCT-UNIT      Alpha 15                                  AM115   AM15.1
Element: Accounting Unit                                         AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM180   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-EXP-ACCT-UNIT      Alpha 15                                  AM115   AM15.1
Element: Accounting Unit                                         AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM180   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-ACM-ACCT-UNIT      Alpha 15                                  AM115   AM15.1
Element: Accounting Unit                                         AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM180   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-YR-END-DATE        Numeric 8  (yyyymmdd)                     AM115   AM15.1
Element: Date                                                    AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM180   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-PERIOD             Numeric 2                                 AM115   AM15.1
Element: Current PeriodThis is the current accounting period.    AM15.2  AM15.3
                       This field is updated by Period Closing   AM15.4  AM170
                       (GL199).                                  AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

CLD-DEPR-CP            Signed 15.2                               AM115   AM15.1
Element: Depr Ytd                                                AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM180   AM190
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

CLD-DEPR-YTD           Signed 15.2                               AM115   AM15.1
Element: Depr Ytd                                                AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM180   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-DEPR-LTD           Signed 15.2                               AM115   AM15.1
Element: Depr Ytd                                                AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM180   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-STATUS-CP-CALC     Alpha 1                                   AM115   AM15.1
Element: Purge Status  This field indicates whether              AM15.2  AM15.3
                       depreciation has been calculated for the  AM15.4  AM170
                       current period.                           AM180   AM190
                       N = No                                    AM20.1  AM20.2
                       Y = Yes                                   AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

CLD-RW-COMPUTE-AMT     Signed 13.5                               AM180
Element: Rw Compute Amt

CLD-DEPR-RATE          Percent 6.3  (Percent)
Element: Depr Rate     This field contains the depreciation
                       rate that was used as a multiplier to
                       the RW-Compute-Amt (Annual Depreciation
                       Rate divided by Periods Per Year).

CLD-CREATION-DATE      Numeric 8  (yyyymmdd)                     AM115   AM15.1
Element: Date                                                    AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM180   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-CREATION-TIME      Numeric 6  (hhmmss)                       AM115   AM15.1
Element: Sys Time                                                AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM180   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

CLD-CREATOR-ID         Alpha 10                                  AM115   AM15.1
Authorization                                                    AM15.2  AM15.3
Identification                                                   AM15.4  AM170
                                                                 AM180   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

                         AMCLASSDEP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CLDSET1   COMPANY                                                AM115   AM15.1
          BOOK                                                   AM15.2  AM15.3
          ASSET-TYPE                                             AM15.4  AM170
          SUB-TYPE                                               AM180   AM20.1
          AST-ACCT-UNIT                                          AM20.2  AM20.3
          EXP-ACCT-UNIT                                          AM20.4  AM20.5
          ACM-ACCT-UNIT                                          AM20.6  AM21.1
          YR-END-DATE                                            AM21.2  AM21.3
          PERIOD                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM90.6
                                                                 AM90.7  AM96.1
                                                                 AM98.1

CLDSET2   COMPANY                                                AM90.6  AM90.7
          BOOK
          ASSET-TYPE
          SUB-TYPE
          EXP-ACCT-UNIT
          AST-ACCT-UNIT
          ACM-ACCT-UNIT
          YR-END-DATE
          PERIOD

CLDSET3   COMPANY                                                AM90.6  AM90.7
          BOOK
          ASSET-TYPE
          SUB-TYPE
          ACM-ACCT-UNIT
          AST-ACCT-UNIT
          EXP-ACCT-UNIT
          YR-END-DATE
          PERIOD

CLDSET4   COMPANY                                                AM180   AM190
          BOOK                                                   AM282
          YR-END-DATE
          PERIOD
          ASSET-TYPE
          SUB-TYPE
          AST-ACCT-UNIT
          EXP-ACCT-UNIT
          ACM-ACCT-UNIT

CLDSET5   BOOK
          ASSET-TYPE
          SUB-TYPE
          COMPANY
          AST-ACCT-UNIT
          EXP-ACCT-UNIT
          ACM-ACCT-UNIT
          YR-END-DATE
          PERIOD

CLDSET6   ASSET-TYPE
          SUB-TYPE
          BOOK
          COMPANY
          AST-ACCT-UNIT
          EXP-ACCT-UNIT
          ACM-ACCT-UNIT
          YR-END-DATE
          PERIOD