Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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
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
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
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
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
Ast Acct 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
Expense Accounting   The general ledger distribution             AM15.2  AM15.3
Unit                 accounting unit.                            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
Acm Acct 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
Yr End 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
Last Closed Period   This 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
Depr Cp                                                          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 15.2                                 AM115   AM15.1
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
Depr Ltd                                                         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
Status Cp Calc       This field indicates whether                AM15.2  AM15.3
                     depreciation has been calculated for the    AM15.4  AM170
                     current period.                             AM180   AM20.1
                     N = No                                      AM20.2  AM20.3
                     Y = Yes                                     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-DATE    Numeric 8  (yyyymmdd)                       AM115   AM15.1
Creation Date        This is the date that this line was         AM15.2  AM15.3
                     added to the requisition.                   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
Creation Time        The creation 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
Creator Id                                                       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   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