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 AM125 AM200 AM310 AM145
AM185 AM205 AM255 AM280 AM295 AM580
AM135 AM220 AM222 AM260 AM270 AM285
AM70.1 AM75.1 AM80.1 AM85.1 AM90.1 AM95.1
AM99.1 AM12.1 AM120 AM230 AM240 AM265
AM290 AM292 AM60.1
UPDATED BY
AM01.1 AM01.2 AM01.3 AM115 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 AM30.1 AM40.1 AM500 AM520 AM953
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. AM953
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 AM953
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 AM953
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 AM953
AMC-REQ-BOOK Alpha 1 AM01.1 AM01.2
Required Book This field indicates whether the book AM01.3 AM953
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 AM953
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 AM953
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 AM953
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 AM953
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 AM953
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 AM953
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. AM953
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 AM953
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 AM953
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
AM30.1 AM40.1
AM500 AM96.1
AM98.1
AMC-USED Alpha 1 AM115 AM15.1
Used This field indicates whether this AM15.2 AM15.3
calendar is used by an asset-book AM15.4 AM20.1
combination. If the calendar is used AM20.2 AM20.4
(Yes), you cannot make changes to the AM500 AM98.1
calendar. If the calendar is not yet
attached to an asset-book combination
(No), you can change the calendar.
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 End This field identifies the current
Date 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-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-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 AM15.1
AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM20.5 AM200
AM30.3 AM310
AM500 AM520
AM98.1
AMCSET2 BOOK AM01.1 AM01.2
COMPANY AM01.3 AM195
YR-END-DATE*
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
AM180 AM185
AM192 AM195
AM20.1 AM20.2
AM20.4 AM20.8
AM200 AM205
AM255 AM280
AM295 AM40.1
AM40.2 AM500
AM580 AM98.1
AMCSET4 COMPANY Subset AM01.1 AM01.2
BOOK Where CAL-STATUS = "C" AM01.3 AM115
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM180 AM192
AM195 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM220
AM222 AM260
AM270 AM285
AM30.1 AM30.2
AM30.3 AM40.1
...
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
AM170 AM180
AM185 AM190
AM192 AM195
AM20.1 AM20.2
AM20.4 AM20.7
AM20.8 AM200
AM220 AM230
AM240 AM255
AM260 AM265
...
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 AM30.1
AM500 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
|