AMTEMPLATE FILE
Asset Template
This file contains asset template information. It can be used to interface
asset information from the Activity Management or Accounts Payable systems.
Asset templates are defined in AM12.1 (Addition Template).
REFERENCED BY
AC06.1 AC10.3 AC160 AC460 AM20.1 AM21.1
AM212 AP05.3 AP115 AP170 AP193 AP220
AP30.2 AP30.4 AP305 AP520 API1.1 API2.1
DR100 IC130 IC141 IC142 IC83.1 MA126
MA63.1 MA65.1 MA68.1 PO135 PO136 PO26.1
POIJ.1 RQ11.1 RQ12.1 RQ13.1 WH130 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 AM211
UPDATED BY
AM115 AM12.1 AM15.1 AM15.2 AM15.3 AM15.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATM-ASSET-TEMPLATE Alpha 10 AM115 AM12.1
Template Required key. You can use an asset AM15.1 AM15.2
template to define assets for use in AM15.3 AM15.4
the Asset Management, Accounts Payable,
or Activity Management systems.
Templates identify the required
information needed to create asset
records. They are defined in AM12.1
(Addition Template).
The template is a way to create assets
with very little keying; using a
template lets you default many of the
data items associated with a new asset.
An asset template is required when you
define a new asset as the result of
transactions from the Lawson Purchase
Order, Accounts Payable, or Activity
Management systems.
ATM-DESCRIPTION Alpha 30 (Lower Case) AM115 AM12.1
Asset Template This is the asset template description. AM15.1 AM15.2
Description AM15.3 AM15.4
ATM-ASSET-CATEGORY Alpha 1 AM115 AM12.1
Asset Category This is the asset category: depreciable AM15.1 AM15.2
or nondepreciable. AM15.3 AM15.4
D = Depreciable
N = Non Depreciable
ATM-SIMULATED Alpha 1 AM115 AM12.1
Simulated This field indicates whether the asset AM15.1 AM15.2
is simulated. The default is No. AM15.3 AM15.4
N = No
Y = Yes
ATM-WORK-IN-PROC Alpha 1 AM115 AM12.1
Work-in-Process This field indicates whether the asset AM15.1 AM15.2
is work-in-process. The default is No. AM15.3 AM15.4
N = No
Y = Yes
ATM-TAX-EXEMPT Alpha 1 AM115 AM12.1
Tax Exempt This field indicates whether the asset AM15.1 AM15.2
is tax exempt. The default is No. AM15.3 AM15.4
N = No
Y = Yes
ATM-USED Alpha 1 AM115 AM12.1
Used This field indicates whether the asset AM15.1 AM15.2
is used. The default is No. AM15.3 AM15.4
N = No
Y = Yes
ATM-COMPANY Numeric 4 AM115 AM12.1
Company This is the company number for the AM15.1 AM15.2
asset. AM15.3 AM15.4
ATM-LOCATION-NAME Alpha 15 AM115 AM12.1
Location This is the location for the asset. AM15.1 AM15.2
AM15.3 AM15.4
ATM-DIVISION Alpha 15 AM115 AM12.1
Division This is the division for the asset. AM15.1 AM15.2
AM15.3 AM15.4
ATM-ASSET-TYPE Alpha 10 AM115 AM12.1
Asset Type This is the asset type. Asset types are AM15.1 AM15.2
user-defined and represent a grouping of AM15.3 AM15.4
like assets. Asset types are used to
group assets into reporting classes and
to default common asset definition data.
ATM-SUB-TYPE Alpha 10 AM115 AM12.1
Asset Subtype This is the subtype for the asset. An AM15.1 AM15.2
asset subtype represents a more detailed AM15.3 AM15.4
grouping of assets within an asset type.
Asset subtypes are used to group assets
into reporting classes and allow common
asset definition data to default.
ATM-ACCT-GRP Alpha 10 AM115 AM12.1
Account Group This is the account group for the AM15.1 AM15.2
asset. Account groups are user-defined AM15.3 AM15.4
and are used to identify general ledger
accounts used to create journal entries
when assets are processed.
ATM-ACCT-UNIT Alpha 15 AM115 AM12.1
Accounting Unit This is the accounting unit for the AM15.1 AM15.2
asset. The accounting unit must be AM15.3 AM15.4
defined in the General Ledger Names file
as a posting accounting unit.
ATM-AU-GROUP Alpha 10 AM115 AM12.1
Accounting Unit Accounting unit groups group and AM15.1 AM15.2
Group identify the accounting units to use AM15.3 AM15.4
when you create journal entries for
adding, adjusting, transferring, or
disposing of assets. Changes to
accounting unit groups are dynamic,
affecting all assets using the
accounting unit group. Accounting unit
group names are user-definable, and
accounting unit groups are set up by
company.
ATM-ACTIVITY Alpha 15 AM115 AM12.1
Activity Activities are the processes or AM15.1 AM15.2
procedures that produce work. Cost AM15.3 AM15.4
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
ATM-DEP-EXP-ACTVTY Alpha 15 AM115 AM12.1
Depreciation This is the override depreciation AM15.1 AM15.2
Expense Activity expense activity, which overrides any AM15.3 AM15.4
depreciation expense activity set up on
AM06.1 (Type). This is the depreciation
expense activity used for posting.
ATM-DEP-ACCT-CAT Alpha 5 AM115 AM12.1
Depr Expense This is the override depreciation AM15.1 AM15.2
Account Category expense account category, which AM15.3 AM15.4
overrides any depreciation expense
account category set up on AM06.1
(Type). This is the depreciation
expense account category used for
posting.
ATM-CREATION-DATE Numeric 8 (yyyymmdd) AM115 AM12.1
Creation Date This is the creation date for the asset AM15.1 AM15.2
template. AM15.3 AM15.4
ATM-CREATION-TIME Numeric 6 (hhmmss) AM115 AM12.1
Creation Time This is the creation time for the asset AM15.1 AM15.2
template. AM15.3 AM15.4
ATM-CREATOR-ID Alpha 10 AM115 AM12.1
Creator ID This is the identifier of the person AM15.1 AM15.2
who created the asset template. AM15.3 AM15.4
ATM-GL-NAME Derived
Company Description This is the description of the General
Ledger company.
ATM-GL-CURR-CODE Derived
General Ledger This is the General Ledger currency
Currency Code code.
ATM-ACCT-UNIT-DESC Derived
Accounting Unit This is the accounting unit description.
Description
ATM-ACCT-GRP-DESC Derived
Account Group This is the account group description.
Description
ATM-LOC-DESC Derived
Location Description This is the location description.
ATM-DIV-DESC Derived
Division Description This is the description of the division.
ATM-TYPE-DESC Derived
Asset Type This is the description of the asset
Description type.
ATM-AU-GROUP-DESC Derived
Au Group Desc
ATM-ACTIVITY-DESC Derived
Activity Desc
AMTEMPLATE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATMSET1 ASSET-TEMPLATE AC06.1 AC10.3
AC160 AC460
AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM21.1
AM212 AP05.3
AP115 AP170
AP193 AP220
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
DR100 IC130
IC141 IC142
IC83.1 MA126
...
ATMSET2 COMPANY
ASSET-TEMPLATE
ATMSET3 COMPANY AM211
ASSET-TYPE
SUB-TYPE
ASSET-TEMPLATE
AMTEMPLATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Not Required
ATM-ACTIVITY -> ACV-ACTIVITY
Amacctgrp AMACCTGRP Not Required
ATM-COMPANY -> AAG-COMPANY
ATM-ACCT-GRP -> AAG-ACCT-GRP
Amasttype AMASTTYPE Required
ATM-COMPANY -> ATP-COMPANY
ATM-ASSET-TYPE -> ATP-ASSET-TYPE
ATM-SUB-TYPE -> ATP-SUB-TYPE
Amaugroup AMAUGROUP Not Required
ATM-COMPANY -> AAU-COMPANY
ATM-AU-GROUP -> AAU-AU-GROUP
Amcontrol AMCONTROL Not Required
ATM-COMPANY -> CTL-COMPANY
Amdivision AMDIVISION Not Required
ATM-DIVISION -> DIV-DIVISION
Amlocation AMLOCATION Not Required
ATM-LOCATION-NAME -> LOC-LOCATION-NAME
Glnames GLNAMES Required
ATM-COMPANY -> GLN-COMPANY
ATM-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Not Required
ATM-COMPANY -> GLS-COMPANY
AMTEMPLATE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ambktemplt AMBKTEMPLT Delete Restricted
ATM-ASSET-TEMPLATE -> BKT-ASSET-TEMPLATE
BKT-BOOK
|
