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 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
AC160 AM01.1 AM01.2 AM01.3 AM115 AM117
AM125 AM145 AM15.1 AM15.2 AM15.3 AM15.4
AM154 AM170 AM180 AM19.1 AM19.2 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 AM580 AM92.1 AM96.1
AM98.1 AP115 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP220 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP305 API1.1 API2.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 POI3.1 POID.1 POII.1
POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7
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 AM195
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 AC160 AM115
Depreciation This field identifies whether AM180 AM117 AM145
Calculation Flag (Depreciation Calculation and Listing) AM15.1 AM15.2
has been run. AM15.3 AM15.4
AM154 AM170
N = No AM180 AM19.1
Y = Yes AM19.2 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 AM551
AM580 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
...
AMC-USED Alpha 1 AC160 AM115
Element: Used This field indicates whether this AM117 AM125
calendar is used by an asset-book AM15.1 AM15.2
combination. If the calendar is used AM15.3 AM15.4
(Yes), you cannot make changes to the AM19.1 AM19.2
calendar. If the calendar is not yet AM20.1 AM20.2
attached to an asset-book combination AM20.4 AM21.1
(No), you can change the calendar. AM21.2 AM21.4
AM500 AM502
Y = Yes AM551 AM92.1
N = No AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
...
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 AC160 AM00.1
COMPANY AM00.2 AM01.1
YR-END-DATE AM01.2 AM01.3
AM115 AM117
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM200
AM21.1 AM21.2
AM21.4 AM21.5
...
AMCSET2 BOOK AC160 AM01.1
COMPANY AM01.2 AM01.3
YR-END-DATE* AM115 AM117
AM125 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM180
AM185 AM19.1
AM19.2 AM192
AM195 AM20.1
AM20.2 AM20.4
AM20.8 AM21.1
AM21.2 AM21.4
AM21.8 AM255
AM270 AM280
...
AMCSET3 CAL-STATUS AC160 AM01.1
BOOK AM01.2 AM01.3
COMPANY AM115 AM117
YR-END-DATE AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.8 AM200
...
AMCSET4 COMPANY Subset AC160 AM01.1
BOOK Where CAL-STATUS = "C" AM01.2 AM01.3
AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM180 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
...
AMCSET5 BOOK Subset AC160 AM01.1
COMPANY Where CAL-STATUS = "C" AM01.2 AM01.3
AM115 AM117
AM12.1 AM120
AM125 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM180 AM185
AM19.1 AM19.2
AM190 AM192
AM195 AM20.1
AM20.2 AM20.4
AM20.7 AM20.8
AM200 AM21.1
...
AMCSET6 COMPANY Subset AC160 AM115
BOOK Where CAL-STATUS = "C" AM117 AM12.1
And REQ-BOOK = "Y" AM135 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM19.1 AM19.2
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
|