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