|
|
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
AC160 AM01.1 AM01.2 AM01.3 AM04.1 AM06.4
AM06.5 AM10.1 AM115 AM117 AM12.1 AM120
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.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 AM258 AM260 AM265 AM266
AM267 AM270 AM275 AM277 AM278 AM280
AM281 AM282 AM285 AM287 AM290 AM292
AM295 AM30.1 AM30.2 AM30.3 AM310 AM320
AM35.4 AM40.1 AM40.2 AM40.3 AM40.4 AM41.1
AM41.2 AM500 AM501 AM502 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
AM92.1 AM93.1 AM95.1 AM95.4 AM95.5 AM95.6
AM96.1 AM98.1 AM99.1 AMAS.1 AMBK.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 RQIA.1 WH20.2 WH20.7
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: Compute Name The name assigned to an arithmetic AM88.2
equation created in Compute Statement
(RW50.1). A compute statement consists
of data dictionary items and operation
symbols.
AMB-OBJ-ID Numeric 12 AM00.1 AM00.2
Element: Obj Id This is the object identifier. It is AM88.2
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 AC160 AM00.1
AM00.2 AM01.1
AM01.2 AM01.3
AM04.1 AM06.4
AM06.5 AM10.1
AM115 AM117
AM12.1 AM120
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
...
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
|
