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     AM117     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   AM117
Element: Company       Identifies the AP company if the          AM15.1  AM15.2
                       resource type = V.  Identifies the HR     AM15.3  AM15.4
                       company if the resource type = E.  It is  AM170   AM180
                       blank for type A, P or Q resources.       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   AM117
Element: Book          A user-defined book name. Books are       AM15.1  AM15.2
                       used by assets for calculating            AM15.3  AM15.4
                       depreciation, replacement cost, and       AM170   AM180
                       insurance values, and for reporting.      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-ASSET-TYPE         Alpha 10                                  AM115   AM117
Element: Asset Type    An asset type represents a grouping of    AM15.1  AM15.2
                       like assets. Asset types are used to      AM15.3  AM15.4
                       group assets into reporting classes and   AM170   AM180
                       to default common asset definition data.  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-SUB-TYPE           Alpha 10                                  AM115   AM117
Element: Sub Type      An asset subtype represents a more        AM15.1  AM15.2
                       detailed grouping of assets within an     AM15.3  AM15.4
                       asset type grouping. Asset subtypes are   AM170   AM180
                       used to group assets into reporting       AM20.1  AM20.2
                       classes and allow common asset            AM20.3  AM20.4
                       definition data to default. Subtypes      AM20.5  AM20.6
                       must be unique within an asset type.      AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

CLD-AST-ACCT-UNIT      Alpha 15                                  AM115   AM117
Element: Accounting Unit                                         AM15.1  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   AM117
Element: Accounting UniThe general ledger distribution           AM15.1  AM15.2
                       accounting unit.                          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   AM117
Element: Accounting Unit                                         AM15.1  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   AM117
Element: Yr End Date                                             AM15.1  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   AM117
Element: Last Closed PeThis is the current accounting period.    AM15.1  AM15.2
                       This field is updated by Period Closing   AM15.3  AM15.4
                       (GL199).                                  AM170   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 18.2                               AM115   AM117
Element: Intl Amt                                                AM15.1  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-YTD           Signed 18.2                               AM115   AM117
Element: Intl Amt                                                AM15.1  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 18.2                               AM115   AM117
Element: Intl Amt                                                AM15.1  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   AM117
Element: Status Cp CalcThis field indicates whether              AM15.1  AM15.2
                       depreciation has been calculated for the  AM15.3  AM15.4
                       current period.                           AM170   AM180
                       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 18.5                               AM180
Element: Intl Cost

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   AM117
Element: Creation Date This is the date that this line was       AM15.1  AM15.2
                       added to the requisition.                 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   AM117
Element: Creation Time The creation time.                        AM15.1  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   AM117
Element: Operator Code                                           AM15.1  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

                         AMCLASSDEP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CLDSET1   COMPANY                                                AM115   AM117
          BOOK                                                   AM15.1  AM15.2
          ASSET-TYPE                                             AM15.3  AM15.4
          SUB-TYPE                                               AM170   AM180
          AST-ACCT-UNIT                                          AM20.1  AM20.2
          EXP-ACCT-UNIT                                          AM20.3  AM20.4
          ACM-ACCT-UNIT                                          AM20.5  AM20.6
          YR-END-DATE                                            AM21.1  AM21.2
          PERIOD                                                 AM21.3  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