AMBKTEMPLT – Book Template

System
Asset Management (AM)
Prefix
BKT
Primary key
ASSET-TEMPLATE, BOOK
Fields
15
Updated by
245 programs
Referenced by
3 programs

AMBKTEMPLT is the Book Template table in Lawson Asset Management (prefix BKT). It is indexed by ASSET-TEMPLATE, BOOK (BKTSET1). It is related 1:1 to AMBOOK and AMTEMPLATE. It is updated by AC160, AM115, AM117, AM12.1, AM12.2, AM15.1, AM15.2, AM15.3 and 237 more and referenced by AM20.1, AM21.1 and AM212. The table has 15 fields, 1 index and 2 documented relations.

About AMBKTEMPLT

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.

Fields (15)

Column = COBOL field name without the BKT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BKT-ASSET-TEMPLATE PK
ASSET_TEMPLATE		Alpha 10Key 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 PK
BOOK		Alpha 10Key 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
METHOD		Alpha 10This 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
LIFE		Numeric 4This is the asset life in months.AM12.1, AM12.2
BKT-CONVENTION
CONVENTION		Alpha 2This 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: 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. 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. 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. year's depreciation the year it is placed in service and no depreciation the year it is disposed of. 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. 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. depreciation for each day it is in service during the fiscal year, beginning with the in-service date.
  • Full Month The asset receives a full
  • Mid Month The asset receives one-half
  • Next Month The asset receives one full
  • Full Year The asset receives a full
  • Half Year The asset receives one half
  • Mid Quarter The asset receives
  • Actual Days The asset receives
  • 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
PERSONAL_USE		Alpha 10This 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
SALV_PERCENT		Signed 5.2This 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
BUS_PERCENT		Signed 5.2The 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
TC_TABLE		Alpha 10The 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
BOOK_STATUS		Alpha 1This field identifies whether the book is active or inactive.
  • A Active
  • I Inactive
AM12.1, AM12.2
BKT-LIFE-YEARS
LIFE_YEARS		Signed 5.2The 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
INS_METHOD		Alpha 10The 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
RPL_METHOD		Alpha 10The 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
BOOK_CURRENCY		DerivedThe currency assigned to the book.—
BKT-ATM-DESC
ATM_DESC		DerivedThis is the description of the template.—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BKTSET1ASSET-TEMPLATE, BOOKPrimaryAC160, AM115, AM117, AM12.1, AM12.2, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmbookAMBOOKRequiredBKT-BOOK → AMB-BOOK
AmtemplateAMTEMPLATENot RequiredBKT-ASSET-TEMPLATE → ATM-ASSET-TEMPLATE

Programs

Updated by (245)

Referenced by (3)