Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMCALENDAR


                            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     AM200     AM241     AM275
AM281     AM295     AM320     AM41.1    AM41.2    AM80.2
AM80.1    AM88.2    AM90.2    AM90.5    AM90.1    AM90.4
AM90.6    AM91.2    AM91.5    AM91.1    AM91.4    AM93.1
AMDL.1    AM185     AM255     AM270     AM280     AM580
AM205     AM12.1    AM220     AM222     AM260     AM266
AM267     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     AM501     AM60.1

UPDATED BY

AM01.1    AM01.2    AM01.3    AM115     AM125     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    AM30.1    AM40.1
AM40.2    AM500     AM520     AM551     AM96.1    AM98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AMC-BOOK               Alpha 10                                  AM01.1  AM01.2
Element: 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
Element: Company       The general ledger company number         AM01.3  AM170
                       associated with the calendar.


AMC-CAL-STATUS         Alpha 1                                   AM01.1  AM01.2
Element: Calendar StatuThis 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
Element: 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
Element: Year-Begin DatThe first date of the fiscal year.        AM01.3  AM192
                                                                 AM195   AM295

AMC-REQ-BOOK           Alpha 1                                   AM01.1  AM01.2
Element: 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
Element: 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
Element: Periods Per YeThis 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
Element: 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
Element: Period End-DatEach 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  AM190
Close                  depreciation periods that are closed in   AM192   AM195
                       the fiscal year.


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

                       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   AM145
Depreciation           This field identifies whether AM180       AM15.1  AM15.2
Calculation Flag       (Depreciation Calculation and Listing)    AM15.3  AM15.4
                       has been run.                             AM154   AM170
                                                                 AM180   AM190
                       N = No                                    AM192   AM195
                       Y = Yes                                   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
                                                                 AM40.2  AM500
                                                                 AM551   AM96.1
                                                                 AM98.1

AMC-USED               Alpha 1                                   AM115   AM125
Element: 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
Element: Period Close DThis field identifies the closing date
                       of the last closed period.


AMC-CURRENT-PERIOD     Derived
Element: Current PeriodThis field identifies the current
                       period.


AMC-PD-CURR-DATE       Derived
Element: Period CurrentThis field identifies the ending date
                       of the current period.


AMC-BK-DESCRIPTION     Derived
Element: Book DescriptiThe book description.

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

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

                       Valid values are

                       A = Active
                       I = Inactive

AMC-BK-DEPR-TYPE       Derived
Element: Bk Depr Type

AMC-BK-CONV            Derived
Element: Book ConventioThis 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
Element: Method Switch This field identifies whether the
                       depreciation method can be switched when
                       it is advantageous to do so.


AMC-BK-HISTORY         Derived
Element: Bk History

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

AMC-CO-CURR-CODE       Derived
Element: 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  AM115
          YR-END-DATE*                                           AM125   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM180
                                                                 AM185   AM192
                                                                 AM195   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM20.8  AM21.1
                                                                 AM21.2  AM21.4
                                                                 AM21.8  AM255
                                                                 AM270   AM280
                                                                 AM281   AM295
                                                                 AM40.1  AM40.2
                                                                 ...

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
                                                                 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