|
|
AMBKTEMPLT FILE
Book Template
This file stores detailed financial (or book-related) asset creation
parameters that are used to process quick asset additions with minimal keying
in AM20.1 (Quick Addition) and to create assets and asset books from Accounts
Payable and Activity Management interface information.
REFERENCED BY
AM20.1 AM21.1 AM212
UPDATED BY
AC160 AM115 AM117 AM12.1 AM15.1 AM15.2
AM15.3 AM15.4 AM19.1 AM19.2 AM520 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
BKT-ASSET-TEMPLATE Alpha 10 AM12.1
Element: Template Key field. A user-defined template
identifies general asset creation
parameters that you can use to quickly
add assets with minimal keying. Using a
template lets you default many data
items associated with a new asset.
You can use a template to process quick
asset additions in AM20.1 (Quick
Addition) and to create assets and asset
books from Accounts Payable and Activity
Management interface information.
Templates are required if you define new
assets as a result of transactions
interfaced from the Lawson Activity
Management or Accounts Payable systems.
BKT-BOOK Alpha 10 AM12.1 AM520
Element: Book Key field. This is the book for the
template. Books are used by assets for
calculating depreciation, replacement
cost, and insurance values, and for
reporting.
BKT-METHOD Alpha 10 AM12.1
Element: Method This is the method assigned to the
template. Methods are used to calculate
depreciation, replacement cost, and
insurance values. Standard depreciation
methods are predefined. Additional
methods can be user-defined for the
following kinds of methods: compute
statements, annual percent tables, and
units of production tables.
BKT-LIFE Numeric 4 AM12.1
Element: Life This is the asset life in months.
BKT-CONVENTION Alpha 2 AM12.1
Element: Convention This is the convention code assigned to
the template. This value determines the
amount of depreciation to take in the
first and last year. Valid values are:
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.
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. In
this case, it receives no depreciation
for the month in which it is disposed
of. If the asset is placed in service
during the last half of the month,
depreciation calculations begin the
following month. In this case, the asset
receives a full month during the month
in which it is disposed of.
Mid Month = The asset receives one-half
of one months depreciation for the month
in which it is placed in service, and
one-half of one months depreciation for
the month in which it is disposed of.
Next Month = The asset receives one full
month of depreciation in the month after
it is placed in service and one full
month of depreciation in the month it is
disposed of.
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.
Half Year = The asset receives one half
of a years depreciation for the first
year and the year it is disposed of.
Modified Half Year = If the asset is in
service before the middle of the year,
it receives a full years depreciation
during its first year, and no
depreciation during the year it is
disposed of. If the asset is placed in
service after the midpoint of the year,
depreciation begins the following year,
and the asset receives a full years
depreciation during the year it is
disposed of.
Mid Quarter = The asset receives
one-half of one quarters depreciation
for the quarter in which it is placed in
service, and one-half of one quarters
depreciation for the quarter in which it
is disposed of.
Actual Days = The asset receives
depreciation for each day it is in
service during the fiscal year,
beginning with the in-service date.
FM = Full Month
HM = Modified Half Month
AD = Actual Days
HY = Half Year
MY = Modified Half Year
MQ = Mid Quarter
MM = Mid Month
FY = Full Year
NM = Next Month
BKT-PERSONAL-USE Alpha 10 AM12.1
Element: Personal Use This is the personal use code assigned
to the template. A personal use code
defines the personal use options that
asset books use to calculate
depreciation, tax credits, and annual
depreciation limits up to twenty years.
BKT-SALV-PERCENT Signed 5.2 AM12.1
Element: Salvage PercenThis is the salvage value reduction
percentage assigned to the template. The
salvage value of the asset is reduced by
this percentage of the asset cost when
depreciation is calculated for the
asset.
BKT-BUS-PERCENT Signed 5.2 AM12.1
Element: Business PerceThe business percent usage of the
asset. If this value is less than 100
percent, the value is used in
depreciation calculations.
BKT-TC-TABLE Alpha 10 AM12.1
Element: Tax Credit TabThe tax credit table assigned to the
template. A tax credit table defines tax
credit percentages and annual tax credit
recapture percentages for up to twenty
years. Asset books use tax credit tables
to calculate tax credits.
BKT-BOOK-STATUS Alpha 1 AM12.1
Element: Book Status This field identifies whether the book
is active or inactive.
A = Active
I = Inactive
BKT-LIFE-YEARS Signed 5.2 AM12.1
Element: Life Years The total life value of an asset,
expressed in years. If this field is
left blank, the system calculates this
value by dividing the Life value by 12.
BKT-INS-METHOD Alpha 10 AM12.1
Element: Insurance MethThe method used to calculate the
insurance value of the asset. This must
be a valid insurance type method in the
Method file.
BKT-RPL-METHOD Alpha 10 AM12.1
Element: Replacement MeThe method used to calculate the
replacement cost of the asset. This must
be a valid replacement type method in
the Method file.
BKT-BOOK-CURRENCY Derived
Element: Book Currency The currency assigned to the book.
BKT-ATM-DESC Derived
Element: Template DescrThis is the description of the
template.
AMBKTEMPLT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BKTSET1 ASSET-TEMPLATE AC160 AM115
BOOK AM117 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM21.1
AM212 AM520
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
...
AMBKTEMPLT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ambook AMBOOK Required
BKT-BOOK -> AMB-BOOK
Amtemplate AMTEMPLATE Not Required
BKT-ASSET-TEMPLATE -> ATM-ASSET-TEMPLATE
|
