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.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 AM93.1
AMDL.1 AM185 AM255 AM270 AM280 AM580
AM205 AM12.1 AM220 AM222 AM260 AM266
AM267 AM277 AM278 AM282 AM285 AM287
AM290 AM292 AM35.4 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 AM117 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 AM502 AM520 AM551
AM92.1 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 3 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 3 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 AM117
Depreciation This field identifies whether AM180 AM145 AM15.1
Calculation Flag (Depreciation Calculation and Listing) AM15.2 AM15.3
has been run. AM15.4 AM154
AM170 AM180
N = No AM190 AM192
Y = Yes 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 AM502
AM551 AM96.1
AM98.1
AMC-USED Alpha 1 AM115 AM117
Element: Used This field indicates whether this AM125 AM15.1
calendar is used by an asset-book AM15.2 AM15.3
combination. If the calendar is used AM15.4 AM20.1
(Yes), you cannot make changes to the AM20.2 AM20.4
calendar. If the calendar is not yet AM21.1 AM21.2
attached to an asset-book combination AM21.4 AM500
(No), you can change the calendar. AM502 AM551
AM92.1 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
AM117 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
...
AMCSET2 BOOK AM01.1 AM01.2
COMPANY AM01.3 AM115
YR-END-DATE* AM117 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
...
AMCSET3 CAL-STATUS AM01.1 AM01.2
BOOK AM01.3 AM115
COMPANY AM117 AM125
YR-END-DATE AM145 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
...
AMCSET4 COMPANY Subset AM01.1 AM01.2
BOOK Where CAL-STATUS = "C" AM01.3 AM115
AM117 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
...
AMCSET5 BOOK Subset AM01.1 AM01.2
COMPANY Where CAL-STATUS = "C" AM01.3 AM115
AM117 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
...
AMCSET6 COMPANY Subset AM115 AM117
BOOK Where CAL-STATUS = "C" AM12.1 AM135
And REQ-BOOK = "Y" AM15.1 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 AM35.4
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
|