Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMBKTEMPLT


                            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