AMCALENDAR – Asset Calendar

System
Asset Management (AM)
Prefix
AMC
Primary key
BOOK, COMPANY, YR-END-DATE
Fields
30
Updated by
278 programs
Referenced by
61 programs

AMCALENDAR is the Asset Calendar table in Lawson Asset Management (prefix AMC). It is indexed by BOOK, COMPANY, YR-END-DATE (AMCSET1); alternate indexes: AMCSET2, AMCSET3, AMCSET4, AMCSET5 and AMCSET6. It is related 1:1 to AMBOOK, AMCONTROL and GLSYSTEM. It is updated by AC160, AM01.1, AM01.2, AM01.3, AM115, AM117, AM125, AM145 and 270 more and referenced by AM00.1, AM00.2, AM12.1, AM12.2, AM120, AM135, AM155, AM185 and 53 more. The table has 30 fields, 6 indexes and 3 documented relations.

About AMCALENDAR

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.

Fields (30)

Column = COBOL field name without the AMC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AMC-BOOK PK
BOOK		Alpha 10The book name associated with the calendar. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.AM01.1, AM01.2, AM01.3, AM170, AM520
AMC-COMPANY PK
COMPANY		Numeric 4The general ledger company number associated with the calendar.AM01.1, AM01.2, AM01.3, AM170
AMC-CAL-STATUS
CAL_STATUS		Alpha 1This field identifies the status of the calendar, which indicates whether the 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
AM01.1, AM01.2, AM01.3, AM192, AM195
AMC-YR-END-DATE PK
YR_END_DATE		Numeric 8 (yyyymmdd)The last date of the fiscal year. This date must match the last period end date defined for the processing schedule.AM01.1, AM01.2, AM01.3, AM190, AM192, AM195, AM295
AMC-YR-BEG-DATE
YR_BEG_DATE		Numeric 8 (yyyymmdd)The first date of the fiscal year.AM01.1, AM01.2, AM01.3, AM192, AM195, AM295
AMC-REQ-BOOK
REQ_BOOK		Alpha 1This field indicates whether the book is a required book to be used by all new assets being added.
  • Y Yes
  • N No
AM01.1, AM01.2, AM01.3
AMC-POSTING-BOOK
POSTING_BOOK		Alpha 1This field indicates whether the book is a posting book that posts journal entries to the general ledger.
  • Y Yes
  • N No
AM01.1, AM01.2, AM01.3, AM195
AMC-PD-PER-YR
PD_PER_YR		Numeric 3This field identifies the number of depreciation periods for the book for the current fiscal year.AM01.1, AM01.2, AM01.3, AM192
AMC-SHORT-YEAR
SHORT_YEAR		Alpha 1This field identifies whether the calendar contains a year that is shorter than a normal year.
  • N No
  • Y Yes
AM01.1, AM01.2, AM01.3, AM192
AMC-NBR-DEPR-PD
NBR_DEPR_PD		Numeric 2 Occurs 55 Times ×55Each occurrence of this field identifies the number assigned to a depreciation period.AM01.1, AM01.2, AM01.3, AM192
AMC-PD-END-DATE
PD_END_DATE		Numeric 8 (yyyymmdd) Occurs 55 Times ×55Each occurrence of this field identifies the ending date for a depreciation period. Once a calendar is defined, the ending dates cannot be changed.AM01.1, AM01.2, AM01.3, AM192, AM195
AMC-DEPR-PD-CLS
DEPR_PD_CLS		Numeric 3This field identifies the number of depreciation periods that are closed in the fiscal year.AM01.1, AM01.2, AM01.3, AM190, AM192, AM195
AMC-DEPR-RUN-CLS
DEPR_RUN_CLS		Numeric 2This field identifies the number of times that AM190 (Period Close) has been run for the book. Note: It is possible to close more than one period in one AM190 run.AM01.1, AM01.2, AM01.3, AM120, AM190, AM192, AM195
AMC-NBR-PD-INPROC
NBR_PD_INPROC		Numeric 2This field identifies the number of periods currently in process after AM180 (Depreciation Calculation and Listing) has run. AM190 (Period Close) resets this field.AM180, AM190, AM192
AMC-PD-END-INPROC
PD_END_INPROC		Numeric 8 (yyyymmdd)This field identifies the ending date of the fiscal period in process.AM180, AM190, AM192
AMC-DEPR-CALC-FL
DEPR_CALC_FL		Alpha 1This field identifies whether AM180 (Depreciation Calculation and Listing) has been run.
  • N No
  • Y Yes
