|
AMBOOK FILE
Asset Book Name
The Book file stores the books that asset uses for calculating depreciation,
replacement cost, and insurance values, and for reporting.
REFERENCED BY
AM01.1 AM01.2 AM01.3 AM04.1 AM06.4 AM06.5
AM10.1 AM115 AM12.1 AM120 AM125 AM135
AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM154
AM170 AM180 AM185 AM190 AM192 AM195
AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6
AM20.7 AM20.8 AM200 AM205 AM21.1 AM21.2
AM21.3 AM21.4 AM21.5 AM21.6 AM21.7 AM21.8
AM210 AM212 AM214 AM220 AM222 AM225
AM230 AM240 AM241 AM255 AM260 AM265
AM266 AM267 AM270 AM275 AM277 AM278
AM280 AM281 AM282 AM285 AM287 AM290
AM292 AM295 AM30.1 AM30.2 AM30.3 AM310
AM320 AM40.1 AM40.2 AM40.3 AM40.4 AM41.1
AM41.2 AM500 AM501 AM520 AM551 AM580
AM60.1 AM75.1 AM80.1 AM85.1 AM90.1 AM90.4
AM90.5 AM90.6 AM91.1 AM91.4 AM91.5 AM93.1
AM95.1 AM95.4 AM95.5 AM95.6 AM96.1 AM98.1
AM99.1 AMAS.1 AMBK.1 RQIA.1
UPDATED BY
AM00.1 AM00.2 AM88.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMB-BOOK Alpha 10 AM00.1 AM00.2
Element: Book A user-defined book name. Books are AM88.2
used by assets for calculating
depreciation, replacement cost, and
insurance values, and for reporting.
AMB-DESCRIPTION Alpha 30 (Lower Case) AM00.1 AM00.2
Element: Book DescriptiThe description of the book. AM88.2
AMB-BOOK-STATUS Alpha 1 AM00.1 AM00.2
Element: Book Status This field identifies the book status. AM88.2
Valid values are:
A = Active.
I = Inactive.
AMB-CONVENTION Alpha 2 AM00.1 AM00.2
Element: Convention The depreciation convention assigned to AM88.2
the book. This value is used to
determine the first and last years'
depreciation amounts to take. Valid
values are:
FM = Full Month. The asset receives a
full month of depreciation during the
month it is placed in service. The asset
does not receive any depreciation for
the month in which it is disposed of.
HM = Modified Half Month. If the asset
is placed in service during the first
half of the month, it receives one full
month of depreciation for its first
month, and receives no depreciation for
the month it is disposed of. If the
asset is placed in service during the
last half of the month, depreciation
calculations begin the following month,
and receives a full month of
depreciation the month it is disposed
of.
MM = Mid Month. The asset receives
one-half of one month's depreciation for
the month it is placed in service and
for the month it is disposed of.
NM = Next Month. The asset receives a
full month of depreciation the month
after it is placed in service and the
month it is disposed of.
HY = Half Year. The asset receives
one-half of a year's depreciation for
the first and last year it is in
service.
MY = Modified Half Year. If the asset
is placed in service before the midpoint
of the year, it receives a full year's
depreciation during its first year in
service and no depreciation the year it
is disposed of. If the asset is place in
service after the midpoint of the year,
depreciation calculations begin the
following year, and the asset receives a
full year's depreciation the year it is
disposed of.
FY = Full Year. The asset receives a
full year's depreciation the year it is
placed in service and no depreciation
the year it is disposed of.
AD = Actual Days. The asset receives
depreciation for each day it is in
service.
MQ = Mid Quarter. The asset receives
one-half of one quarter's depreciation
for the quarter it is placed in service
and for the quarter it is disposed of.
AMB-METHOD-SWITCH Alpha 1 AM00.1 AM00.2
Element: Method Switch This field indicates whether to switch AM88.2
to a second depreciation method when it
is advantageous to do so.
N = No
Y = Yes
AMB-CURRENCY-CODE Alpha 5 AM00.1 AM00.2
Element: Currency Code The currency code assigned to the book. AM88.2
AMB-TRAN-ND Numeric 1 AM00.1 AM00.2
Transaction Number The number of decimal positions defined AM88.2
of Decimals for the book currency code.
AMB-TRANS-HISTORY Alpha 1 AM00.1 AM00.2
Element: Depreciation HThis field specifies whether Asset AM88.2
Management will track transaction
history for the book. Valid values are:
Y = Yes
N = No
AMB-DEPR-TYPE-FLAG Alpha 1 AM00.1 AM00.2
Element: Depr Type FlagThis field contains the depreciation AM88.2
type of the assets associated with the
book.
Valid values are:
A = Asset
C = Class
AMB-COMPUTE-NAME Alpha 12 AM00.1 AM00.2
Element: Name User AM88.2
AMB-OBJ-ID Numeric 12 AM00.1 AM00.2
Object This is the object identifier. It is AM88.2
Identification used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
AMBOOK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMBSET1 BOOK AM00.1 AM00.2
AM01.1 AM01.2
AM01.3 AM04.1
AM06.4 AM06.5
AM10.1 AM115
AM12.1 AM120
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM180
AM185 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
...
AMBOOK FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ambooktype AMBOOKTYPE
AMB-BOOK -> ADR-BOOK
ADR-ASSET-TYPE
ADR-SUB-TYPE
Amcalendar AMCALENDAR
AMB-BOOK -> AMC-BOOK
AMC-COMPANY
AMC-YR-END-DATE
Amclassdep AMCLASSDEP
AMB-BOOK -> CLD-BOOK
CLD-ASSET-TYPE
CLD-SUB-TYPE
CLD-COMPANY
CLD-AST-ACCT-UNIT
CLD-EXP-ACCT-UNIT
CLD-ACM-ACCT-UNIT
CLD-YR-END-DATE
CLD-PERIOD
|