|
|
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 AM520 AP05.3 AP115 AP125 AP126
AP131 AP170 AP193 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP305
AP520 API1.1 API2.1 DR100 IC130 IC141
IC142 IC28.1 IC83.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.5 MA43.7 MA43.8 MA43.9 MA530 MA531
MA540 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA66.3 MA67.1 MA67.2 MA68.1
MA70.1 MA75.1 MA80.1 MAI1.1 PO100 PO101
PO122 PO131 PO135 PO136 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO25.1 PO25.5 PO25.6 PO25.7 PO26.1 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.1 PO32.2 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 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1
RQ13.1 RQ35.1 RQ500 RQIB.1 RQID.1 RQIE.1
RQIF.1 RQIJ.1 WH130 WH132 WH190 WH20.2
WH20.7 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 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 WO140
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
Element: 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
Element: Asset CategoryThis 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
Element: 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
Element: Work-in-ProcesThis 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
Element: 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
Element: 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
Element: 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
Element: Location This is the location for the asset. AM15.1 AM15.2
AM15.3 AM15.4
ATM-DIVISION Alpha 15 AM115 AM12.1
Element: Division This is the division for the asset. AM15.1 AM15.2
AM15.3 AM15.4
ATM-ASSET-TYPE Alpha 10 AM115 AM12.1
Element: 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
Element: 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
Element: 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
Element: Accounting UniThis 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
Element: 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 AM15.1 AM15.2
Expense Activity AM15.3 AM15.4
ATM-DEP-ACCT-CAT Alpha 5 AM115 AM12.1
Depr Expense AM15.1 AM15.2
Account Category AM15.3 AM15.4
ATM-CREATION-DATE Numeric 8 (yyyymmdd) AM115 AM12.1
Element: 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
Element: 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
Element: 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
Element: Company DescriThis 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
Element: Location DescrThis is the location description.
ATM-DIV-DESC Derived
Element: Division DescrThis 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
Element: Au Group Desc
ATM-ACTIVITY-DESC Derived
Element: 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 AM520
AP05.3 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
...
ATMSET2 COMPANY
ASSET-TEMPLATE
ATMSET3 COMPANY AM211 AM212
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
|
