AMBKTEMPLT

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 AM12.2 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 AP510 API1.1 API2.1 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 DR100 IC12.1 IC140
IC141 IC142 IC145 IC243 IC330 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 MA126 MA180
MA278 MA41.1 MA41.2 MA41.4 MA41.7 MA42.1
MA42.2 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA44.1 MA44.2 MA53.1 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA69.1 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO220 PO222 PO224 PO225 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.3 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO28.2
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
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
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1
RQ500 RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.1
WH130 WH132 WH190 WH20.2 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BKT-ASSET-TEMPLATE
Element: Template
Alpha 10
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.
AM12.1 AM12.2
BKT-BOOK
Element: Book
Alpha 10
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.
AM12.1 AM12.2
AM520
BKT-METHOD
Element: Method
Alpha 10
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.
AM12.1 AM12.2
BKT-LIFE
Element: Life
Numeric 4
This is the asset life in months.
AM12.1 AM12.2
BKT-CONVENTION
Element: Convention
Alpha 2
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
AM12.1 AM12.2
BKT-PERSONAL-USE
Element: Personal Use
Alpha 10
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.
AM12.1 AM12.2
BKT-SALV-PERCENT
Element: Salvage Percent
Signed 5.2
This 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.
AM12.1 AM12.2
BKT-BUS-PERCENT
Element: Business Percent
Signed 5.2
The business percent usage of the asset. If this value is less than 100 percent, the value is used in depreciation calculations.
AM12.1 AM12.2
BKT-TC-TABLE
Element: Tax Credit Table
Alpha 10
The 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.
AM12.1 AM12.2
BKT-BOOK-STATUS
Element: Book Status
Alpha 1
This field identifies whether the book is active or inactive.
A = Active
I = Inactive
AM12.1 AM12.2
BKT-LIFE-YEARS
Element: Life Years
Signed 5.2
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.
AM12.1 AM12.2
BKT-INS-METHOD
Element: Insurance Method
Alpha 10
The method used to calculate the insurance value of the asset. This must be a valid insurance type method in the Method file.
AM12.1 AM12.2
BKT-RPL-METHOD
Element: Replacement Method
Alpha 10
The method used to calculate the replacement cost of the asset. This must be a valid replacement type method in the Method file.
AM12.1 AM12.2
BKT-BOOK-CURRENCY
Element: Book Currency
Derived
The currency assigned to the book.
BKT-ATM-DESC
Element: Template Description
Derived
This is the description of the template.


AMBKTEMPLT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BKTSET1 ASSET-TEMPLATE
BOOK
...
AC160 AM115
AM117 AM12.1
AM12.2 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


AMBKTEMPLT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ambook AMBOOK Required
BKT-BOOK->AMB-BOOK
Amtemplate AMTEMPLATE Not Required
BKT-ASSET-TEMPLATE->ATM-ASSET-TEMPLATE


File created: Thu Jun 09 02:05:18 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.