Lawson Insight Technical Documentation |
|
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
|