|
|
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
AC10.3 AC160 AM20.1 AM212 AP05.3 AP125
AP126 AP170 AP193 AP20.1 AP20.2 AP20.5
AP20.7 AP225 AP226 AP23.1 AP25.1 AP25.2
AP26.1 AP30.2 AP30.4 AP520 BL92.1 DR100
IC130 IC141 IC142 IC83.1 IN20.1 MA40.1
MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6
MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA520
MA530 MA540 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE810 OE830
OE920 OE950 PO100 PO135 PO180 PO20.1
PO21.1 PO21.2 PO21.3 PO21.5 PO21.6 PO22.1
PO22.2 PO22.3 PO25.1 PO25.2 PO25.4 PO26.1
PO28.6 PO30.1 PO31.1 PO32.1 PO33.1 PO34.1
PO35.1 PO530 PO821 PO990 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1 RQ20.3
RQ20.4 RQ35.1 RQ500 RQ990 WH130 WH132
WH190 WH20.2 WH20.7 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
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 WO132 WO140
UPDATED BY
AM115 AM12.1 AM15.1 AM15.2 AM15.3 AM15.4
AM958
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, AM958
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
AM958
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
AM958
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
AM958
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
AM958
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
AM958
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
AM958
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
AM958
ATM-LOCATION-NAME Alpha 15 AM115 AM12.1
Location This is the location for the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM958
ATM-DIVISION Alpha 15 AM115 AM12.1
Division This is the division for the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM958
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 AM958
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. AM958
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 AM958
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 AM958
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 AM958
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-SEGMENT-BLOCK Alpha 103 AM115 AM12.1
User Analysis This field identifies the user analysis AM15.1 AM15.2
values included in the transaction. AM15.3 AM15.4
You can either type up to four values
or use Define (F6) to open the User
Analysis Entry subform. Use this subform
to select the user analysis values you
want to include in the transaction. If
you choose to type values, use commas to
separate them. For example:
value1,value2,value3,value4
There are three conditions that affect
how you can select user analysis values.
See the User Analysis Entry form help or
the Strategic Ledger procedures manual
for additional information.
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
AM958
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
AM958
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
AM958
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.
AMTEMPLATE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATMSET1 ASSET-TEMPLATE AC10.3 AC160
AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM212
AM958 AP05.3
AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.5 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP520 BL92.1
...
AMTEMPLATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|