Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            AMCALENDAR FILE

                                Calendar

The Calendar file stores calendar records that asset books use for
calculating depreciation, replacement cost, and insurance values, and for
reporting date ranges. Calendars define a processing schedule and posting
dates for a year, and are defined by book, book type, company, and year end
date.


REFERENCED BY

AM00.1    AM00.2    AM135     AM145     AM154     AM200
AM241     AM275     AM281     AM295     AM310     AM320
AM41.2    AM41.1    AM80.2    AM80.1    AM88.2    AM90.2
AM90.5    AM90.1    AM90.4    AM90.6    AM91.2    AM91.5
AM91.1    AM91.4    AMDL.1    AM185     AM205     AM255
AM280     AM580     AM12.1    AM220     AM222     AM260
AM266     AM267     AM270     AM277     AM278     AM282
AM285     AM287     AM290     AM292     AM70.1    AM75.1
AM75.2    AM85.1    AM85.2    AM95.1    AM95.4    AM95.5
AM95.6    AM120     AM230     AM240     AM265     AM60.1

UPDATED BY

AM01.1    AM01.2    AM01.3    AM115     AM125     AM15.1
AM15.2    AM15.3    AM15.4    AM170     AM180     AM190
AM192     AM195     AM20.1    AM20.2    AM20.3    AM20.4
AM20.5    AM20.6    AM21.1    AM21.2    AM21.3    AM21.4
AM21.5    AM21.6    AM30.1    AM40.1    AM500     AM520
AM551     AM96.1    AM98.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AMC-BOOK             Alpha 10                                    AM01.1  AM01.2
Book                 The book name associated with the           AM01.3  AM170
                     calendar. Books are used by assets for      AM520
                     calculating depreciation, replacement
                     cost, and insurance values, and for
                     reporting.


AMC-COMPANY          Numeric 4                                   AM01.1  AM01.2
Company              The general ledger company number           AM01.3  AM170
                     associated with the calendar.


AMC-CAL-STATUS       Alpha 1                                     AM01.1  AM01.2
Calendar Status      This field identifies the status of the     AM01.3  AM192
                     calendar, which indicates whether the       AM195
                     calendar is defined for the current
                     year, a future year, or a past
                     (historic) year. All calendars are
                     defined for the current year in this
                     release.

                     C = Current
                     F = Future
                     H = Historic

AMC-YR-END-DATE      Numeric 8  (yyyymmdd)                       AM01.1  AM01.2
Year-End Date        The last date of the fiscal year. This      AM01.3  AM190
                     date must match the last period end date    AM192   AM195
                     defined for the processing schedule.        AM295


AMC-YR-BEG-DATE      Numeric 8  (yyyymmdd)                       AM01.1  AM01.2
Year-Begin Date      The first date of the fiscal year.          AM01.3  AM192
                                                                 AM195   AM295

AMC-REQ-BOOK         Alpha 1                                     AM01.1  AM01.2
Required Book        This field indicates whether the book       AM01.3
                     is a required book to be used by all new
                     assets being added.

                     Y = Yes
                     N = No

AMC-POSTING-BOOK     Alpha 1                                     AM01.1  AM01.2
Posting Book         This field indicates whether the book       AM01.3
                     is a posting book that posts journal
                     entries to the general ledger.

                     Y = Yes
                     N = No

AMC-PD-PER-YR        Numeric 2                                   AM01.1  AM01.2
Periods Per Year     This field identifies the number of         AM01.3  AM192
                     depreciation periods for the book for
                     the current fiscal year.


AMC-SHORT-YEAR       Alpha 1                                     AM01.1  AM01.2
Short Year           This field identifies whether the           AM01.3  AM192
                     calendar contains a year that is shorter
                     than a normal year.

                     N = No
                     Y = Yes

AMC-NBR-DEPR-PD      Numeric 2 Occurs 55 Times                   AM01.1  AM01.2
Depreciation Period  Each occurrence of this field               AM01.3  AM192
Number               identifies the number assigned to a
                     depreciation period.


AMC-PD-END-DATE      Numeric 8  (yyyymmdd) Occurs 55 Times       AM01.1  AM01.2
Period End-Date      Each occurrence of this field               AM01.3  AM192
                     identifies the ending date for a            AM195
                     depreciation period. Once a calendar is
                     defined, the ending dates cannot be
                     changed.


AMC-DEPR-PD-CLS      Numeric 2                                   AM01.1  AM01.2
Depreciation Period  This field identifies the number of         AM01.3  AM120
Close                depreciation periods that are closed in     AM190   AM192
                     the fiscal year.                            AM195


AMC-DEPR-RUN-CLS     Numeric 2                                   AM01.1  AM01.2
Depreciation Run     This field identifies the number of         AM01.3  AM190
Close                times that AM190 (Period Close) has been    AM192   AM195
                     run for the book.

                     Note: It is possible to close more than
                     one period in one AM190 run.



AMC-NBR-PD-INPROC    Numeric 2                                   AM180   AM190
Number Periods In    This field identifies the number of         AM192
Process              periods currently in process after AM180
                     (Depreciation Calculation and Listing)
                     has run. AM190 (Period Close) resets
                     this field.