AC160, AM115, AM117, AM145, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AMC-USED
USED		Alpha 1This field indicates whether this calendar is used by an asset-book combination. If the calendar is used (Yes), you cannot make changes to the calendar. If the calendar is not yet attached to an asset-book combination (No), you can change the calendar.
  • Y Yes
  • N No
AC160, AM115, AM117, AM125, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
AMC-ORG-YE-DATE
ORG_YE_DATE		Numeric 8 (yyyymmdd)This is the original year-end date, the year-end date before the year was defined as a short year. This is used only when defining historical calendars.AM01.1, AM01.2, AM01.3, AM192
AMC-PD-CLOSE-DATE
PD_CLOSE_DATE		DerivedThis field identifies the closing date of the last closed period.—
AMC-CURRENT-PERIOD
CURRENT_PERIOD		DerivedThis field identifies the current period.—
AMC-PD-CURR-DATE
PD_CURR_DATE		DerivedThis field identifies the ending date of the current period.—
AMC-BK-DESCRIPTION
BK_DESCRIPTION		DerivedThe book description.—
AMC-BK-CURR-CODE
BK_CURR_CODE		DerivedThe currency code assigned to the book.—
AMC-BK-STATUS
BK_STATUS		DerivedThe status of the book. Valid values are
  • A Active
  • I Inactive
—
AMC-BK-DEPR-TYPE
BK_DEPR_TYPE		Derived——
AMC-BK-CONV
BK_CONV		DerivedThis 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
BK_METH_SWITCH		DerivedThis field identifies whether the depreciation method can be switched when it is advantageous to do so.—
AMC-BK-HISTORY
BK_HISTORY		Derived——
AMC-CO-NAME
CO_NAME		DerivedThe name of the general ledger company.—
AMC-CO-CURR-CODE
CO_CURR_CODE		DerivedThe base currency defined for the company.—

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AMCSET1BOOK, COMPANY, YR-END-DATEPrimaryAC160, AM00.1, AM00.2, AM01.1, AM01.2, AM01.3, AM115, AM117 +22 more (list truncated in source)
AMCSET2BOOK, COMPANY, YR-END-DATE*AC160, AM01.1, AM01.2, AM01.3, AM115, AM117, AM125, AM145 +22 more (list truncated in source)
AMCSET3CAL-STATUS, BOOK, COMPANY, YR-END-DATEAC160, AM01.1, AM01.2, AM01.3, AM115, AM117, AM125, AM135 +22 more (list truncated in source)
AMCSET4COMPANY, BOOKSubsetWhere CAL-STATUS = "C"AC160, AM01.1, AM01.2, AM01.3, AM115, AM117, AM12.1, AM12.2 +22 more (list truncated in source)
AMCSET5BOOK, COMPANYSubsetWhere CAL-STATUS = "C"AC160, AM01.1, AM01.2, AM01.3, AM115, AM117, AM12.1, AM12.2 +22 more (list truncated in source)
AMCSET6COMPANY, BOOKSubsetWhere CAL-STATUS = "C" And REQ-BOOK = "Y"AC160, AM115, AM117, AM12.1, AM12.2, AM135, AM15.1, AM15.2 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AmbookAMBOOKRequiredAMC-BOOK → AMB-BOOK
AmcontrolAMCONTROLNot RequiredAMC-COMPANY → CTL-COMPANY
GlsystemGLSYSTEMRequiredAMC-COMPANY → GLS-COMPANY

Programs

Updated by (278)

Referenced by (61)