Asset 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
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| AMC-BOOK Element: Book | Alpha 10 The book name associated with the calendar. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting. |
|
||||||||
| AMC-COMPANY Element: Company | Numeric 4 The general ledger company number associated with the calendar. |
|
||||||||
| AMC-CAL-STATUS Element: Calendar Status | Alpha 1 This 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 |
|
||||||||
| AMC-YR-END-DATE Element: Year-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. |
|
||||||||
| AMC-YR-BEG-DATE Element: Year-Begin Date | Numeric 8 (yyyymmdd) The first date of the fiscal year. |
|
||||||||
| AMC-REQ-BOOK Element: Required Book | Alpha 1 This field indicates whether the book is a required book to be used by all new assets being added. Y = Yes N = No |
|
||||||||
| AMC-POSTING-BOOK Element: Posting Book | Alpha 1 This field indicates whether the book is a posting book that posts journal entries to the general ledger. Y = Yes N = No |
|
||||||||
| AMC-PD-PER-YR Element: Periods Per Year | Numeric 3 This field identifies the number of depreciation periods for the book for the current fiscal year. |
|
||||||||
| AMC-SHORT-YEAR Element: Short Year | Alpha 1 This field identifies whether the calendar contains a year that is shorter than a normal year. N = No Y = Yes |
|
||||||||
| AMC-NBR-DEPR-PD Depreciation Period Number | Numeric 2 Occurs 55 Times Each occurrence of this field identifies the number assigned to a depreciation period. |
|
||||||||
| AMC-PD-END-DATE Element: Period End-Date | Numeric 8 (yyyymmdd) Occurs 55 Times Each occurrence of this field identifies the ending date for a depreciation period. Once a calendar is defined, the ending dates cannot be changed. |
|
||||||||
| AMC-DEPR-PD-CLS Depreciation Period Close | Numeric 3 This field identifies the number of depreciation periods that are closed in the fiscal year. |
|
||||||||
| AMC-DEPR-RUN-CLS Depreciation Run Close | Numeric 2 This 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. |
|
||||||||
| AMC-NBR-PD-INPROC Number Periods In Process | Numeric 2 This field identifies the number of periods currently in process after AM180 (Depreciation Calculation and Listing) has run. AM190 (Period Close) resets this field. |
|
||||||||
| AMC-PD-END-INPROC In-Process Period End Date | Numeric 8 (yyyymmdd) This field identifies the ending date of the fiscal period in process. |
|
||||||||
| AMC-DEPR-CALC-FL Depreciation Calculation Flag | Alpha 1 This field identifies whether AM180 (Depreciation Calculation and Listing) has been run. N = No Y = Yes |
|||||||||
| AMC-USED Element: Used | Alpha 1 This 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 |
|||||||||
| AMC-ORG-YE-DATE Original Year-End 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. |
|
||||||||
| AMC-PD-CLOSE-DATE Element: Period Close Date | Derived This field identifies the closing date of the last closed period. |
|
||||||||
| AMC-CURRENT-PERIOD Element: Current Period | Derived This field identifies the current period. |
|
||||||||
| AMC-PD-CURR-DATE Element: Period Current Date | Derived This field identifies the ending date of the current period. |
|
||||||||
| AMC-BK-DESCRIPTION Element: Book Description | Derived The book description. |
|
||||||||
| AMC-BK-CURR-CODE Element: Currency Code | Derived The currency code assigned to the book. |
|
||||||||
| AMC-BK-STATUS Element: Status | Derived The status of the book. Valid values are A = Active I = Inactive |
|
||||||||
| AMC-BK-DEPR-TYPE Element: Bk Depr Type | Derived |
|
||||||||
| AMC-BK-CONV Element: Book Convention | Derived 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 Element: Method Switch | Derived This field identifies whether the depreciation method can be switched when it is advantageous to do so. |
|
||||||||
| AMC-BK-HISTORY Element: Bk History | Derived |
|
||||||||
| AMC-CO-NAME Element: Company Name | Derived The name of the general ledger company. |
|
||||||||
| AMC-CO-CURR-CODE Element: Currency Code | Derived The base currency defined for the company. |
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
|---|---|---|---|---|---|
| Ambook | AMBOOK |
Required
| |||
| Amcontrol | AMCONTROL |
Not Required
| |||
| Glsystem | GLSYSTEM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.