AMC-PD-END-INPROC    Numeric 8  (yyyymmdd)                       AM180   AM190
In-Process Period    This field identifies the ending date       AM192
End Date             of the fiscal period in process.


AMC-DEPR-CALC-FL     Alpha 1                                     AM115   AM15.1
Depreciation         This field identifies whether AM180         AM15.2  AM15.3
Calculation Flag     (Depreciation Calculation and Listing)      AM15.4  AM170
                     has been run.                               AM180   AM190
                                                                 AM192   AM195
                     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
                                                                 AM30.1  AM40.1
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

AMC-USED             Alpha 1                                     AM115   AM125
Used                 This field indicates whether this           AM15.1  AM15.2
                     calendar is used by an asset-book           AM15.3  AM15.4
                     combination. If the calendar is used        AM20.1  AM20.2
                     (Yes), you cannot make changes to the       AM20.4  AM21.1
                     calendar. If the calendar is not yet        AM21.2  AM21.4
                     attached to an asset-book combination       AM500   AM551
                     (No), you can change the calendar.          AM98.1

                     Y = Yes
                     N = No

AMC-ORG-YE-DATE      Numeric 8  (yyyymmdd)                       AM01.1  AM01.2
Original Year-End    This is the original year-end date, the     AM01.3  AM192
Date                 year-end date before the year was
                     defined as a short year. This is used
                     only when defining historical calendars.


AMC-PD-CLOSE-DATE    Derived
Period Close Date    This field identifies the closing date
                     of the last closed period.


AMC-CURRENT-PERIOD   Derived
Current Period       This field identifies the current
                     period.


AMC-PD-CURR-DATE     Derived
Period Current Date  This field identifies the ending date
                     of the current period.


AMC-BK-DESCRIPTION   Derived
Book Description     The book description.

AMC-BK-CURR-CODE     Derived
Currency Code        The currency code assigned to the book.

AMC-BK-STATUS        Derived
Status               The status of the book.

                     Valid values are

                     A = Active
                     I = Inactive

AMC-BK-DEPR-TYPE     Derived
Bk Depr Type

AMC-BK-CONV          Derived
Book Convention      This is the convention defined for the
                     book. The convention is used to
                     determine the first and last year's
                     depreciation amounts to take.


AMC-BK-METH-SWITCH   Derived
Method Switch        This field identifies whether the
                     depreciation method can be switched when
                     it is advantageous to do so.


AMC-BK-HISTORY       Derived
Bk History

AMC-CO-NAME          Derived
Company Name         The name of the general ledger company.

AMC-CO-CURR-CODE     Derived
Currency Code        The base currency defined for the
                     company.


                         AMCALENDAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AMCSET1   BOOK                                                   AM00.1  AM00.2
          COMPANY                                                AM01.1  AM01.2
          YR-END-DATE                                            AM01.3  AM115
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.4  AM20.5
                                                                 AM200   AM21.1
                                                                 AM21.2  AM21.4
                                                                 AM21.5  AM241
                                                                 AM275   AM281
                                                                 AM295   AM30.1
                                                                 ...

AMCSET2   BOOK                                                   AM01.1  AM01.2
          COMPANY                                                AM01.3  AM195
          YR-END-DATE*                                           AM281   AMDL.1

AMCSET3   CAL-STATUS                                             AM01.1  AM01.2
          BOOK                                                   AM01.3  AM115
          COMPANY                                                AM125   AM145
          YR-END-DATE                                            AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM180
                                                                 AM185   AM192
                                                                 AM195   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM20.8  AM200
                                                                 AM205   AM21.1
                                                                 AM21.2  AM21.4
                                                                 AM21.8  AM255
                                                                 AM280   AM295
                                                                 AM40.1  AM40.2
                                                                 ...

AMCSET4   COMPANY       Subset                                   AM01.1  AM01.2
          BOOK          Where CAL-STATUS = "C"                   AM01.3  AM115
                                                                 AM12.1  AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM195
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 ...

AMCSET5   BOOK          Subset                                   AM01.1  AM01.2
          COMPANY       Where CAL-STATUS = "C"                   AM01.3  AM115
                                                                 AM12.1  AM120
                                                                 AM125   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM185
                                                                 AM190   AM192
                                                                 AM195   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM20.7  AM20.8
                                                                 AM200   AM21.1
                                                                 AM21.2  AM21.4
                                                                 AM21.7  AM21.8
                                                                 ...

AMCSET6   COMPANY       Subset                                   AM115   AM12.1
          BOOK          Where CAL-STATUS = "C"                   AM135   AM15.1
                        And   REQ-BOOK   = "Y"                   AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1

                         AMCALENDAR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ambook         AMBOOK       Required

                            AMC-BOOK       -> AMB-BOOK

Amcontrol      AMCONTROL    Not Required

                            AMC-COMPANY    -> CTL-COMPANY

Glsystem       GLSYSTEM     Required

                            AMC-COMPANY    -> GLS-COMPANY